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