FAQ
+ 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
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 !!!

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupuser @
categorieshive, hadoop
postedSep 13, '11 at 3:01p
activeSep 13, '11 at 3:01p
posts1
users1
websitehive.apache.org

1 user in discussion

Ashutosh Chauhan: 1 post

People

Translate

site design / logo © 2021 Grokbase