phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hadoop QA (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-3078) Hive storage handler does not work if phoenix.table.name contains the schema name
Date Sun, 17 Jul 2016 10:20:20 GMT

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

Mime
View raw message