Rebooted hive server and it now works!
Mich Talebzadeh
http://talebzadehmich.wordpress.com
Publications due shortly:
Creating in-memory Data Grid for Trading Systems with Oracle TimesTen and
Coherence Cache
NOTE: The information in this email is proprietary and confidential. This
message is for the designated recipient only, if you are not the intended
recipient, you should destroy it immediately. Any information in this
message shall not be understood as given or endorsed by Peridale Ltd, its
subsidiaries or their employees, unless expressly so stated. It is the
responsibility of the recipient to ensure that this email is virus free,
therefore neither Peridale Ltd, its subsidiaries nor their employees accept
any responsibility.
From: Mich Talebzadeh [mailto:m...@peridale.co.uk]
Sent: 06 March 2015 22:39
To: user@hive.apache.org
Subject: Show databases in beeline throws Error: Error retrieving next row
Hi,
When I log in to hive via beeline and do show databases, I get the following
errors!
Transaction isolation: TRANSACTION_REPEATABLE_READ
0: jdbc:hive2://rhes564:1/ashehadoop> show databases;
org.apache.thrift.TApplicationException: Internal error processing
FetchResults
at
org.apache.thrift.TApplicationException.read(TApplicationException.java:108)
at
org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:71)
at
org.apache.hive.service.cli.thrift.TCLIService$Client.recv_FetchResults(TCLI
Service.java:501)
at
org.apache.hive.service.cli.thrift.TCLIService$Client.FetchResults(TCLIServi
ce.java:488)
at
org.apache.hive.jdbc.HiveQueryResultSet.next(HiveQueryResultSet.java:354)
at org.apache.hive.beeline.BufferedRows.(BufferedRows.java:42)
at org.apache.hive.beeline.BeeLine.print(BeeLine.java:1696)
at org.apache.hive.beeline.Commands.execute(Commands.java:792)
at org.apache.hive.beeline.Commands.sql(Commands.java:665)
at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:914)
at org.apache.hive.beeline.BeeLine.execute(BeeLine.java:776)
at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:738)
at
org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:469)
at org.apache.hive.beeline.BeeLine.main(BeeLine.java:452)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62
)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:43)
at java.lang.reflect.Method.invoke(Method.java:483)
at org.apache.hadoop.util.RunJar.run(RunJar.java:221)
at org.apache.hadoop.util.RunJar.main(RunJar.java:136)
Error: Error retrieving next row (state=,code=0)
0: jdbc:hive2://rhes564:1/ashehadoop>
Thanks in advance
Mich
NOTE: The information in this email is proprietary and confidential. This
message is for the designated recipient only, if you are not the intended
recipient, you should destroy it immediately. Any information in this
message shall not be understood as given or endorsed by Peridale Ltd, its
subsidiaries or their employees, unless expressly so stated. It is the
responsibility of the recipient to ensure that this email is virus free,
therefore neither Peridale Ltd, its subsidiaries nor their employees accept
any responsibility.
