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.com>wrote: > 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 >
