You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Zheng Shao (JIRA)" <ji...@apache.org> on 2010/01/20 23:19:54 UTC
[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
"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.
[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
Posted by "Ning Zhang (JIRA)" <ji...@apache.org>.
[ 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.
[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
Posted by "Zheng Shao (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1072?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12804927#action_12804927 ]
Zheng Shao commented on HIVE-1072:
----------------------------------
Ning, sorry about that. I just committed it to branch-0.5 under HIVE-1059.
> "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.
[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
Posted by "Zheng Shao (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1072?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12803064#action_12803064 ]
Zheng Shao commented on HIVE-1072:
----------------------------------
+1. Will commit after test.
> "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
> 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.
[jira] Updated: (HIVE-1072) "show table extended like table
partition(xxx) " will show the result of the whole table if the partition
does not exist
Posted by "He Yongqiang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1072?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
He Yongqiang updated HIVE-1072:
-------------------------------
Status: Patch Available (was: Open)
> "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
> Attachments: 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.
[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
Posted by "Zheng Shao (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1072?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12803047#action_12803047 ]
Zheng Shao commented on HIVE-1072:
----------------------------------
If the partition does not exist, we should fail the query.
Can you add a negative test instead?
> "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
> Attachments: 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.
[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
Posted by "He Yongqiang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1072?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12803052#action_12803052 ]
He Yongqiang commented on HIVE-1072:
------------------------------------
np. i can add that. But it seems many other commands just output error msg and succeed, like 'describe'.
> "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
> Attachments: 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.
[jira] Updated: (HIVE-1072) "show table extended like table
partition(xxx) " will show the result of the whole table if the partition
does not exist
Posted by "He Yongqiang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1072?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
He Yongqiang updated HIVE-1072:
-------------------------------
Attachment: hive-1072.patch
> "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
> Attachments: 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.
[jira] Updated: (HIVE-1072) "show table extended like table
partition(xxx) " will show the result of the whole table if the partition
does not exist
Posted by "He Yongqiang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1072?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
He Yongqiang updated HIVE-1072:
-------------------------------
Attachment: hive-1072.2.patch
hive-1072.2.patch fails query when the given partition does not exist.
> "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
> 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.
[jira] Updated: (HIVE-1072) "show table extended like table
partition(xxx) " will show the result of the whole table if the partition
does not exist
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1072?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach updated HIVE-1072:
---------------------------------
Fix Version/s: 0.5.0
(was: 0.6.0)
Affects Version/s: 0.4.1
Component/s: Query Processor
> "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
> Components: Query Processor
> Affects Versions: 0.4.1
> Reporter: Zheng Shao
> Assignee: He Yongqiang
> Fix For: 0.5.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.
[jira] Updated: (HIVE-1072) "show table extended like table
partition(xxx) " will show the result of the whole table if the partition
does not exist
Posted by "Zheng Shao (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1072?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Zheng Shao updated HIVE-1072:
-----------------------------
Resolution: Fixed
Fix Version/s: 0.6.0
Release Note: HIVE-1072. Show table extended to error out when the partition does not exist. (Yongqiang He via zshao)
Hadoop Flags: [Reviewed]
Status: Resolved (was: Patch Available)
Committed. Thanks Yongqiang.
> "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.