hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jason Dere (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-6467) Metastore DBS.OWNER_TYPE value got spaces at the end
Date Wed, 19 Feb 2014 23:40:19 GMT

    [ https://issues.apache.org/jira/browse/HIVE-6467?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13906289#comment-13906289
] 

Jason Dere commented on HIVE-6467:
----------------------------------

I think this has to do with the Derby metastore upgrade script 016-HIVE-6386.derby.sql - it
specifies CHAR type whereas package.jdo specifies that these columns are supposed to be varchar:

{noformat}
ALTER TABLE "DBS" ADD "OWNER_NAME" CHAR(128);
ALTER TABLE "DBS" ADD "OWNER_TYPE" CHAR(10);
{noformat}


> 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)

Mime
View raw message