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 >> Compression in Hive


Copy link to this message
-
Re: Compression in Hive
Shovanik,

please do not hi-jack the threads. We did see your separate thread so
please wait till someone replies on that. Or you can start a new thread
On Mon, Jun 10, 2013 at 12:13 PM, <[EMAIL PROTECTED]> wrote:

>  Hi,****
>
> ** **
>
> I am facing an issue while creating a HIVE table to map HBASE table with
> 2700+ columns. Data already present in HBASE tables. When I issue “CREATE
> EXTERNAL ..” command, I get the following error.****
>
> ** **
>
> *org.datanucleus.store.mapped.exceptions.MappedDatastoreException: INSERT
> INTO "SERDE_PARAMS" ("PARAM_VALUE","SERDE_ID","PARAM_KEY") VALUES (?,?,?) )
> *
>
> *        at
> org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:580)*
>
> *        at
> org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:3698)*
>
> *        at
> org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:253)*
>
> *        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:1352)*
>
> *        at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1138)*
>
> *        at org.apache.hadoop.hive.ql.Driver.run(Driver.java:951)*
>
> *        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:208)*
>
> *Caused by: MetaException(message:javax.jdo.JDODataStoreException: Put
> request failed : INSERT INTO "SERDE_PARAMS"
> ("PARAM_VALUE","SERDE_ID","PARAM_KEY") VALUES (?,?,?)*
>
> *NestedThrowables:*
>
> *org.datanucleus.store.mapped.exceptions.MappedDatastoreException: INSERT
> INTO "SERDE_PARAMS" ("PARAM_VALUE","SERDE_ID","PARAM_KEY") VALUES (?,?,?) )
> *
>
> *        at
> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_table(HiveMetaStore.java:1110)
> *
>
> *        at
> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_table(HiveMetaStore.java:1079)
> *
>
> *        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.RetryingHMSHandler.invoke(RetryingHMSHandler.java:105)
> *
>
> *        at $Proxy10.create_table(Unknown Source)*
>
> *        at
> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:432)
> *
>
> *        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 $Proxy11.createTable(Unknown Source)*
>
> *        at
> org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:574)*
>
> *        ... 17 more*

Nitin Pawar
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