[ https://issues.apache.org/jira/browse/PHOENIX-3078?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
YoungWoo Kim updated PHOENIX-3078: ---------------------------------- Summary: Hive storage handler does not work if phoenix.table.name contains the schema name (was: Hive storage handler does not work when phoenix.table.name contains the schema name) > 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 > > > 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)