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 <[email protected]> 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 <[email protected]> Gerrit-Reviewer: Alex Behm <[email protected]> Gerrit-Reviewer: Internal Jenkins Gerrit-Reviewer: Marcel Kornacker <[email protected]>
