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