You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Jason Dere (JIRA)" <ji...@apache.org> on 2014/02/20 00:48:20 UTC
[jira] [Updated] (HIVE-6467) metastore upgrade script
016-HIVE-6386.derby.sql uses char rather than varchar
[ https://issues.apache.org/jira/browse/HIVE-6467?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jason Dere updated HIVE-6467:
-----------------------------
Summary: metastore upgrade script 016-HIVE-6386.derby.sql uses char rather than varchar (was: Metastore DBS.OWNER_TYPE value got spaces at the end)
> metastore upgrade script 016-HIVE-6386.derby.sql uses char rather than varchar
> ------------------------------------------------------------------------------
>
> Key: HIVE-6467
> URL: https://issues.apache.org/jira/browse/HIVE-6467
> Project: Hive
> Issue Type: Bug
> Components: Metastore
> Reporter: Jason Dere
> Assignee: Jason Dere
> Attachments: HIVE-6467.1.patch
>
>
> 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)