Re: Thrift Error
Adarsh, hive and hadoop both ship with the libthrift.jar and libfb303.jar, you should locate the 1's shipped with hadoop and move them to some other folder or rename them. for me the location for this libraries were as follows libthrift.jar : /usr/lib/hadoop/lib/ libfb303.jar : /usr/lib/hive/lib/ See if this issue solves the problem. I have faced this issue earlier when accessing hive over a thrift server. Thanks, Viral On Thu, Dec 16, 2010 at 2:12 AM, Adarsh Sharma adarsh.sha...@orkash.comwrote: Hi all, I am googled a lot about the below error but can't able to find the root cause. I am selecting data from Hive table website_master but it results in below error : Hibernate: select website_ma0_.s_no as col_0_0_ from website_master1 website_ma0_ org.apache.thrift.TApplicationException: Invalid method name: 'getThriftSchema' at org.apache.thrift.TApplicationException.read(TApplicationException.java:107) at org.apache.hadoop.hive.service.ThriftHive$Client.recv_getThriftSchema(ThriftHive.java:247) at org.apache.hadoop.hive.service.ThriftHive$Client.getThriftSchema(ThriftHive.java:231) at org.apache.hadoop.hive.jdbc.HiveQueryResultSet.initDynamicSerde(HiveQueryResultSet.java:76) at org.apache.hadoop.hive.jdbc.HiveQueryResultSet.init(HiveQueryResultSet.java:57) at org.apache.hadoop.hive.jdbc.HiveQueryResultSet.init(HiveQueryResultSet.java:48) at org.apache.hadoop.hive.jdbc.HivePreparedStatement.executeImmediate(HivePreparedStatement.java:194) at org.apache.hadoop.hive.jdbc.HivePreparedStatement.executeQuery(HivePreparedStatement.java:151) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:107) at org.hibernate.loader.Loader.getResultSet(Loader.java:1183) at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:381) at org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl.java:278) at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:865) at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:41) at SelectClauseExample.main(SelectClauseExample.java:25) 10/12/16 14:06:55 WARN jdbc.AbstractBatcher: exception clearing maxRows/queryTimeout java.sql.SQLException: Method not supported at org.apache.hadoop.hive.jdbc.HivePreparedStatement.getQueryTimeout(HivePreparedStatement.java:926) at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:185) at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:123) at org.hibernate.loader.Loader.getResultSet(Loader.java:1191) at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:381) at org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl.java:278) at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:865) at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:41) at SelectClauseExample.main(SelectClauseExample.java:25) 10/12/16 14:06:55 WARN util.JDBCExceptionReporter: SQL Error: 0, SQLState: null 10/12/16 14:06:55 ERROR util.JDBCExceptionReporter: Could not create ResultSet: Invalid method name: 'getThriftSchema' could not execute query using iterate Can someone Please tell me why this occurs and how to resolve it. Thanks Regards Adarsh Sharma
Re: Thrift Error
Viral Bajaria wrote: Adarsh, hive and hadoop both ship with the libthrift.jar and libfb303.jar, you should locate the 1's shipped with hadoop and move them to some other folder or rename them. for me the location for this libraries were as follows libthrift.jar : /usr/lib/hadoop/lib/ libfb303.jar : /usr/lib/hive/lib/ See if this issue solves the problem. I have faced this issue earlier when accessing hive over a thrift server. Thanks, Viral On Thu, Dec 16, 2010 at 2:12 AM, Adarsh Sharma adarsh.sha...@orkash.comwrote: Hi all, I am googled a lot about the below error but can't able to find the root cause. I am selecting data from Hive table website_master but it results in below error : Hibernate: select website_ma0_.s_no as col_0_0_ from website_master1 website_ma0_ org.apache.thrift.TApplicationException: Invalid method name: 'getThriftSchema' at org.apache.thrift.TApplicationException.read(TApplicationException.java:107) at org.apache.hadoop.hive.service.ThriftHive$Client.recv_getThriftSchema(ThriftHive.java:247) at org.apache.hadoop.hive.service.ThriftHive$Client.getThriftSchema(ThriftHive.java:231) at org.apache.hadoop.hive.jdbc.HiveQueryResultSet.initDynamicSerde(HiveQueryResultSet.java:76) at org.apache.hadoop.hive.jdbc.HiveQueryResultSet.init(HiveQueryResultSet.java:57) at org.apache.hadoop.hive.jdbc.HiveQueryResultSet.init(HiveQueryResultSet.java:48) at org.apache.hadoop.hive.jdbc.HivePreparedStatement.executeImmediate(HivePreparedStatement.java:194) at org.apache.hadoop.hive.jdbc.HivePreparedStatement.executeQuery(HivePreparedStatement.java:151) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:107) at org.hibernate.loader.Loader.getResultSet(Loader.java:1183) at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:381) at org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl.java:278) at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:865) at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:41) at SelectClauseExample.main(SelectClauseExample.java:25) 10/12/16 14:06:55 WARN jdbc.AbstractBatcher: exception clearing maxRows/queryTimeout java.sql.SQLException: Method not supported at org.apache.hadoop.hive.jdbc.HivePreparedStatement.getQueryTimeout(HivePreparedStatement.java:926) at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:185) at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:123) at org.hibernate.loader.Loader.getResultSet(Loader.java:1191) at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:381) at org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl.java:278) at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:865) at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:41) at SelectClauseExample.main(SelectClauseExample.java:25) 10/12/16 14:06:55 WARN util.JDBCExceptionReporter: SQL Error: 0, SQLState: null 10/12/16 14:06:55 ERROR util.JDBCExceptionReporter: Could not create ResultSet: Invalid method name: 'getThriftSchema' could not execute query using iterate Can someone Please tell me why this occurs and how to resolve it. Thanks Regards Adarsh Sharma Thanks a Lot Viral ! -Adarsh