[HIVE-9255] Fastpath for limited fetches from unpartitioned tables

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 0.14.0, 0.15.0
• Fix Version/s: 1.1.0
• Component/s: Physical Optimizer
• Release Note: SimpleFetchOptimizer for limited fetches without filters
• Assignee: Gopal Vijayaraghavan
• Reporter: Gopal Vijayaraghavan
• Created: 05/Jan/15 16:59
• Updated: 12/Feb/15 23:40
• Resolved: 16/Jan/15 23:21

Description

Currently, for flat tables, the threshold check is applicable for a query like select * from lineitem limit 1;.

This is not necessary as without a filter clause, this can be executed entirely via FetchTask. Running a cluster task is redundant for this case.

This fastpath is applicable for partitioned tables already.

Issue Links

• is cloned by: HIVE-9401 Backport: Fastpath for limited fetches from unpartitioned tables