Jason Dere created HIVE-6467:
--------------------------------
Summary: Metastore DBS.OWNER_TYPE value got spaces at the end
Key: HIVE-6467
URL: https://issues.apache.org/jira/browse/HIVE-6467
Project: Hive
Issue Type: Bug
Components: Metastore
Reporter: Jason Dere
Trying to tinker with the metastore upgrade scripts and did the following steps
on a brand new Derby DB:
>From derby:
{noformat}
run 'hive-schema-0.12.0.derby.sql';
run 'upgrade-0.12.0-to-0.13.0.derby.sql';
{noformat}
>From Hive:
{noformat}
show tables;
{noformat}
I then hit the following error below. It appears that in the metastore DBS
table, the row with defaultdb was created with the value "ROLE ", with
spaces at the end, where it was expecting "ROLE".
{noformat}
2014-02-19 14:49:19,824 ERROR metastore.RetryingHMSHandler
(RetryingHMSHandler.java:invoke(143)) - java.lang.IllegalArgumentException: No
enum const class org.apache.hadoop.hive.metastore.api.PrincipalType.ROLE
at java.lang.Enum.valueOf(Enum.java:196)
at
org.apache.hadoop.hive.metastore.api.PrincipalType.valueOf(PrincipalType.java:14)
at
org.apache.hadoop.hive.metastore.ObjectStore.getDatabase(ObjectStore.java:521)
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.RawStoreProxy.invoke(RawStoreProxy.java:108)
at com.sun.proxy.$Proxy7.getDatabase(Unknown Source)
at
org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_database(HiveMetaStore.java:753)
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 com.sun.proxy.$Proxy8.get_database(Unknown Source)
at
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getDatabase(HiveMetaStoreClient.java:895)
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:89)
at com.sun.proxy.$Proxy9.getDatabase(Unknown Source)
at org.apache.hadoop.hive.ql.metadata.Hive.getDatabase(Hive.java:1150)
at
org.apache.hadoop.hive.ql.metadata.Hive.databaseExists(Hive.java:1139)
at org.apache.hadoop.hive.ql.exec.DDLTask.showTables(DDLTask.java:2372)
at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:354)
at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:153)
at
org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:65)
at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1566)
at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1339)
at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1170)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1010)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1000)
at
org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:268)
at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:220)
at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:424)
at
org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:793)
at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:687)
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:626)
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:212)
{noformat}
--
This message was sent by Atlassian JIRA
(v6.1.5#6160)
