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

Switch to Plain View
Hive >> mail # user >> exception when using Hive 0.12 with MySQL metastore


+
Zhang Xiaoyu 2013-10-20, 00:06
+
Jov 2013-10-20, 02:44
Copy link to this message
-
Re: exception when using Hive 0.12 with MySQL metastore
Hi, Jov,
Thanks. I understand turn on those two properties resolve the problems. But
I run the hive 0.12 scheme script. I assume it should create all required
tables.

Johnny
On Sat, Oct 19, 2013 at 7:44 PM, Jov <[EMAIL PROTECTED]> wrote:

> jov
>
> On Oct 20, 2013 8:07 AM, "Zhang Xiaoyu" <[EMAIL PROTECTED]> wrote:
> >
> > Hi, all,
> > When I using Hive 0.12 with MySQL metastore. I set those properties in
> hive-site.xml.
> > datanucleus.autoCreateSchema = false
> > datanucleus.autoCreateTables= false
> you should set these properties to true,then hive will auto add new column.
>
> >
> > In beeline, "show tables" is fine, but create a new table got below
> exception, any idea? Since I create the metastore table by the hive 0.12
> scheme script, it shouldn't complain about the missing columns in metastore
> tables.
> >
> > Thanks,
> > Johnny
> >
> > -------------------------
> >
> > FAILED: Error in metadata:
> MetaException(message:javax.jdo.JDODataStoreException: Add request failed :
> INSERT INTO `COLUMNS_V2`
> (`CD_ID`,`FCOMMENT`,`COLUMN_NAME`,`TYPE_NAME`,`INTEGER_IDX`) VALUES
> (?,?,?,?,?)
> > at
> org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:422)
> > at
> org.datanucleus.api.jdo.JDOPersistenceManager.jdoMakePersistent(JDOPersistenceManager.java:745)
> > at
> org.datanucleus.api.jdo.JDOPersistenceManager.makePersistent(JDOPersistenceManager.java:765)
> > at
> org.apache.hadoop.hive.metastore.ObjectStore.createTable(ObjectStore.java:638)
> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> > at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> > at java.lang.reflect.Method.invoke(Method.java:601)
> > at
> org.apache.hadoop.hive.metastore.RetryingRawStore.invoke(RetryingRawStore.java:111)
> > at sun.proxy.$Proxy6.createTable(Unknown Source)
> > at
> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_table_core(HiveMetaStore.java:1081)
> > at
> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_table_with_environment_context(HiveMetaStore.java:1114)
> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> > at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> > at java.lang.reflect.Method.invoke(Method.java:601)
> > at
> org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:102)
> > at sun.proxy.$Proxy8.create_table_with_environment_context(Unknown
> Source)
> > at
> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:464)
> > at
> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:453)
> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> > at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> > at java.lang.reflect.Method.invoke(Method.java:601)
> > at
> org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:74)
> > at sun.proxy.$Proxy10.createTable(Unknown Source)
> > at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:593)
> > at org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:3784)
> > at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:256)
> > at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:144)
> > at
> org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)
> > at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1355)
> > at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1139)
> > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:945)
> > at
> org.apache.hive.service.cli.operation.SQLOperation.run(SQLOperation.java:95)
+
Jov 2013-10-20, 06:56
+
SF Hadoop 2013-10-23, 20:09
+
Timothy Potter 2013-10-23, 20:22
+
SF Hadoop 2013-10-23, 21:27
+
SF Hadoop 2013-10-23, 21:40