Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive, mail # user - Upgrade from Hive 0.9 to Hive 0.10 Heap Error on show tables;


+
John Omernik 2013-04-03, 21:57
+
Richard Nadeau 2013-04-03, 23:59
Copy link to this message
-
Re: Upgrade from Hive 0.9 to Hive 0.10 Heap Error on show tables;
John Omernik 2013-04-04, 01:19
Ya, the issue ended up being I had some thirft settings that came with
previous versions of MapR

!-- <property>
    <name>hive.metastore.local</name>
    <value>true</value>
    <description>controls whether to connect to remove metastore server or
open a new metastore server in Hive Client JVM</description>
 </property>
-->
<!--
 <property>
    <name>hive.metastore.uris</name>
    <value>thrift://localhost:3306</value>
 </property>
-->

Once commented out, it worked... *shrug* I did read some stuff about these
settings changing in 0.10
On Wed, Apr 3, 2013 at 6:59 PM, Richard Nadeau <[EMAIL PROTECTED]> wrote:

> Hi John,
>
> Do you have a copy of the MySQL JDBC driver in your Hive library path?
>
> Rick
> On Apr 3, 2013 3:57 PM, "John Omernik" <[EMAIL PROTECTED]> wrote:
>
>> Not sure what the issues is, conf is good, validated I can log in to
>> mysql with username in the hive-site, and I ran the metastore update
>> scripts.
>>
>> show tables;
>> java.lang.OutOfMemoryError: Java heap space
>>  at
>> org.apache.thrift.protocol.TBinaryProtocol.readStringBody(TBinaryProtocol.java:353)
>> at
>> org.apache.thrift.protocol.TBinaryProtocol.readMessageBegin(TBinaryProtocol.java:215)
>>  at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:69)
>> at
>> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_get_database(ThriftHiveMetastore.java:412)
>>  at
>> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_database(ThriftHiveMetastore.java:399)
>> at
>> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getDatabase(HiveMetaStoreClient.java:736)
>>  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>  at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>> at java.lang.reflect.Method.invoke(Method.java:597)
>>  at
>> org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:74)
>> at $Proxy6.getDatabase(Unknown Source)
>>  at org.apache.hadoop.hive.ql.metadata.Hive.getDatabase(Hive.java:1110)
>> at org.apache.hadoop.hive.ql.metadata.Hive.databaseExists(Hive.java:1099)
>>  at org.apache.hadoop.hive.ql.exec.DDLTask.showTables(DDLTask.java:2206)
>> at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:334)
>>  at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:138)
>> at
>> org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)
>>  at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1336)
>> at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1122)
>>  at org.apache.hadoop.hive.ql.Driver.run(Driver.java:935)
>> at
>> org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:259)
>>  at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:216)
>> at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:412)
>>  at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:755)
>> at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:613)
>>  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>  at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>> at java.lang.reflect.Method.invoke(Method.java:597)
>>  at org.apache.hadoop.util.RunJar.main(RunJar.java:197)
>> FAILED: Execution Error, return code -101 from
>> org.apache.hadoop.hive.ql.exec.DDLTask
>>
>>
>> Thoughts?
>>
>