[hive] lot of mappers due to a user error while specifying the partitioning 
column
----------------------------------------------------------------------------------

                 Key: HIVE-347
                 URL: https://issues.apache.org/jira/browse/HIVE-347
             Project: Hadoop Hive
          Issue Type: Bug
          Components: Query Processor
            Reporter: Namit Jain
            Assignee: Namit Jain


A common scenario when the table is partitioned on 'ds' column which is of type 
'string' of a certain format 'yyyy-mm-dd'

However, if the user forgets to add quotes while specifying the query:

select ... from T where ds = 2009-02-02


2009-02-02 is a valid integer expression. So, partition pruning makes all 
partitions unknown, since 2009-02-02 to double conversion is null.

If all partitions are unknown, in strict mode, we should thrown an error




-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to