[ https://issues.apache.org/jira/browse/HIVE-6467?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13908369#comment-13908369 ]
Hive QA commented on HIVE-6467: ------------------------------- {color:red}Overall{color}: -1 at least one tests failed Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12629932/HIVE-6467.1.patch {color:red}ERROR:{color} -1 due to 4 failed/errored test(s), 5141 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestMinimrCliDriver.testCliDriver_parallel_orderby org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_insert_into5 org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_insert_into6 org.apache.hadoop.hive.cli.TestNegativeMinimrCliDriver.testNegativeCliDriver_mapreduce_stack_trace_hadoop20 {noformat} Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/1433/testReport Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/1433/console Messages: {noformat} Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 4 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12629932 > 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)