hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John Sichi (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-1318) External Tables: Selecting a partition that does not exist produces errors
Date Fri, 30 Apr 2010 01:26:54 GMT

    [ 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.


Mime
View raw message