[
https://issues.apache.org/jira/browse/HIVE-1363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12870365#action_12870365
]
Carl Steinbach commented on HIVE-1363:
--------------------------------------
My understanding is that backticks are reserved for enclosing
identifiers that conflict with other tokens in the HQL grammar, e.g.
{code}
hive> CREATE TABLE function(stuff INT);
FAILED: Parse Error: line 1:13 mismatched input 'function' expecting Identifier
in create table statement
hive> CREATE TABLE `function`(stuff INT);
OK
hive> show tables;
OK
function
pokes
{code}
Based on this I would argue that the SHOW TABLES command currently exhibits the
expected
behavior whereas SHOW TABLE EXTENDED does not:
{code}
hive> SHOW TABLES "pokes*";
OK
pokes
hive> SHOW TABLE EXTENDED LIKE "pokes*";
FAILED: Error in metadata: MetaException(message:Got exception:
javax.jdo.JDOUserException ')' expected at character 54 in "database.name ==
dbName && ( tableName.matches("(?i)"pokes.*""))")
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask
hive> SHOW TABLES 'pokes*';
OK
pokes
hive> SHOW TABLE EXTENDED LIKE 'pokes*';
OK
hive> SHOW TABLES `pokes*`;
OK
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
Time taken: 0.579 seconds
hive>
{code}
> 'SHOW TABLE EXTENDED LIKE' command does not strip single/double quotes
> ----------------------------------------------------------------------
>
> Key: HIVE-1363
> URL: https://issues.apache.org/jira/browse/HIVE-1363
> Project: Hadoop Hive
> Issue Type: Bug
> Affects Versions: 0.5.0
> Reporter: Carl Steinbach
> Assignee: Carl Steinbach
> Fix For: 0.6.0
>
>
> {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 is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
