hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Carl Steinbach (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-1363) 'SHOW TABLE EXTENDED LIKE' command does not strip single/double quotes
Date Sun, 23 May 2010 07:51:16 GMT

    [ 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.


Mime
View raw message