You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Edward Capriolo (JIRA)" <ji...@apache.org> on 2010/04/22 20:59:49 UTC
[jira] Created: (HIVE-1318) External Tables: Selecting a partition
that does not exist produces errors
External Tables: Selecting a partition that does not exist produces errors
--------------------------------------------------------------------------
Key: HIVE-1318
URL: https://issues.apache.org/jira/browse/HIVE-1318
Project: Hadoop Hive
Issue Type: Bug
Affects Versions: 0.5.0
Reporter: Edward Capriolo
Attachments: partdoom.q
{noformat}
dfs -mkdir /tmp/a;
dfs -mkdir /tmp/a/b;
dfs -mkdir /tmp/a/c;
create external table abc( key string, val string )
partitioned by (part int)
location '/tmp/a/';
alter table abc ADD PARTITION (part=1) LOCATION 'b';
alter table abc ADD PARTITION (part=2) LOCATION 'c';
select key from abc where part=1;
select key from abct where part=70;
{noformat}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-1318) External Tables: Selecting a partition
that does not exist produces errors
Posted by "Edward Capriolo (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1318?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Capriolo updated HIVE-1318:
----------------------------------
Attachment: partdoom.q
> External Tables: Selecting a partition that does not exist produces errors
> --------------------------------------------------------------------------
>
> Key: HIVE-1318
> URL: https://issues.apache.org/jira/browse/HIVE-1318
> Project: Hadoop Hive
> Issue Type: Bug
> Affects Versions: 0.5.0
> Reporter: Edward Capriolo
> Attachments: partdoom.q
>
>
> {noformat}
> dfs -mkdir /tmp/a;
> dfs -mkdir /tmp/a/b;
> dfs -mkdir /tmp/a/c;
> create external table abc( key string, val string )
> partitioned by (part int)
> location '/tmp/a/';
> alter table abc ADD PARTITION (part=1) LOCATION 'b';
> alter table abc ADD PARTITION (part=2) LOCATION 'c';
> select key from abc where part=1;
> select key from abct where part=70;
> {noformat}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-1318) External Tables: Selecting a
partition that does not exist produces errors
Posted by "John Sichi (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1318?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12862506#action_12862506 ]
John Sichi commented on HIVE-1318:
----------------------------------
What error did you get (other than abct not existing due to the typo)?
It works for me on trunk (returns no rows), but maybe 0.5 didn't get some patch.
> External Tables: Selecting a partition that does not exist produces errors
> --------------------------------------------------------------------------
>
> Key: HIVE-1318
> URL: https://issues.apache.org/jira/browse/HIVE-1318
> Project: Hadoop Hive
> Issue Type: Bug
> Affects Versions: 0.5.0
> Reporter: Edward Capriolo
> Attachments: partdoom.q
>
>
> {noformat}
> dfs -mkdir /tmp/a;
> dfs -mkdir /tmp/a/b;
> dfs -mkdir /tmp/a/c;
> create external table abc( key string, val string )
> partitioned by (part int)
> location '/tmp/a/';
> alter table abc ADD PARTITION (part=1) LOCATION 'b';
> alter table abc ADD PARTITION (part=2) LOCATION 'c';
> select key from abc where part=1;
> select key from abct where part=70;
> {noformat}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.