Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Re: Hive issue


+ user@hive

Siddharth,

>> java.sql.SQLException: Method not supported
>> at
org.apache.hadoop.hive.jdbc.HiveConnection.createStatement(HiveConnection.java:207)

Hive's jdbc implementation is not fully jdbc compliant yet and doesn't
support all the features.

Hope it helps,
Ashutosh
On Tue, Sep 13, 2011 at 06:22, Siddharth Tiwari
<[EMAIL PROTECTED]>wrote:

>  Hi ashutosh,
>
> The error was the same I didnt had my core jar in path but now I tried to
> run a simple query SELECT gener FROM gener_liking2; through reprt designer
> and it threw following error:
>
> org.pentaho.reporting.engine.classic.core.ReportDataFactoryException:
> Failed at query: SELECT gener from 'gener_liking2';
>
> at
> org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:254)
> at
> org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:95)
> at
> org.pentaho.reporting.ui.datasources.jdbc.ui.JdbcPreviewWorker.run(JdbcPreviewWorker.java:103)
> at java.lang.Thread.run(Thread.java:679)
> ParentException:
> java.sql.SQLException: Method not supported
> at
> org.apache.hadoop.hive.jdbc.HiveConnection.createStatement(HiveConnection.java:207)
> at
> org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.parametrizeAndQuery(SimpleSQLReportDataFactory.java:333)
> at
> org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:250)
> at
> org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:95)
> at
> org.pentaho.reporting.ui.datasources.jdbc.ui.JdbcPreviewWorker.run(JdbcPreviewWorker.java:103)
> at java.lang.Thread.run(Thread.java:679)
>
> please help
>
> **------------------------**
> *Cheers !!!*
> *Siddharth Tiwari*
> Have a refreshing day !!!
>
>