[Impala-CR](cdh5-trunk) Improve the SQL for nested TPCH-Q18.

["Alex Behm (Code Review)" <ge...@cloudera.org>]

Alex Behm has uploaded a new change for review.

  http://gerrit.cloudera.org:8080/2418

Change subject: Improve the SQL for nested TPCH-Q18.
......................................................................

Improve the SQL for nested TPCH-Q18.

Marcel spotted that nested TPCH-Q18 can be expressed with
more efficient SQL.

Results on nested TPCH-300:
Before   160s
After    100s

Change-Id: I8b351b7f467e8bef0c256dc43cea325d7f177edf
---
M testdata/workloads/functional-planner/queries/PlannerTest/tpch-nested.test
M testdata/workloads/tpch_nested/queries/tpch-q18.test
2 files changed, 25 insertions(+), 61 deletions(-)


  git pull ssh://gerrit.cloudera.org:29418/Impala refs/changes/18/2418/1
-- 
To view, visit http://gerrit.cloudera.org:8080/2418
To unsubscribe, visit http://gerrit.cloudera.org:8080/settings

Gerrit-MessageType: newchange
Gerrit-Change-Id: I8b351b7f467e8bef0c256dc43cea325d7f177edf
Gerrit-PatchSet: 1
Gerrit-Project: Impala
Gerrit-Branch: cdh5-trunk
Gerrit-Owner: Alex Behm <al...@cloudera.com>