[
https://issues.apache.org/jira/browse/PHOENIX-3078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15381273#comment-15381273
]
Hadoop QA commented on PHOENIX-3078:
------------------------------------
{color:red}-1 overall{color}. Here are the results of testing the latest
attachment
http://issues.apache.org/jira/secure/attachment/12818445/PHOENIX-3078.1.patch
against master branch at commit e5a8dca90c369320ee12098e42f856626f2c9d69.
ATTACHMENT ID: 12818445
{color:green}+1 @author{color}. The patch does not contain any @author
tags.
{color:red}-1 tests included{color}. The patch doesn't appear to include
any new or modified tests.
Please justify why no new tests are needed for this
patch.
Also please list what manual steps were performed to
verify this patch.
{color:green}+1 javac{color}. The applied patch does not increase the
total number of javac compiler warnings.
{color:red}-1 javadoc{color}. The javadoc tool appears to have generated
35 warning messages.
{color:green}+1 release audit{color}. The applied patch does not increase
the total number of release audit warnings.
{color:green}+1 lineLengths{color}. The patch does not introduce lines
longer than 100
{color:green}+1 core tests{color}. The patch passed unit tests in .
Test results:
https://builds.apache.org/job/PreCommit-PHOENIX-Build/449//testReport/
Javadoc warnings:
https://builds.apache.org/job/PreCommit-PHOENIX-Build/449//artifact/patchprocess/patchJavadocWarnings.txt
Console output:
https://builds.apache.org/job/PreCommit-PHOENIX-Build/449//console
This message is automatically generated.
> Hive storage handler does not work if phoenix.table.name contains the schema
> name
> ---------------------------------------------------------------------------------
>
> Key: PHOENIX-3078
> URL: https://issues.apache.org/jira/browse/PHOENIX-3078
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.8.0
> Environment: Hadoop 2.7.1, Hive 1.2.1 and Phoenix 4.8.0(RC0)
> Reporter: YoungWoo Kim
> Fix For: 4.8.1
>
> Attachments: PHOENIX-3078.1.patch
>
>
> Hive integration added to Phoenix from PHOENIX-2743 but if I create an
> internal or external Hive table with Phoenix schema, Hive returns errors like
> following:
> {noformat}
> 2016-07-17 16:02:25,898 ERROR [HiveServer2-Background-Pool: Thread-202]:
> operation.Operation (SQLOperation.java:run(209)) - Error running hive query:
> org.apache.hive.service.cli.HiveSQLException: Error while processing
> statement: FAILED: Execution Error, return code 1 from
> org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Phoenix table
> bigstats.bigstats_cd doesn't exist)
> at
> org.apache.hive.service.cli.operation.Operation.toSQLException(Operation.java:315)
> at
> org.apache.hive.service.cli.operation.SQLOperation.runQuery(SQLOperation.java:156)
> at
> org.apache.hive.service.cli.operation.SQLOperation.access$100(SQLOperation.java:71)
> at
> org.apache.hive.service.cli.operation.SQLOperation$1$1.run(SQLOperation.java:206)
> at java.security.AccessController.doPrivileged(Native Method)
> at javax.security.auth.Subject.doAs(Subject.java:422)
> at
> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1657)
> at
> org.apache.hive.service.cli.operation.SQLOperation$1.run(SQLOperation.java:218)
> at
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: org.apache.hadoop.hive.ql.metadata.HiveException:
> MetaException(message:Phoenix table myschema.mytbl doesn't exist)
> at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:720)
> at org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:4135)
> at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:306)
> at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:160)
> at
> org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:88)
> at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1653)
> at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1412)
> at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1195)
> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1059)
> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1054)
> at
> org.apache.hive.service.cli.operation.SQLOperation.runQuery(SQLOperation.java:154)
> ... 11 more
> Caused by: MetaException(message:Phoenix table myschema.mytbl doesn't exist)
> at
> org.apache.phoenix.hive.PhoenixMetaHook.preCreateTable(PhoenixMetaHook.java:63)
> at
> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:664)
> at
> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:657)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at
> org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:156)
> at com.sun.proxy.$Proxy6.createTable(Unknown Source)
> at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:714)
> ... 21 more
> {noformat}
> This is my Hive DDL for the table:
> {code}
> create external table test.hive_e_phoenix1 (
> scd string,
> scddesc string
> )
> STORED BY 'org.apache.phoenix.hive.PhoenixStorageHandler'
> TBLPROPERTIES (
> 'phoenix.table.name'='myschema.mytbl',
> 'phoenix.zookeeper.quorum'='node1,node2,node3',
> 'phoenix.rowkeys'='scd'
> );
> {code}
> Looks like the storage handler does not handle schema name properly.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
