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
