phoenix-dev mailing list archives

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

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

Sergey Soldatov commented on PHOENIX-3078:
------------------------------------------

Committed to master and 4.x branches. 

> 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
>            Assignee: 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