[
https://issues.apache.org/jira/browse/HIVE-2870?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13229976#comment-13229976
]
Phabricator commented on HIVE-2870:
-----------------------------------
lucian has commented on the revision "HIVE-2870 [jira] Throw an error when a
nonexistent partition is accessed in strict mode".
> ...is the clarification that this is a "strict mode" restriction
automatically included in the error message?
No, but neither is it if for other strict-only errors:
hive> select * from tmp_table_with_partitions;
FAILED: Error in semantic analysis: No partition predicate found for Alias
"tmp_table_with_partitions" Table "tmp_table_with_partitions"
hive> select count(*) from tmp_table_with_partitions where ds="asdf";
FAILED: Error in semantic analysis: No valid partition left after pruning for
Alias "tmp_table_with_partitions" Table "tmp_table_with_partitions"
I can change it, but I wanted to be consistent with that other one I tested.
REVISION DETAIL
https://reviews.facebook.net/D2319
> Throw an error when a nonexistent partition is accessed in strict mode
> ----------------------------------------------------------------------
>
> Key: HIVE-2870
> URL: https://issues.apache.org/jira/browse/HIVE-2870
> Project: Hive
> Issue Type: Improvement
> Components: Query Processor
> Reporter: Lucian Adrian Grijincu
> Priority: Minor
> Attachments: HIVE-2870.D2319.1.patch
>
> Original Estimate: 24h
> Remaining Estimate: 24h
>
> When a table does not exist and someone tries to read from it in a query,
> Hive throws an error.
> But if a partition is directly accessed that does not exist, an error is not
> thrown. This is inconsistent and also leads to a lot of confused users who
> get no output.
> This task is to cause Hive to throw an error when the partition pruner for a
> query eliminates ALL existing partitions for some table when running in
> strict mode.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
