Tim Armstrong has posted comments on this change. Change subject: IMPALA-5452: Rewrite test case to avoid 'pos'. ......................................................................
Patch Set 1: (1 comment) http://gerrit.cloudera.org:8080/#/c/7708/1/testdata/workloads/functional-query/queries/QueryTest/nested-types-subplan.test File testdata/workloads/functional-query/queries/QueryTest/nested-types-subplan.test: Line 666: (select lead(l.l_linenumber) over (order by l.l_shipdate) I'm not sure that l_shipdate gives a total order. I think the below query gives back a list of the lineitems belonging to orders where there were duplicate l_shipdates select o_custkey, l_orderkey, l_shipdate from tpch_parquet.lineitem join tpch_parquet.orders on o_orderkey = l_orderkey where o_custkey < 10 and l_orderkey in ( select l_orderkey from tpch_parquet.lineitem join tpch_parquet.orders on o_orderkey = l_orderkey where o_custkey < 10 group by 1 having count(l_shipdate) != count(distinct l_shipdate)) order by 1, 2, 3; -- To view, visit http://gerrit.cloudera.org:8080/7708 To unsubscribe, visit http://gerrit.cloudera.org:8080/settings Gerrit-MessageType: comment Gerrit-Change-Id: I32e47f0845da8b27652faaceae834e025ecff42a Gerrit-PatchSet: 1 Gerrit-Project: Impala-ASF Gerrit-Branch: master Gerrit-Owner: Alex Behm <[email protected]> Gerrit-Reviewer: Tim Armstrong <[email protected]> Gerrit-HasComments: Yes
