[HIVE-1363] 'SHOW TABLE EXTENDED LIKE' command does not strip single/double quotes

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.5.0
• Fix Version/s: 0.14.0
• Component/s: Query Processor
• Assignee: Chaoyu Tang
• Reporter: Carl Steinbach
• Created: 23/May/10 03:10
• Updated: 13/Nov/14 19:43
• Resolved: 08/Sep/14 03:42

Description

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

Issue Links

• is duplicated by: HIVE-1676 show table extended like does not work well with wildcards
• is required by: SENTRY-423 Hive command "SHOW TABLE EXTENDED LIKE... " failed with NPE