You are viewing a plain text version of this content. The canonical link for it is here.
Posted to common-user@hadoop.apache.org by Kumar Jayapal <kj...@gmail.com> on 2015/04/02 03:57:50 UTC
Fwd: HMS error

Hello All,

Did any one got this error before.  I am working on database migration
task  from postgresql to MySQL.

 Here is what I did.

I took the dumps using PG_DUMP from PostgreSQL and converted it to
MySQL using PHP script.

 I don't see any error in creating the tables in MySQL db. I created
the database and user, granted the permission to user hive. When I
changed the configuration  and restarted the HMS service It errors
out. Please see the error log below.

2015-04-01 16:40:34,190 INFO
org.apache.hadoop.hive.metastore.HiveMetaStore: Starting hive
metastore on port 9083
2015-04-01 16:40:35,038 INFO
org.apache.hadoop.security.UserGroupInformation: Login successful for
user hive/hmscdh01094p001.corp.costco.com@SYSTEMS.COSTCO.COM using
keytab file hive.keytab
2015-04-01 16:40:35,055 INFO
org.apache.hadoop.hive.metastore.HiveMetaStore: 0: Opening raw store
with implemenation class:org.apache.hadoop.hive.metastore.ObjectStore
2015-04-01 16:40:35,116 INFO
org.apache.hadoop.hive.metastore.ObjectStore: ObjectStore, initialize
called
2015-04-01 16:40:35,526 INFO DataNucleus.Persistence: Property
hive.metastore.integral.jdo.pushdown unknown - will be ignored
2015-04-01 16:40:35,526 INFO DataNucleus.Persistence: Property
datanucleus.cache.level2 unknown - will be ignored
2015-04-01 16:40:36,261 INFO
org.apache.hadoop.hive.metastore.ObjectStore: Setting MetaStore object
pin classes with
hive.metastore.cache.pinobjtypes="Table,StorageDescriptor,SerDeInfo,Partition,Database,Type,FieldSchema,Order"
2015-04-01 16:40:37,713 INFO DataNucleus.Datastore: The class
"org.apache.hadoop.hive.metastore.model.MFieldSchema" is tagged as
"embedded-only" so does not have its own datastore table.
2015-04-01 16:40:37,714 INFO DataNucleus.Datastore: The class
"org.apache.hadoop.hive.metastore.model.MOrder" is tagged as
"embedded-only" so does not have its own datastore table.
2015-04-01 16:40:37,864 INFO DataNucleus.Datastore: The class
"org.apache.hadoop.hive.metastore.model.MFieldSchema" is tagged as
"embedded-only" so does not have its own datastore table.
2015-04-01 16:40:37,864 INFO DataNucleus.Datastore: The class
"org.apache.hadoop.hive.metastore.model.MOrder" is tagged as
"embedded-only" so does not have its own datastore table.
2015-04-01 16:40:38,160 INFO DataNucleus.Query: Reading in results for
query "org.datanucleus.store.rdbms.query.SQLQuery@0" since the
connection used is closing
2015-04-01 16:40:38,168 INFO
org.apache.hadoop.hive.metastore.ObjectStore: Initialized ObjectStore
2015-04-01 16:40:38,365 WARN
org.apache.hadoop.hive.metastore.ObjectStore: Metastore version was
0.13.0 hive.metastore.schema.verification is not enabled so recording
the new schema version 0.13.0
2015-04-01 16:40:38,408 ERROR
org.apache.hadoop.hive.metastore.HiveMetaStore:
java.lang.IllegalArgumentException: No enum constant
org.apache.hadoop.hive.metastore.api.PrincipalType.N
        at java.lang.Enum.valueOf(Enum.java:236)
        at org.apache.hadoop.hive.metastore.api.PrincipalType.valueOf(PrincipalType.java:14)
        at org.apache.hadoop.hive.metastore.ObjectStore.getDatabase(ObjectStore.java:520)
        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:606)
        at org.apache.hadoop.hive.metastore.RawStoreProxy.invoke(RawStoreProxy.java:108)
        at com.sun.proxy.$Proxy8.getDatabase(Unknown Source)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB_core(HiveMetaStore.java:511)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:532)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:406)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.<init>(HiveMetaStore.java:365)
        at org.apache.hadoop.hive.metastore.HiveMetaStore.startMetaStore(HiveMetaStore.java:5165)
        at org.apache.hadoop.hive.metastore.HiveMetaStore.main(HiveMetaStore.java:5093)
        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:606)
        at org.apache.hadoop.util.RunJar.main(RunJar.java:212)

2015-04-01 16:40:38,409 ERROR
org.apache.hadoop.hive.metastore.HiveMetaStore: Metastore Thrift
Server threw an exception...
java.lang.IllegalArgumentException: No enum constant
org.apache.hadoop.hive.metastore.api.PrincipalType.N
        at java.lang.Enum.valueOf(Enum.java:236)
        at org.apache.hadoop.hive.metastore.api.PrincipalType.valueOf(PrincipalType.java:14)
        at org.apache.hadoop.hive.metastore.ObjectStore.getDatabase(ObjectStore.java:520)
        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:606)
        at org.apache.hadoop.hive.metastore.RawStoreProxy.invoke(RawStoreProxy.java:108)
        at com.sun.proxy.$Proxy8.getDatabase(Unknown Source)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB_core(HiveMetaStore.java:511)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:532)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:406)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.<init>(HiveMetaStore.java:365)
        at org.apache.hadoop.hive.metastore.HiveMetaStore.startMetaStore(HiveMetaStore.java:5165)
        at org.apache.hadoop.hive.metastore.HiveMetaStore.main(HiveMetaStore.java:5093)
        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:606)
        at org.apache.hadoop.util.RunJar.main(RunJar.java:212)
<span class="sewdr74hz9es1nu"><br></span>>


Thanks
kumar