impala-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Internal Jenkins (Code Review)" <ger...@cloudera.org>
Subject [Impala-CR](cdh5-trunk) Improve the SQL for nested TPCH-Q18.
Date Fri, 04 Mar 2016 04:35:56 GMT
Internal Jenkins has submitted this change and it was merged.

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
Reviewed-on: http://gerrit.cloudera.org:8080/2418
Reviewed-by: Alex Behm <alex.behm@cloudera.com>
Tested-by: Internal Jenkins
---
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(-)

Approvals:
  Internal Jenkins: Verified
  Alex Behm: Looks good to me, approved



-- 
To view, visit http://gerrit.cloudera.org:8080/2418
To unsubscribe, visit http://gerrit.cloudera.org:8080/settings

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

Mime
View raw message