Home | About | Sematext search-lucene.com search-hadoop.com
 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