impala-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alex Behm (Code Review)" <ger...@cloudera.org>
Subject [Impala-CR](cdh5-trunk) Improve the SQL for nested TPCH-Q18.
Date Fri, 04 Mar 2016 00:59:49 GMT
Hello Marcel Kornacker,

I'd like you to reexamine a change.  Please visit

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

to look at the new patch set (#2).

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, 23 insertions(+), 59 deletions(-)


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

Gerrit-MessageType: newpatchset
Gerrit-Change-Id: I8b351b7f467e8bef0c256dc43cea325d7f177edf
Gerrit-PatchSet: 2
Gerrit-Project: Impala
Gerrit-Branch: cdh5-trunk
Gerrit-Owner: Alex Behm <alex.behm@cloudera.com>
Gerrit-Reviewer: Marcel Kornacker <marcel@cloudera.com>

Mime
View raw message