[
https://issues.apache.org/jira/browse/HIVE-667?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12747766#action_12747766
]
Zheng Shao commented on HIVE-667:
---------------------------------
Some issues:
{code}
show table extended like mytablename;
{code}
It passed compilation but does not show any tables. We should support both
"Identifier" and "string constant".
{code}
show table extended like 'mytablename';
tableName:mytablename
owner:null
location:hdfs://xxx:9000/user/yyy/mytablename
inputformat:org.apache.hadoop.mapred.SequenceFileInputFormat
outputformat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
columns:struct columns { list<string> col}
partitioned:false
partitionColumns:
totalNumberFiles:unknown
totalFileSize:unknown
maxFileSize:unknown
minFileSize:unknown
lastAccessTime:unknown
lastUpdateTime:unknown
{code}
Why are the sizes all "unknown"? I am using hadoop 0.17.
> Provide hive ql to check table/partition status, including size, creation and
> access timestamp
> ----------------------------------------------------------------------------------------------
>
> Key: HIVE-667
> URL: https://issues.apache.org/jira/browse/HIVE-667
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Hao Liu
> Assignee: He Yongqiang
> Attachments: hive-667-2009-07-24.patch, hive-667-2009-07-25-3.patch,
> hive-667-2009-07-25.patch, hive-667-2009-07-27.patch,
> hive-667-2009-07-28-2.patch, hive-667-2009-07-28.patch,
> hive-667-2009-08-25.patch, indented.txt, localtest-2009-07-24.txt
>
>
> Those information will be helpful both for data management tasks, and users
> who send adhoc queries against big data set in the cluster. .
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
