You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Namit Jain (JIRA)" <ji...@apache.org> on 2010/06/16 00:11:25 UTC
[jira] Updated: (HIVE-1266) partitioning pruing should be more
intelligent
[ https://issues.apache.org/jira/browse/HIVE-1266?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-1266:
-----------------------------
Status: Open (was: Patch Available)
> partitioning pruing should be more intelligent
> ----------------------------------------------
>
> Key: HIVE-1266
> URL: https://issues.apache.org/jira/browse/HIVE-1266
> Project: Hadoop Hive
> Issue Type: Bug
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: He Yongqiang
> Attachments: hive-1266.1.patch
>
>
> Copying the mail from Adam:
> A badly written query:
> select .. from T where partitioning_colmn = 'p1' AND c1 = 100 or c2 = 200
> ...is a command I just foolishly ran: I should have put the disjunction in parentheses.
> But the command actually touched every partition of T without a warning. Is that a bug? When we force people to state a partition predicate, it seems we are just looking for it to be referenced in the WHERE or ON clause, when maybe we should be looking at conjuncts?
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.