[
https://issues.apache.org/jira/browse/HIVE-6853?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13964698#comment-13964698
]
Hive QA commented on HIVE-6853:
-------------------------------
{color:green}Overall{color}: +1 all checks pass
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12639336/HIVE-6853.patch
{color:green}SUCCESS:{color} +1 5556 tests passed
Test results:
http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/2194/testReport
Console output:
http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/2194/console
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12639336
> show create table for hbase tables should exclude LOCATION
> -----------------------------------------------------------
>
> Key: HIVE-6853
> URL: https://issues.apache.org/jira/browse/HIVE-6853
> Project: Hive
> Issue Type: Bug
> Components: StorageHandler
> Affects Versions: 0.10.0
> Reporter: Miklos Christine
> Attachments: HIVE-6853-0.patch, HIVE-6853.patch
>
>
> If you create a table on top of hbase in hive and issue a "show create table
> <hbase_table>", it gives a bad DDL. It should not show LOCATION:
>
>
> [hive]$ cat /tmp/test_create.sql
> CREATE EXTERNAL TABLE nba_twitter.hbase2(
> key string COMMENT 'from deserializer',
> name string COMMENT 'from deserializer',
> pdt string COMMENT 'from deserializer',
> service string COMMENT 'from deserializer',
> term string COMMENT 'from deserializer',
> update1 string COMMENT 'from deserializer')
> ROW FORMAT SERDE
> 'org.apache.hadoop.hive.hbase.HBaseSerDe'
> STORED BY
> 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
> WITH SERDEPROPERTIES (
> 'serialization.format'='1',
> 'hbase.columns.mapping'=':key,srv:name,srv:pdt,srv:service,srv:term,srv:update')
> LOCATION
> 'hdfs://nameservice1/user/hive/warehouse/nba_twitter.db/hbase'
> TBLPROPERTIES (
> 'hbase.table.name'='NBATwitter',
> 'transient_lastDdlTime'='1386172188')
> Trying to create a table using the above fails:
> [hive]$ hive -f /tmp/test_create.sql
> cli "-f /tmp/test_create.sql"
> Logging initialized using configuration in
> jar:file:/opt/cloudera/parcels/CDH-4.4.0-1.cdh4.4.0.p0.39/lib/hive/lib/hive-common-0.10.0-cdh4.4.0.jar!/hive-log4j.properties
> FAILED: Error in metadata: MetaException(message:LOCATION may not be
> specified for HBase.)
> FAILED: Execution Error, return code 1 from
> org.apache.hadoop.hive.ql.exec.DDLTask
> However, if I remove the LOCATION, then the DDL is valid.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
