[HIVE-2451] TABLESAMBLE(BUCKET xxx) sometimes doesn't trigger input pruning as regression of HIVE-1538

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.8.0
• Assignee: Siying Dong
• Reporter: Siying Dong
• Created: 15/Sep/11 23:49
• Updated: 16/Dec/11 23:56
• Resolved: 19/Sep/11 23:16

Description

Example:

select count(1) from <bucket_table> TABLESAMPLE(BUCKET xxx out of yyy) where <partition_column> = 'xxx'

will not trigger input pruning.

The reason is that we assume sample filtering operator only happens as the second filter after table scan, which is broken by HIVE-1538, even if the feature doesn't turn on.