Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Upgrade from Hive 0.9 to Hive 0.10 Heap Error on show tables;


Copy link to this message
-
Re: Upgrade from Hive 0.9 to Hive 0.10 Heap Error on show tables;
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?
>>
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB