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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.3.0
• Component/s: Query Processor
• Hadoop Flags: Reviewed
• Assignee: Namit Jain
• Reporter: Namit Jain
• Created: 13/Mar/09 22:38
• Updated: 17/Dec/11 00:08
• Resolved: 19/Mar/09 21:48

Description

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