[DRILL-2800] Performance regression introduced with commit: a6df26a (Patch for DRILL-2512)

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.9.0
• Fix Version/s: 1.2.0

Environment

RHEL 6.4
TPCH Data Set: SF100 (Uncompressed Parquet)

• Assignee: Sudheesh Katkam
• Reporter: Kunal Khatua
• Created: 15/Apr/15 18:49
• Updated: 07/Jul/15 00:12
• Resolved: 07/Jul/15 00:12

Description

TPCH 06 (Cached Run) was used as a reference to identify the regressive commit.

DRILL-2613: 2-Core: Impl. ResultSet.getXxx(...) number-to-number data [fe11e86]
3,902 msec

DRILL-2668: Fix: CAST(1.1 AS FLOAT) was yielding DOUBLE. [49042bc]
5,606 msec

DRILL-2512: Shuffle the list of Drill endpoints before connecting [a6df26a]
10,506 msec
(Rerun 9,678 msec)

Here are comparisons from the last complete run (Cached runs):
Commit d7e37f4 a6df26a
tpch 01 12,232 16,693
tpch 03 23,374 30,062
tpch 04 42,144 23,749
tpch 05 32,247 41,648
tpch 06 4,665 10,506
tpch 07 29,322 34,315
tpch 08 35,478 42,120
tpch 09 43,959 49,262
tpch 10 24,439 26,136
tpch 12 Timeout 18,866
tpch 13 18,226 20,863
tpch 14 11,760 11,884
tpch 16 10,676 15,032
tpch 18 34,153 39,058
tpch 19 Timeout 32,909
tpch 20 99,788 22,890