[DRILL-2871] Plan for TPC-H 20 changed with DRILL-1384 (or DRILL-2761) causing performance degradation

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: 0.9.0
• Fix Version/s: 1.0.0
• Labels: performance

Environment

RHEL 6.4

• Assignee: Unassigned
• Reporter: Kunal Khatua
• Created: 24/Apr/15 18:49
• Updated: 24/Apr/15 20:39
• Resolved: 24/Apr/15 20:39

Description

TPCH 20 on SF100 (parquet) regressed from 25sec to 110sec.

There is a change in the query plans for the query when running on the master with commitId=e99f270 (DRILL-1384); when compared with the plan generated for the preceding commitId=2a48425 (DRILL-2514).