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.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
Thanks a Lot Viral !
-Adarsh
