hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zheng Shao (JIRA)" <j...@apache.org>
Subject [jira] Created: (HIVE-1072) "show table extended like table partition(xxx) " will show the result of the whole table if the partition does not exist
Date Wed, 20 Jan 2010 22:19:54 GMT
"show table extended like table partition(xxx) " will show the result of the whole table if
the partition does not exist
------------------------------------------------------------------------------------------------------------------------

                 Key: HIVE-1072
                 URL: https://issues.apache.org/jira/browse/HIVE-1072
             Project: Hadoop Hive
          Issue Type: Bug
            Reporter: Zheng Shao
            Assignee: He Yongqiang


See the following example, we should output an error for the second command.

{code}
hive> show table extended like member_count;
OK
tableName:member_count
owner:null
location:/user/hive/member_count
inputformat:org.apache.hadoop.mapred.SequenceFileInputFormat
outputformat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
columns:struct columns { string count}
partitioned:true
partitionColumns:struct partition_columns { string ds}
totalNumberFiles:233933
totalFileSize:32802665
maxFileSize:257
minFileSize:140
lastAccessTime:1264017438860
lastUpdateTime:1263949909703

Time taken: 125.104 seconds

hive> show table extended like member_count partition(ds = '2009-10-11');
OK
tableName:member_count
owner:null
location:/user/hive/member_count
inputformat:org.apache.hadoop.mapred.SequenceFileInputFormat
outputformat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
columns:struct columns { string count}
partitioned:true
partitionColumns:struct partition_columns { string ds}
totalNumberFiles:233933
totalFileSize:32802665
maxFileSize:257
minFileSize:140
lastAccessTime:1264017438860
lastUpdateTime:1263949909703

Time taken: 24.618 seconds

hive> show table extended like member_count partition(ds = '2009-12-11');
OK
tableName:member_count
owner:null
location:/user/hive/member_count
inputformat:org.apache.hadoop.mapred.SequenceFileInputFormat
outputformat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
columns:struct columns { string count}
partitioned:true
partitionColumns:struct partition_columns { string ds}
totalNumberFiles:3495
totalFileSize:489417
maxFileSize:257
minFileSize:140
lastAccessTime:1262676533852
lastUpdateTime:1263949909703

Time taken: 0.549 seconds
{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