hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ning Zhang (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-1072) "show table extended like table partition(xxx) " will show the result of the whole table if the partition does not exist
Date Tue, 26 Jan 2010 07:28:34 GMT

    [ https://issues.apache.org/jira/browse/HIVE-1072?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12804925#action_12804925
] 

Ning Zhang commented on HIVE-1072:
----------------------------------

Zheng and Yongqiang, one test result file was missing for the committed version to branch
0.5.0: ql/src/test/results/clientnegative/invalide_t_alter1.q.out. Can you double check and
commit it?

> "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
>             Fix For: 0.6.0
>
>         Attachments: hive-1072.2.patch, hive-1072.patch
>
>
> 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