You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Adarsh Sharma <ad...@orkash.com> on 2010/12/16 11:12:26 UTC
Thrift Error
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
Posted by Adarsh Sharma <ad...@orkash.com>.
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 <ad...@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
Re: Thrift Error
Posted by Viral Bajaria <vi...@gmail.com>.
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 <ad...@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
>
Re: Thrift Error
Posted by Viral Bajaria <vi...@gmail.com>.
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 <ad...@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
>