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 Plain View
Hive >> mail # user >> Compression in Hive


+
Sachin Sudarshana 2013-06-10, 06:03
+
Ravi Mummulla 2013-06-10, 13:14
+
Sanjay Subramanian 2013-06-11, 23:06
+
shouvanik.haldar@... 2013-06-10, 06:43
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