Return-Path: X-Original-To: apmail-hive-dev-archive@www.apache.org Delivered-To: apmail-hive-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 38A64107FE for ; Wed, 19 Feb 2014 23:46:25 +0000 (UTC) Received: (qmail 84132 invoked by uid 500); 19 Feb 2014 23:46:21 -0000 Delivered-To: apmail-hive-dev-archive@hive.apache.org Received: (qmail 84079 invoked by uid 500); 19 Feb 2014 23:46:20 -0000 Mailing-List: contact dev-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hive.apache.org Delivered-To: mailing list dev@hive.apache.org Received: (qmail 83947 invoked by uid 500); 19 Feb 2014 23:46:20 -0000 Delivered-To: apmail-hadoop-hive-dev@hadoop.apache.org Received: (qmail 83936 invoked by uid 99); 19 Feb 2014 23:46:19 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 19 Feb 2014 23:46:19 +0000 Date: Wed, 19 Feb 2014 23:46:19 +0000 (UTC) From: "Jason Dere (JIRA)" To: hive-dev@hadoop.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (HIVE-6467) Metastore DBS.OWNER_TYPE value got spaces at the end MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/HIVE-6467?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jason Dere updated HIVE-6467: ----------------------------- Status: Patch Available (was: Open) > 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 > 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)