[
https://issues.apache.org/jira/browse/HIVE-1363?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Chaoyu Tang updated HIVE-1363:
------------------------------
Attachment: HIVE-1363.2.patch
The describe_table_json.q test failure is related to the change from this
patch. Actually the original test output seemed not right. For the query SHOW
TABLE EXTENDED LIKE 'json*', it returned empty results and its output in json
was {"tables":[]}. But the expected result should have one entry for table
jsontable, and the output should look like following, which is to be masked in
its q.out file.
==
{"tables":[{"minFileSize":0,"totalNumberFiles":0,"location":"file:/user/hive/warehouse/apache/jsontable","outputFormat":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat","lastAccessTime":0,"lastUpdateTime":1410049821000,"columns":[{"name":"key","type":"int"},{"name":"value","type":"string"}],"maxFileSize":0,"partitioned":false,"tableName":"jsontable","owner":"ctang","inputFormat":"org.apache.hadoop.mapred.TextInputFormat","totalFileSize":0}]}
==
Change describe_table_json.q.out to reflect the expected query output and
uploaded a new patch.
> 'SHOW TABLE EXTENDED LIKE' command does not strip single/double quotes
> ----------------------------------------------------------------------
>
> Key: HIVE-1363
> URL: https://issues.apache.org/jira/browse/HIVE-1363
> Project: Hive
> Issue Type: Bug
> Affects Versions: 0.5.0, 0.14.0
> Reporter: Carl Steinbach
> Assignee: Chaoyu Tang
> Fix For: 0.14.0
>
> Attachments: HIVE-1363.1.patch, HIVE-1363.2.patch, HIVE-1363.patch
>
>
> {code}
> hive> SHOW TABLE EXTENDED LIKE pokes;
> OK
> tableName:pokes
> owner:carl
> location:hdfs://localhost/user/hive/warehouse/pokes
> inputformat:org.apache.hadoop.mapred.TextInputFormat
> outputformat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
> columns:struct columns { i32 num}
> partitioned:false
> partitionColumns:
> totalNumberFiles:0
> totalFileSize:0
> maxFileSize:0
> minFileSize:0
> lastAccessTime:0
> lastUpdateTime:1274517075221
> hive> SHOW TABLE EXTENDED LIKE "p*";
> FAILED: Error in metadata: MetaException(message:Got exception:
> javax.jdo.JDOUserException ')' expected at character 54 in "database.name ==
> dbName && ( tableName.matches("(?i)"p.*""))")
> FAILED: Execution Error, return code 1 from
> org.apache.hadoop.hive.ql.exec.DDLTask
> hive> SHOW TABLE EXTENDED LIKE 'p*';
> OK
> hive> SHOW TABLE EXTENDED LIKE `p*`;
> OK
> tableName:pokes
> owner:carl
> location:hdfs://localhost/user/hive/warehouse/pokes
> inputformat:org.apache.hadoop.mapred.TextInputFormat
> outputformat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
> columns:struct columns { i32 num}
> partitioned:false
> partitionColumns:
> totalNumberFiles:0
> totalFileSize:0
> maxFileSize:0
> minFileSize:0
> lastAccessTime:0
> lastUpdateTime:1274517075221
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
