Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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 !!!
>
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB