http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Hash.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Hash.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Hash.plan index b3f04c8..5b37e92 100644 --- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Hash.plan +++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Hash.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(5) - => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc),default.supplier.s_name (TEXT) (asc),default.part.p_partkey (INT4) (asc),default.nation.n_name (TEXT) (asc) + => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc, nulls last),default.supplier.s_name (TEXT) (asc, nulls last),default.part.p_partkey (INT4) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last) JOIN(13)(INNER) => Join Cond: default.supplier.s_nationkey (INT4) = default.nation.n_nationkey (INT4) => target list: default.nation.n_name (TEXT), default.part.p_partkey (INT4), default.supplier.s_acctbal (FLOAT8), default.supplier.s_name (TEXT) @@ -62,7 +62,7 @@ Block Id: eb_0000000000000_0000_000007 [LEAF] 2: type=Broadcast, tables=default.supplier SORT(21) - => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc),default.supplier.s_name (TEXT) (asc),default.part.p_partkey (INT4) (asc),default.nation.n_name (TEXT) (asc) + => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc, nulls last),default.supplier.s_name (TEXT) (asc, nulls last),default.part.p_partkey (INT4) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last) JOIN(13)(INNER) => Join Cond: default.supplier.s_nationkey (INT4) = default.nation.n_nationkey (INT4) => target list: default.nation.n_name (TEXT), default.part.p_partkey (INT4), default.supplier.s_acctbal (FLOAT8), default.supplier.s_name (TEXT) @@ -106,7 +106,7 @@ Block Id: eb_0000000000000_0000_000008 [ROOT] 0: sorted input=eb_0000000000000_0000_000007 SORT(5) - => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc),default.supplier.s_name (TEXT) (asc),default.part.p_partkey (INT4) (asc),default.nation.n_name (TEXT) (asc) + => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc, nulls last),default.supplier.s_name (TEXT) (asc, nulls last),default.part.p_partkey (INT4) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last) SCAN(22) on eb_0000000000000_0000_000007 => out schema: {(4) default.nation.n_name (TEXT), default.part.p_partkey (INT4), default.supplier.s_acctbal (FLOAT8), default.supplier.s_name (TEXT)} => in schema: {(4) default.nation.n_name (TEXT), default.part.p_partkey (INT4), default.supplier.s_acctbal (FLOAT8), default.supplier.s_name (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Hash_NoBroadcast.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Hash_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Hash_NoBroadcast.plan index b195e34..ba3164b 100644 --- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Hash_NoBroadcast.plan +++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Hash_NoBroadcast.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(5) - => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc),default.supplier.s_name (TEXT) (asc),default.part.p_partkey (INT4) (asc),default.nation.n_name (TEXT) (asc) + => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc, nulls last),default.supplier.s_name (TEXT) (asc, nulls last),default.part.p_partkey (INT4) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last) JOIN(13)(INNER) => Join Cond: default.supplier.s_nationkey (INT4) = default.nation.n_nationkey (INT4) => target list: default.nation.n_name (TEXT), default.part.p_partkey (INT4), default.supplier.s_acctbal (FLOAT8), default.supplier.s_name (TEXT) @@ -167,7 +167,7 @@ Block Id: eb_0000000000000_0000_000007 [INTERMEDIATE] [q_0000000000000_0000] 7 => 8 (type=RANGE_SHUFFLE, key=default.nation.n_name (TEXT), default.part.p_partkey (INT4), default.supplier.s_acctbal (FLOAT8), default.supplier.s_name (TEXT), num=32) SORT(21) - => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc),default.supplier.s_name (TEXT) (asc),default.part.p_partkey (INT4) (asc),default.nation.n_name (TEXT) (asc) + => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc, nulls last),default.supplier.s_name (TEXT) (asc, nulls last),default.part.p_partkey (INT4) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last) JOIN(13)(INNER) => Join Cond: default.supplier.s_nationkey (INT4) = default.nation.n_nationkey (INT4) => target list: default.nation.n_name (TEXT), default.part.p_partkey (INT4), default.supplier.s_acctbal (FLOAT8), default.supplier.s_name (TEXT) @@ -191,7 +191,7 @@ Block Id: eb_0000000000000_0000_000008 [ROOT] 0: sorted input=eb_0000000000000_0000_000007 SORT(5) - => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc),default.supplier.s_name (TEXT) (asc),default.part.p_partkey (INT4) (asc),default.nation.n_name (TEXT) (asc) + => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc, nulls last),default.supplier.s_name (TEXT) (asc, nulls last),default.part.p_partkey (INT4) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last) SCAN(22) on eb_0000000000000_0000_000007 => out schema: {(4) default.nation.n_name (TEXT), default.part.p_partkey (INT4), default.supplier.s_acctbal (FLOAT8), default.supplier.s_name (TEXT)} => in schema: {(4) default.nation.n_name (TEXT), default.part.p_partkey (INT4), default.supplier.s_acctbal (FLOAT8), default.supplier.s_name (TEXT)} http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Sort.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Sort.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Sort.plan index b3f04c8..5b37e92 100644 --- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Sort.plan +++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Sort.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(5) - => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc),default.supplier.s_name (TEXT) (asc),default.part.p_partkey (INT4) (asc),default.nation.n_name (TEXT) (asc) + => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc, nulls last),default.supplier.s_name (TEXT) (asc, nulls last),default.part.p_partkey (INT4) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last) JOIN(13)(INNER) => Join Cond: default.supplier.s_nationkey (INT4) = default.nation.n_nationkey (INT4) => target list: default.nation.n_name (TEXT), default.part.p_partkey (INT4), default.supplier.s_acctbal (FLOAT8), default.supplier.s_name (TEXT) @@ -62,7 +62,7 @@ Block Id: eb_0000000000000_0000_000007 [LEAF] 2: type=Broadcast, tables=default.supplier SORT(21) - => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc),default.supplier.s_name (TEXT) (asc),default.part.p_partkey (INT4) (asc),default.nation.n_name (TEXT) (asc) + => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc, nulls last),default.supplier.s_name (TEXT) (asc, nulls last),default.part.p_partkey (INT4) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last) JOIN(13)(INNER) => Join Cond: default.supplier.s_nationkey (INT4) = default.nation.n_nationkey (INT4) => target list: default.nation.n_name (TEXT), default.part.p_partkey (INT4), default.supplier.s_acctbal (FLOAT8), default.supplier.s_name (TEXT) @@ -106,7 +106,7 @@ Block Id: eb_0000000000000_0000_000008 [ROOT] 0: sorted input=eb_0000000000000_0000_000007 SORT(5) - => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc),default.supplier.s_name (TEXT) (asc),default.part.p_partkey (INT4) (asc),default.nation.n_name (TEXT) (asc) + => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc, nulls last),default.supplier.s_name (TEXT) (asc, nulls last),default.part.p_partkey (INT4) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last) SCAN(22) on eb_0000000000000_0000_000007 => out schema: {(4) default.nation.n_name (TEXT), default.part.p_partkey (INT4), default.supplier.s_acctbal (FLOAT8), default.supplier.s_name (TEXT)} => in schema: {(4) default.nation.n_name (TEXT), default.part.p_partkey (INT4), default.supplier.s_acctbal (FLOAT8), default.supplier.s_name (TEXT)} http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Sort_NoBroadcast.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Sort_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Sort_NoBroadcast.plan index b195e34..ba3164b 100644 --- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Sort_NoBroadcast.plan +++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Sort_NoBroadcast.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(5) - => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc),default.supplier.s_name (TEXT) (asc),default.part.p_partkey (INT4) (asc),default.nation.n_name (TEXT) (asc) + => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc, nulls last),default.supplier.s_name (TEXT) (asc, nulls last),default.part.p_partkey (INT4) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last) JOIN(13)(INNER) => Join Cond: default.supplier.s_nationkey (INT4) = default.nation.n_nationkey (INT4) => target list: default.nation.n_name (TEXT), default.part.p_partkey (INT4), default.supplier.s_acctbal (FLOAT8), default.supplier.s_name (TEXT) @@ -167,7 +167,7 @@ Block Id: eb_0000000000000_0000_000007 [INTERMEDIATE] [q_0000000000000_0000] 7 => 8 (type=RANGE_SHUFFLE, key=default.nation.n_name (TEXT), default.part.p_partkey (INT4), default.supplier.s_acctbal (FLOAT8), default.supplier.s_name (TEXT), num=32) SORT(21) - => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc),default.supplier.s_name (TEXT) (asc),default.part.p_partkey (INT4) (asc),default.nation.n_name (TEXT) (asc) + => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc, nulls last),default.supplier.s_name (TEXT) (asc, nulls last),default.part.p_partkey (INT4) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last) JOIN(13)(INNER) => Join Cond: default.supplier.s_nationkey (INT4) = default.nation.n_nationkey (INT4) => target list: default.nation.n_name (TEXT), default.part.p_partkey (INT4), default.supplier.s_acctbal (FLOAT8), default.supplier.s_name (TEXT) @@ -191,7 +191,7 @@ Block Id: eb_0000000000000_0000_000008 [ROOT] 0: sorted input=eb_0000000000000_0000_000007 SORT(5) - => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc),default.supplier.s_name (TEXT) (asc),default.part.p_partkey (INT4) (asc),default.nation.n_name (TEXT) (asc) + => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc, nulls last),default.supplier.s_name (TEXT) (asc, nulls last),default.part.p_partkey (INT4) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last) SCAN(22) on eb_0000000000000_0000_000007 => out schema: {(4) default.nation.n_name (TEXT), default.part.p_partkey (INT4), default.supplier.s_acctbal (FLOAT8), default.supplier.s_name (TEXT)} => in schema: {(4) default.nation.n_name (TEXT), default.part.p_partkey (INT4), default.supplier.s_acctbal (FLOAT8), default.supplier.s_name (TEXT)} http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Hash.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Hash.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Hash.plan index 714ab21..7935c18 100644 --- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Hash.plan +++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Hash.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(6) - => Sort Keys: default.lineitem.l_orderkey (INT4) (asc),default.a.o_custkey (INT4) (asc),default.part.p_name (TEXT) (asc) + => Sort Keys: default.lineitem.l_orderkey (INT4) (asc, nulls last),default.a.o_custkey (INT4) (asc, nulls last),default.part.p_name (TEXT) (asc, nulls last) JOIN(12)(INNER) => Join Cond: default.lineitem.l_orderkey (INT4) = default.a.o_orderkey (INT4) => target list: default.a.o_custkey (INT4), default.lineitem.l_orderkey (INT4), default.part.p_name (TEXT) @@ -56,7 +56,7 @@ Block Id: eb_0000000000000_0000_000005 [LEAF] 1: type=Broadcast, tables=default.part SORT(18) - => Sort Keys: default.lineitem.l_orderkey (INT4) (asc),default.a.o_custkey (INT4) (asc),default.part.p_name (TEXT) (asc) + => Sort Keys: default.lineitem.l_orderkey (INT4) (asc, nulls last),default.a.o_custkey (INT4) (asc, nulls last),default.part.p_name (TEXT) (asc, nulls last) JOIN(12)(INNER) => Join Cond: default.lineitem.l_orderkey (INT4) = default.a.o_orderkey (INT4) => target list: default.a.o_custkey (INT4), default.lineitem.l_orderkey (INT4), default.part.p_name (TEXT) @@ -99,7 +99,7 @@ Block Id: eb_0000000000000_0000_000006 [ROOT] 0: sorted input=eb_0000000000000_0000_000005 SORT(6) - => Sort Keys: default.lineitem.l_orderkey (INT4) (asc),default.a.o_custkey (INT4) (asc),default.part.p_name (TEXT) (asc) + => Sort Keys: default.lineitem.l_orderkey (INT4) (asc, nulls last),default.a.o_custkey (INT4) (asc, nulls last),default.part.p_name (TEXT) (asc, nulls last) SCAN(19) on eb_0000000000000_0000_000005 => out schema: {(3) default.a.o_custkey (INT4), default.lineitem.l_orderkey (INT4), default.part.p_name (TEXT)} => in schema: {(3) default.a.o_custkey (INT4), default.lineitem.l_orderkey (INT4), default.part.p_name (TEXT)} http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Hash_NoBroadcast.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Hash_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Hash_NoBroadcast.plan index 7ab1815..e7a3684 100644 --- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Hash_NoBroadcast.plan +++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Hash_NoBroadcast.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(6) - => Sort Keys: default.lineitem.l_orderkey (INT4) (asc),default.a.o_custkey (INT4) (asc),default.part.p_name (TEXT) (asc) + => Sort Keys: default.lineitem.l_orderkey (INT4) (asc, nulls last),default.a.o_custkey (INT4) (asc, nulls last),default.part.p_name (TEXT) (asc, nulls last) JOIN(12)(INNER) => Join Cond: default.lineitem.l_orderkey (INT4) = default.a.o_orderkey (INT4) => target list: default.a.o_custkey (INT4), default.lineitem.l_orderkey (INT4), default.part.p_name (TEXT) @@ -131,7 +131,7 @@ Block Id: eb_0000000000000_0000_000005 [INTERMEDIATE] [q_0000000000000_0000] 5 => 6 (type=RANGE_SHUFFLE, key=default.a.o_custkey (INT4), default.lineitem.l_orderkey (INT4), default.part.p_name (TEXT), num=32) SORT(18) - => Sort Keys: default.lineitem.l_orderkey (INT4) (asc),default.a.o_custkey (INT4) (asc),default.part.p_name (TEXT) (asc) + => Sort Keys: default.lineitem.l_orderkey (INT4) (asc, nulls last),default.a.o_custkey (INT4) (asc, nulls last),default.part.p_name (TEXT) (asc, nulls last) JOIN(12)(INNER) => Join Cond: default.lineitem.l_orderkey (INT4) = default.a.o_orderkey (INT4) => target list: default.a.o_custkey (INT4), default.lineitem.l_orderkey (INT4), default.part.p_name (TEXT) @@ -155,7 +155,7 @@ Block Id: eb_0000000000000_0000_000006 [ROOT] 0: sorted input=eb_0000000000000_0000_000005 SORT(6) - => Sort Keys: default.lineitem.l_orderkey (INT4) (asc),default.a.o_custkey (INT4) (asc),default.part.p_name (TEXT) (asc) + => Sort Keys: default.lineitem.l_orderkey (INT4) (asc, nulls last),default.a.o_custkey (INT4) (asc, nulls last),default.part.p_name (TEXT) (asc, nulls last) SCAN(19) on eb_0000000000000_0000_000005 => out schema: {(3) default.a.o_custkey (INT4), default.lineitem.l_orderkey (INT4), default.part.p_name (TEXT)} => in schema: {(3) default.a.o_custkey (INT4), default.lineitem.l_orderkey (INT4), default.part.p_name (TEXT)} http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Sort.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Sort.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Sort.plan index 714ab21..7935c18 100644 --- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Sort.plan +++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Sort.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(6) - => Sort Keys: default.lineitem.l_orderkey (INT4) (asc),default.a.o_custkey (INT4) (asc),default.part.p_name (TEXT) (asc) + => Sort Keys: default.lineitem.l_orderkey (INT4) (asc, nulls last),default.a.o_custkey (INT4) (asc, nulls last),default.part.p_name (TEXT) (asc, nulls last) JOIN(12)(INNER) => Join Cond: default.lineitem.l_orderkey (INT4) = default.a.o_orderkey (INT4) => target list: default.a.o_custkey (INT4), default.lineitem.l_orderkey (INT4), default.part.p_name (TEXT) @@ -56,7 +56,7 @@ Block Id: eb_0000000000000_0000_000005 [LEAF] 1: type=Broadcast, tables=default.part SORT(18) - => Sort Keys: default.lineitem.l_orderkey (INT4) (asc),default.a.o_custkey (INT4) (asc),default.part.p_name (TEXT) (asc) + => Sort Keys: default.lineitem.l_orderkey (INT4) (asc, nulls last),default.a.o_custkey (INT4) (asc, nulls last),default.part.p_name (TEXT) (asc, nulls last) JOIN(12)(INNER) => Join Cond: default.lineitem.l_orderkey (INT4) = default.a.o_orderkey (INT4) => target list: default.a.o_custkey (INT4), default.lineitem.l_orderkey (INT4), default.part.p_name (TEXT) @@ -99,7 +99,7 @@ Block Id: eb_0000000000000_0000_000006 [ROOT] 0: sorted input=eb_0000000000000_0000_000005 SORT(6) - => Sort Keys: default.lineitem.l_orderkey (INT4) (asc),default.a.o_custkey (INT4) (asc),default.part.p_name (TEXT) (asc) + => Sort Keys: default.lineitem.l_orderkey (INT4) (asc, nulls last),default.a.o_custkey (INT4) (asc, nulls last),default.part.p_name (TEXT) (asc, nulls last) SCAN(19) on eb_0000000000000_0000_000005 => out schema: {(3) default.a.o_custkey (INT4), default.lineitem.l_orderkey (INT4), default.part.p_name (TEXT)} => in schema: {(3) default.a.o_custkey (INT4), default.lineitem.l_orderkey (INT4), default.part.p_name (TEXT)} http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Sort_NoBroadcast.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Sort_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Sort_NoBroadcast.plan index 7ab1815..e7a3684 100644 --- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Sort_NoBroadcast.plan +++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Sort_NoBroadcast.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(6) - => Sort Keys: default.lineitem.l_orderkey (INT4) (asc),default.a.o_custkey (INT4) (asc),default.part.p_name (TEXT) (asc) + => Sort Keys: default.lineitem.l_orderkey (INT4) (asc, nulls last),default.a.o_custkey (INT4) (asc, nulls last),default.part.p_name (TEXT) (asc, nulls last) JOIN(12)(INNER) => Join Cond: default.lineitem.l_orderkey (INT4) = default.a.o_orderkey (INT4) => target list: default.a.o_custkey (INT4), default.lineitem.l_orderkey (INT4), default.part.p_name (TEXT) @@ -131,7 +131,7 @@ Block Id: eb_0000000000000_0000_000005 [INTERMEDIATE] [q_0000000000000_0000] 5 => 6 (type=RANGE_SHUFFLE, key=default.a.o_custkey (INT4), default.lineitem.l_orderkey (INT4), default.part.p_name (TEXT), num=32) SORT(18) - => Sort Keys: default.lineitem.l_orderkey (INT4) (asc),default.a.o_custkey (INT4) (asc),default.part.p_name (TEXT) (asc) + => Sort Keys: default.lineitem.l_orderkey (INT4) (asc, nulls last),default.a.o_custkey (INT4) (asc, nulls last),default.part.p_name (TEXT) (asc, nulls last) JOIN(12)(INNER) => Join Cond: default.lineitem.l_orderkey (INT4) = default.a.o_orderkey (INT4) => target list: default.a.o_custkey (INT4), default.lineitem.l_orderkey (INT4), default.part.p_name (TEXT) @@ -155,7 +155,7 @@ Block Id: eb_0000000000000_0000_000006 [ROOT] 0: sorted input=eb_0000000000000_0000_000005 SORT(6) - => Sort Keys: default.lineitem.l_orderkey (INT4) (asc),default.a.o_custkey (INT4) (asc),default.part.p_name (TEXT) (asc) + => Sort Keys: default.lineitem.l_orderkey (INT4) (asc, nulls last),default.a.o_custkey (INT4) (asc, nulls last),default.part.p_name (TEXT) (asc, nulls last) SCAN(19) on eb_0000000000000_0000_000005 => out schema: {(3) default.a.o_custkey (INT4), default.lineitem.l_orderkey (INT4), default.part.p_name (TEXT)} => in schema: {(3) default.a.o_custkey (INT4), default.lineitem.l_orderkey (INT4), default.part.p_name (TEXT)} http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Hash.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Hash.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Hash.plan index 7263d03..e2704f9 100644 --- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Hash.plan +++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Hash.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(5) - => Sort Keys: default.n1.n_nationkey (INT4) (asc) + => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last) JOIN(8)(INNER) => Join Cond: name1 (TEXT) = name2 (TEXT) => target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT) @@ -46,7 +46,7 @@ Block Id: eb_0000000000000_0000_000003 [LEAF] 0: type=Broadcast, tables=default.small_nation SORT(12) - => Sort Keys: default.n1.n_nationkey (INT4) (asc) + => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last) JOIN(8)(INNER) => Join Cond: name1 (TEXT) = name2 (TEXT) => target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT) @@ -80,7 +80,7 @@ Block Id: eb_0000000000000_0000_000004 [ROOT] 0: sorted input=eb_0000000000000_0000_000003 SORT(5) - => Sort Keys: default.n1.n_nationkey (INT4) (asc) + => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last) SCAN(13) on eb_0000000000000_0000_000003 => out schema: {(3) default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)} => in schema: {(3) default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)} http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Hash_NoBroadcast.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Hash_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Hash_NoBroadcast.plan index f8ce426..8e9e7f1 100644 --- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Hash_NoBroadcast.plan +++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Hash_NoBroadcast.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(5) - => Sort Keys: default.n1.n_nationkey (INT4) (asc) + => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last) JOIN(8)(INNER) => Join Cond: name1 (TEXT) = name2 (TEXT) => target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT) @@ -83,7 +83,7 @@ Block Id: eb_0000000000000_0000_000003 [INTERMEDIATE] [q_0000000000000_0000] 3 => 4 (type=RANGE_SHUFFLE, key=default.n1.n_nationkey (INT4), num=32) SORT(12) - => Sort Keys: default.n1.n_nationkey (INT4) (asc) + => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last) JOIN(8)(INNER) => Join Cond: name1 (TEXT) = name2 (TEXT) => target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT) @@ -107,7 +107,7 @@ Block Id: eb_0000000000000_0000_000004 [ROOT] 0: sorted input=eb_0000000000000_0000_000003 SORT(5) - => Sort Keys: default.n1.n_nationkey (INT4) (asc) + => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last) SCAN(13) on eb_0000000000000_0000_000003 => out schema: {(3) default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)} => in schema: {(3) default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)} http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Sort.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Sort.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Sort.plan index 7263d03..e2704f9 100644 --- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Sort.plan +++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Sort.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(5) - => Sort Keys: default.n1.n_nationkey (INT4) (asc) + => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last) JOIN(8)(INNER) => Join Cond: name1 (TEXT) = name2 (TEXT) => target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT) @@ -46,7 +46,7 @@ Block Id: eb_0000000000000_0000_000003 [LEAF] 0: type=Broadcast, tables=default.small_nation SORT(12) - => Sort Keys: default.n1.n_nationkey (INT4) (asc) + => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last) JOIN(8)(INNER) => Join Cond: name1 (TEXT) = name2 (TEXT) => target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT) @@ -80,7 +80,7 @@ Block Id: eb_0000000000000_0000_000004 [ROOT] 0: sorted input=eb_0000000000000_0000_000003 SORT(5) - => Sort Keys: default.n1.n_nationkey (INT4) (asc) + => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last) SCAN(13) on eb_0000000000000_0000_000003 => out schema: {(3) default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)} => in schema: {(3) default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)} http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Sort_NoBroadcast.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Sort_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Sort_NoBroadcast.plan index f8ce426..8e9e7f1 100644 --- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Sort_NoBroadcast.plan +++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Sort_NoBroadcast.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(5) - => Sort Keys: default.n1.n_nationkey (INT4) (asc) + => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last) JOIN(8)(INNER) => Join Cond: name1 (TEXT) = name2 (TEXT) => target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT) @@ -83,7 +83,7 @@ Block Id: eb_0000000000000_0000_000003 [INTERMEDIATE] [q_0000000000000_0000] 3 => 4 (type=RANGE_SHUFFLE, key=default.n1.n_nationkey (INT4), num=32) SORT(12) - => Sort Keys: default.n1.n_nationkey (INT4) (asc) + => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last) JOIN(8)(INNER) => Join Cond: name1 (TEXT) = name2 (TEXT) => target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT) @@ -107,7 +107,7 @@ Block Id: eb_0000000000000_0000_000004 [ROOT] 0: sorted input=eb_0000000000000_0000_000003 SORT(5) - => Sort Keys: default.n1.n_nationkey (INT4) (asc) + => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last) SCAN(13) on eb_0000000000000_0000_000003 => out schema: {(3) default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)} => in schema: {(3) default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)} http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Hash.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Hash.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Hash.plan index 2b307d7..5b34211 100644 --- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Hash.plan +++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Hash.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(8) - => Sort Keys: default.n1.n_nationkey (INT4) (asc) + => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last) JOIN(11)(INNER) => Join Cond: name1 (TEXT) = name2 (TEXT) => target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT) @@ -60,7 +60,7 @@ Block Id: eb_0000000000000_0000_000003 [LEAF] 1: type=Broadcast, tables=default.nation SORT(18) - => Sort Keys: default.n1.n_nationkey (INT4) (asc) + => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last) JOIN(11)(INNER) => Join Cond: name1 (TEXT) = name2 (TEXT) => target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT) @@ -99,7 +99,7 @@ Block Id: eb_0000000000000_0000_000005 [ROOT] 0: sorted input=eb_0000000000000_0000_000003 SORT(8) - => Sort Keys: default.n1.n_nationkey (INT4) (asc) + => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last) SCAN(19) on eb_0000000000000_0000_000003 => out schema: {(3) default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)} => in schema: {(3) default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)} http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Hash_NoBroadcast.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Hash_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Hash_NoBroadcast.plan index 15a4a6b..7f26e0c 100644 --- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Hash_NoBroadcast.plan +++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Hash_NoBroadcast.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(8) - => Sort Keys: default.n1.n_nationkey (INT4) (asc) + => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last) JOIN(11)(INNER) => Join Cond: name1 (TEXT) = name2 (TEXT) => target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT) @@ -111,7 +111,7 @@ Block Id: eb_0000000000000_0000_000003 [INTERMEDIATE] [q_0000000000000_0000] 3 => 5 (type=RANGE_SHUFFLE, key=default.n1.n_nationkey (INT4), num=32) SORT(18) - => Sort Keys: default.n1.n_nationkey (INT4) (asc) + => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last) JOIN(11)(INNER) => Join Cond: name1 (TEXT) = name2 (TEXT) => target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT) @@ -135,7 +135,7 @@ Block Id: eb_0000000000000_0000_000005 [ROOT] 0: sorted input=eb_0000000000000_0000_000003 SORT(8) - => Sort Keys: default.n1.n_nationkey (INT4) (asc) + => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last) SCAN(19) on eb_0000000000000_0000_000003 => out schema: {(3) default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)} => in schema: {(3) default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)} http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Sort.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Sort.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Sort.plan index 2b307d7..5b34211 100644 --- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Sort.plan +++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Sort.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(8) - => Sort Keys: default.n1.n_nationkey (INT4) (asc) + => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last) JOIN(11)(INNER) => Join Cond: name1 (TEXT) = name2 (TEXT) => target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT) @@ -60,7 +60,7 @@ Block Id: eb_0000000000000_0000_000003 [LEAF] 1: type=Broadcast, tables=default.nation SORT(18) - => Sort Keys: default.n1.n_nationkey (INT4) (asc) + => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last) JOIN(11)(INNER) => Join Cond: name1 (TEXT) = name2 (TEXT) => target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT) @@ -99,7 +99,7 @@ Block Id: eb_0000000000000_0000_000005 [ROOT] 0: sorted input=eb_0000000000000_0000_000003 SORT(8) - => Sort Keys: default.n1.n_nationkey (INT4) (asc) + => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last) SCAN(19) on eb_0000000000000_0000_000003 => out schema: {(3) default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)} => in schema: {(3) default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)} http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Sort_NoBroadcast.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Sort_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Sort_NoBroadcast.plan index 15a4a6b..7f26e0c 100644 --- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Sort_NoBroadcast.plan +++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Sort_NoBroadcast.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(8) - => Sort Keys: default.n1.n_nationkey (INT4) (asc) + => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last) JOIN(11)(INNER) => Join Cond: name1 (TEXT) = name2 (TEXT) => target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT) @@ -111,7 +111,7 @@ Block Id: eb_0000000000000_0000_000003 [INTERMEDIATE] [q_0000000000000_0000] 3 => 5 (type=RANGE_SHUFFLE, key=default.n1.n_nationkey (INT4), num=32) SORT(18) - => Sort Keys: default.n1.n_nationkey (INT4) (asc) + => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last) JOIN(11)(INNER) => Join Cond: name1 (TEXT) = name2 (TEXT) => target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT) @@ -135,7 +135,7 @@ Block Id: eb_0000000000000_0000_000005 [ROOT] 0: sorted input=eb_0000000000000_0000_000003 SORT(8) - => Sort Keys: default.n1.n_nationkey (INT4) (asc) + => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last) SCAN(19) on eb_0000000000000_0000_000003 => out schema: {(3) default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)} => in schema: {(3) default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)} http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Hash.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Hash.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Hash.plan index 280b4f8..16eaa34 100644 --- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Hash.plan +++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Hash.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(8) - => Sort Keys: default.n1.n_nationkey (INT4) (asc),default.n2.n_name (TEXT) (asc) + => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last),default.n2.n_name (TEXT) (asc, nulls last) JOIN(11)(INNER) => Join Cond: ?substr_1 (TEXT) = ?substr_2 (TEXT) => target list: default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_name (TEXT) @@ -60,7 +60,7 @@ Block Id: eb_0000000000000_0000_000003 [LEAF] 1: type=Broadcast, tables=default.nation SORT(18) - => Sort Keys: default.n1.n_nationkey (INT4) (asc),default.n2.n_name (TEXT) (asc) + => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last),default.n2.n_name (TEXT) (asc, nulls last) JOIN(11)(INNER) => Join Cond: ?substr_1 (TEXT) = ?substr_2 (TEXT) => target list: default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_name (TEXT) @@ -99,7 +99,7 @@ Block Id: eb_0000000000000_0000_000005 [ROOT] 0: sorted input=eb_0000000000000_0000_000003 SORT(8) - => Sort Keys: default.n1.n_nationkey (INT4) (asc),default.n2.n_name (TEXT) (asc) + => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last),default.n2.n_name (TEXT) (asc, nulls last) SCAN(19) on eb_0000000000000_0000_000003 => out schema: {(3) default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_name (TEXT)} => in schema: {(3) default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_name (TEXT)} http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Hash_NoBroadcast.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Hash_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Hash_NoBroadcast.plan index cd716a4..3b0fdb3 100644 --- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Hash_NoBroadcast.plan +++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Hash_NoBroadcast.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(8) - => Sort Keys: default.n1.n_nationkey (INT4) (asc),default.n2.n_name (TEXT) (asc) + => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last),default.n2.n_name (TEXT) (asc, nulls last) JOIN(11)(INNER) => Join Cond: ?substr_1 (TEXT) = ?substr_2 (TEXT) => target list: default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_name (TEXT) @@ -111,7 +111,7 @@ Block Id: eb_0000000000000_0000_000003 [INTERMEDIATE] [q_0000000000000_0000] 3 => 5 (type=RANGE_SHUFFLE, key=default.n1.n_nationkey (INT4), default.n2.n_name (TEXT), num=32) SORT(18) - => Sort Keys: default.n1.n_nationkey (INT4) (asc),default.n2.n_name (TEXT) (asc) + => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last),default.n2.n_name (TEXT) (asc, nulls last) JOIN(11)(INNER) => Join Cond: ?substr_1 (TEXT) = ?substr_2 (TEXT) => target list: default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_name (TEXT) @@ -135,7 +135,7 @@ Block Id: eb_0000000000000_0000_000005 [ROOT] 0: sorted input=eb_0000000000000_0000_000003 SORT(8) - => Sort Keys: default.n1.n_nationkey (INT4) (asc),default.n2.n_name (TEXT) (asc) + => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last),default.n2.n_name (TEXT) (asc, nulls last) SCAN(19) on eb_0000000000000_0000_000003 => out schema: {(3) default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_name (TEXT)} => in schema: {(3) default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_name (TEXT)} http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Sort.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Sort.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Sort.plan index 280b4f8..16eaa34 100644 --- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Sort.plan +++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Sort.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(8) - => Sort Keys: default.n1.n_nationkey (INT4) (asc),default.n2.n_name (TEXT) (asc) + => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last),default.n2.n_name (TEXT) (asc, nulls last) JOIN(11)(INNER) => Join Cond: ?substr_1 (TEXT) = ?substr_2 (TEXT) => target list: default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_name (TEXT) @@ -60,7 +60,7 @@ Block Id: eb_0000000000000_0000_000003 [LEAF] 1: type=Broadcast, tables=default.nation SORT(18) - => Sort Keys: default.n1.n_nationkey (INT4) (asc),default.n2.n_name (TEXT) (asc) + => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last),default.n2.n_name (TEXT) (asc, nulls last) JOIN(11)(INNER) => Join Cond: ?substr_1 (TEXT) = ?substr_2 (TEXT) => target list: default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_name (TEXT) @@ -99,7 +99,7 @@ Block Id: eb_0000000000000_0000_000005 [ROOT] 0: sorted input=eb_0000000000000_0000_000003 SORT(8) - => Sort Keys: default.n1.n_nationkey (INT4) (asc),default.n2.n_name (TEXT) (asc) + => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last),default.n2.n_name (TEXT) (asc, nulls last) SCAN(19) on eb_0000000000000_0000_000003 => out schema: {(3) default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_name (TEXT)} => in schema: {(3) default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_name (TEXT)} http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Sort_NoBroadcast.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Sort_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Sort_NoBroadcast.plan index cd716a4..3b0fdb3 100644 --- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Sort_NoBroadcast.plan +++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Sort_NoBroadcast.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(8) - => Sort Keys: default.n1.n_nationkey (INT4) (asc),default.n2.n_name (TEXT) (asc) + => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last),default.n2.n_name (TEXT) (asc, nulls last) JOIN(11)(INNER) => Join Cond: ?substr_1 (TEXT) = ?substr_2 (TEXT) => target list: default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_name (TEXT) @@ -111,7 +111,7 @@ Block Id: eb_0000000000000_0000_000003 [INTERMEDIATE] [q_0000000000000_0000] 3 => 5 (type=RANGE_SHUFFLE, key=default.n1.n_nationkey (INT4), default.n2.n_name (TEXT), num=32) SORT(18) - => Sort Keys: default.n1.n_nationkey (INT4) (asc),default.n2.n_name (TEXT) (asc) + => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last),default.n2.n_name (TEXT) (asc, nulls last) JOIN(11)(INNER) => Join Cond: ?substr_1 (TEXT) = ?substr_2 (TEXT) => target list: default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_name (TEXT) @@ -135,7 +135,7 @@ Block Id: eb_0000000000000_0000_000005 [ROOT] 0: sorted input=eb_0000000000000_0000_000003 SORT(8) - => Sort Keys: default.n1.n_nationkey (INT4) (asc),default.n2.n_name (TEXT) (asc) + => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last),default.n2.n_name (TEXT) (asc, nulls last) SCAN(19) on eb_0000000000000_0000_000003 => out schema: {(3) default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_name (TEXT)} => in schema: {(3) default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_name (TEXT)} http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Hash.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Hash.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Hash.plan index cf59edb..0653638 100644 --- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Hash.plan +++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Hash.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(8) - => Sort Keys: default.n.n_nationkey (INT4) (asc) + => Sort Keys: default.n.n_nationkey (INT4) (asc, nulls last) SELECTION(11) => Search Cond: CAST (default.n.n_nationkey (INT4) AS INT8) > default.t.cnt (INT8) JOIN(13)(INNER) @@ -96,7 +96,7 @@ Block Id: eb_0000000000000_0000_000006 [INTERMEDIATE] 0: type=Broadcast, tables=default.n SORT(21) - => Sort Keys: default.n.n_nationkey (INT4) (asc) + => Sort Keys: default.n.n_nationkey (INT4) (asc, nulls last) SELECTION(11) => Search Cond: CAST (default.n.n_nationkey (INT4) AS INT8) > default.t.cnt (INT8) JOIN(13)(INNER) @@ -136,7 +136,7 @@ Block Id: eb_0000000000000_0000_000007 [ROOT] 0: sorted input=eb_0000000000000_0000_000006 SORT(8) - => Sort Keys: default.n.n_nationkey (INT4) (asc) + => Sort Keys: default.n.n_nationkey (INT4) (asc, nulls last) SCAN(22) on eb_0000000000000_0000_000006 => out schema: {(4) default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4), default.t.cnt (INT8)} => in schema: {(4) default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4), default.t.cnt (INT8)} http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Hash_NoBroadcast.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Hash_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Hash_NoBroadcast.plan index d2d5617..c036ecf 100644 --- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Hash_NoBroadcast.plan +++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Hash_NoBroadcast.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(8) - => Sort Keys: default.n.n_nationkey (INT4) (asc) + => Sort Keys: default.n.n_nationkey (INT4) (asc, nulls last) SELECTION(11) => Search Cond: CAST (default.n.n_nationkey (INT4) AS INT8) > default.t.cnt (INT8) JOIN(13)(INNER) @@ -164,7 +164,7 @@ Block Id: eb_0000000000000_0000_000006 [INTERMEDIATE] [q_0000000000000_0000] 6 => 7 (type=RANGE_SHUFFLE, key=default.n.n_nationkey (INT4), num=32) SORT(21) - => Sort Keys: default.n.n_nationkey (INT4) (asc) + => Sort Keys: default.n.n_nationkey (INT4) (asc, nulls last) SELECTION(11) => Search Cond: CAST (default.n.n_nationkey (INT4) AS INT8) > default.t.cnt (INT8) JOIN(13)(INNER) @@ -190,7 +190,7 @@ Block Id: eb_0000000000000_0000_000007 [ROOT] 0: sorted input=eb_0000000000000_0000_000006 SORT(8) - => Sort Keys: default.n.n_nationkey (INT4) (asc) + => Sort Keys: default.n.n_nationkey (INT4) (asc, nulls last) SCAN(22) on eb_0000000000000_0000_000006 => out schema: {(4) default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4), default.t.cnt (INT8)} => in schema: {(4) default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4), default.t.cnt (INT8)} http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Sort.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Sort.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Sort.plan index cf59edb..0653638 100644 --- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Sort.plan +++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Sort.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(8) - => Sort Keys: default.n.n_nationkey (INT4) (asc) + => Sort Keys: default.n.n_nationkey (INT4) (asc, nulls last) SELECTION(11) => Search Cond: CAST (default.n.n_nationkey (INT4) AS INT8) > default.t.cnt (INT8) JOIN(13)(INNER) @@ -96,7 +96,7 @@ Block Id: eb_0000000000000_0000_000006 [INTERMEDIATE] 0: type=Broadcast, tables=default.n SORT(21) - => Sort Keys: default.n.n_nationkey (INT4) (asc) + => Sort Keys: default.n.n_nationkey (INT4) (asc, nulls last) SELECTION(11) => Search Cond: CAST (default.n.n_nationkey (INT4) AS INT8) > default.t.cnt (INT8) JOIN(13)(INNER) @@ -136,7 +136,7 @@ Block Id: eb_0000000000000_0000_000007 [ROOT] 0: sorted input=eb_0000000000000_0000_000006 SORT(8) - => Sort Keys: default.n.n_nationkey (INT4) (asc) + => Sort Keys: default.n.n_nationkey (INT4) (asc, nulls last) SCAN(22) on eb_0000000000000_0000_000006 => out schema: {(4) default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4), default.t.cnt (INT8)} => in schema: {(4) default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4), default.t.cnt (INT8)} http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Sort_NoBroadcast.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Sort_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Sort_NoBroadcast.plan index d2d5617..c036ecf 100644 --- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Sort_NoBroadcast.plan +++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Sort_NoBroadcast.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(8) - => Sort Keys: default.n.n_nationkey (INT4) (asc) + => Sort Keys: default.n.n_nationkey (INT4) (asc, nulls last) SELECTION(11) => Search Cond: CAST (default.n.n_nationkey (INT4) AS INT8) > default.t.cnt (INT8) JOIN(13)(INNER) @@ -164,7 +164,7 @@ Block Id: eb_0000000000000_0000_000006 [INTERMEDIATE] [q_0000000000000_0000] 6 => 7 (type=RANGE_SHUFFLE, key=default.n.n_nationkey (INT4), num=32) SORT(21) - => Sort Keys: default.n.n_nationkey (INT4) (asc) + => Sort Keys: default.n.n_nationkey (INT4) (asc, nulls last) SELECTION(11) => Search Cond: CAST (default.n.n_nationkey (INT4) AS INT8) > default.t.cnt (INT8) JOIN(13)(INNER) @@ -190,7 +190,7 @@ Block Id: eb_0000000000000_0000_000007 [ROOT] 0: sorted input=eb_0000000000000_0000_000006 SORT(8) - => Sort Keys: default.n.n_nationkey (INT4) (asc) + => Sort Keys: default.n.n_nationkey (INT4) (asc, nulls last) SCAN(22) on eb_0000000000000_0000_000006 => out schema: {(4) default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4), default.t.cnt (INT8)} => in schema: {(4) default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4), default.t.cnt (INT8)} http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Hash.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Hash.plan b/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Hash.plan index 6bec7f2..63ac101 100644 --- a/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Hash.plan +++ b/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Hash.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(5) - => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc) + => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last) JOIN(9)(LEFT_OUTER) => Join Cond: default.supplier.s_nationkey (INT4) = default.nation.n_nationkey (INT4) => target list: CASE WHEN default.supplier.s_name (TEXT) IS NULL THEN N/O ELSE default.supplier.s_name (TEXT) END as s1, default.region.r_name (TEXT) @@ -52,7 +52,7 @@ Block Id: eb_0000000000000_0000_000005 [LEAF] 1: type=Broadcast, tables=default.supplier SORT(15) - => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc) + => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last) JOIN(9)(LEFT_OUTER) => Join Cond: default.supplier.s_nationkey (INT4) = default.nation.n_nationkey (INT4) => target list: CASE WHEN default.supplier.s_name (TEXT) IS NULL THEN N/O ELSE default.supplier.s_name (TEXT) END as s1, default.region.r_name (TEXT) @@ -87,7 +87,7 @@ Block Id: eb_0000000000000_0000_000006 [ROOT] 0: sorted input=eb_0000000000000_0000_000005 SORT(5) - => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc) + => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last) SCAN(16) on eb_0000000000000_0000_000005 => out schema: {(2) default.region.r_name (TEXT), s1 (TEXT)} => in schema: {(2) default.region.r_name (TEXT), s1 (TEXT)} http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Hash_NoBroadcast.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Hash_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Hash_NoBroadcast.plan index 5cba003..2216605 100644 --- a/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Hash_NoBroadcast.plan +++ b/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Hash_NoBroadcast.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(5) - => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc) + => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last) JOIN(9)(LEFT_OUTER) => Join Cond: default.supplier.s_nationkey (INT4) = default.nation.n_nationkey (INT4) => target list: CASE WHEN default.supplier.s_name (TEXT) IS NULL THEN N/O ELSE default.supplier.s_name (TEXT) END as s1, default.region.r_name (TEXT) @@ -119,7 +119,7 @@ Block Id: eb_0000000000000_0000_000005 [INTERMEDIATE] [q_0000000000000_0000] 5 => 6 (type=RANGE_SHUFFLE, key=default.region.r_name (TEXT), s1 (TEXT), num=32) SORT(15) - => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc) + => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last) JOIN(9)(LEFT_OUTER) => Join Cond: default.supplier.s_nationkey (INT4) = default.nation.n_nationkey (INT4) => target list: CASE WHEN default.supplier.s_name (TEXT) IS NULL THEN N/O ELSE default.supplier.s_name (TEXT) END as s1, default.region.r_name (TEXT) @@ -143,7 +143,7 @@ Block Id: eb_0000000000000_0000_000006 [ROOT] 0: sorted input=eb_0000000000000_0000_000005 SORT(5) - => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc) + => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last) SCAN(16) on eb_0000000000000_0000_000005 => out schema: {(2) default.region.r_name (TEXT), s1 (TEXT)} => in schema: {(2) default.region.r_name (TEXT), s1 (TEXT)} http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Sort.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Sort.plan b/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Sort.plan index 6bec7f2..63ac101 100644 --- a/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Sort.plan +++ b/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Sort.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(5) - => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc) + => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last) JOIN(9)(LEFT_OUTER) => Join Cond: default.supplier.s_nationkey (INT4) = default.nation.n_nationkey (INT4) => target list: CASE WHEN default.supplier.s_name (TEXT) IS NULL THEN N/O ELSE default.supplier.s_name (TEXT) END as s1, default.region.r_name (TEXT) @@ -52,7 +52,7 @@ Block Id: eb_0000000000000_0000_000005 [LEAF] 1: type=Broadcast, tables=default.supplier SORT(15) - => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc) + => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last) JOIN(9)(LEFT_OUTER) => Join Cond: default.supplier.s_nationkey (INT4) = default.nation.n_nationkey (INT4) => target list: CASE WHEN default.supplier.s_name (TEXT) IS NULL THEN N/O ELSE default.supplier.s_name (TEXT) END as s1, default.region.r_name (TEXT) @@ -87,7 +87,7 @@ Block Id: eb_0000000000000_0000_000006 [ROOT] 0: sorted input=eb_0000000000000_0000_000005 SORT(5) - => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc) + => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last) SCAN(16) on eb_0000000000000_0000_000005 => out schema: {(2) default.region.r_name (TEXT), s1 (TEXT)} => in schema: {(2) default.region.r_name (TEXT), s1 (TEXT)} http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Sort_NoBroadcast.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Sort_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Sort_NoBroadcast.plan index 5cba003..2216605 100644 --- a/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Sort_NoBroadcast.plan +++ b/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Sort_NoBroadcast.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(5) - => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc) + => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last) JOIN(9)(LEFT_OUTER) => Join Cond: default.supplier.s_nationkey (INT4) = default.nation.n_nationkey (INT4) => target list: CASE WHEN default.supplier.s_name (TEXT) IS NULL THEN N/O ELSE default.supplier.s_name (TEXT) END as s1, default.region.r_name (TEXT) @@ -119,7 +119,7 @@ Block Id: eb_0000000000000_0000_000005 [INTERMEDIATE] [q_0000000000000_0000] 5 => 6 (type=RANGE_SHUFFLE, key=default.region.r_name (TEXT), s1 (TEXT), num=32) SORT(15) - => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc) + => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last) JOIN(9)(LEFT_OUTER) => Join Cond: default.supplier.s_nationkey (INT4) = default.nation.n_nationkey (INT4) => target list: CASE WHEN default.supplier.s_name (TEXT) IS NULL THEN N/O ELSE default.supplier.s_name (TEXT) END as s1, default.region.r_name (TEXT) @@ -143,7 +143,7 @@ Block Id: eb_0000000000000_0000_000006 [ROOT] 0: sorted input=eb_0000000000000_0000_000005 SORT(5) - => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc) + => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last) SCAN(16) on eb_0000000000000_0000_000005 => out schema: {(2) default.region.r_name (TEXT), s1 (TEXT)} => in schema: {(2) default.region.r_name (TEXT), s1 (TEXT)} http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Hash.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Hash.plan b/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Hash.plan index 8622663..894197b 100644 --- a/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Hash.plan +++ b/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Hash.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(7) - => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc) + => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last) JOIN(11)(INNER) => Join Cond: default.t.n_regionkey (INT4) = default.region.r_regionkey (INT4) => target list: default.region.r_name (TEXT), s1 (TEXT) @@ -56,7 +56,7 @@ Block Id: eb_0000000000000_0000_000005 [LEAF] 1: type=Broadcast, tables=default.supplier SORT(17) - => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc) + => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last) JOIN(11)(INNER) => Join Cond: default.t.n_regionkey (INT4) = default.region.r_regionkey (INT4) => target list: default.region.r_name (TEXT), s1 (TEXT) @@ -99,7 +99,7 @@ Block Id: eb_0000000000000_0000_000006 [ROOT] 0: sorted input=eb_0000000000000_0000_000005 SORT(7) - => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc) + => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last) SCAN(18) on eb_0000000000000_0000_000005 => out schema: {(2) default.region.r_name (TEXT), s1 (TEXT)} => in schema: {(2) default.region.r_name (TEXT), s1 (TEXT)} http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Hash_NoBroadcast.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Hash_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Hash_NoBroadcast.plan index af9b3a5..791b296 100644 --- a/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Hash_NoBroadcast.plan +++ b/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Hash_NoBroadcast.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(7) - => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc) + => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last) JOIN(11)(INNER) => Join Cond: default.t.n_regionkey (INT4) = default.region.r_regionkey (INT4) => target list: default.region.r_name (TEXT), s1 (TEXT) @@ -131,7 +131,7 @@ Block Id: eb_0000000000000_0000_000005 [INTERMEDIATE] [q_0000000000000_0000] 5 => 6 (type=RANGE_SHUFFLE, key=default.region.r_name (TEXT), s1 (TEXT), num=32) SORT(17) - => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc) + => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last) JOIN(11)(INNER) => Join Cond: default.t.n_regionkey (INT4) = default.region.r_regionkey (INT4) => target list: default.region.r_name (TEXT), s1 (TEXT) @@ -155,7 +155,7 @@ Block Id: eb_0000000000000_0000_000006 [ROOT] 0: sorted input=eb_0000000000000_0000_000005 SORT(7) - => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc) + => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last) SCAN(18) on eb_0000000000000_0000_000005 => out schema: {(2) default.region.r_name (TEXT), s1 (TEXT)} => in schema: {(2) default.region.r_name (TEXT), s1 (TEXT)} http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Sort.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Sort.plan b/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Sort.plan index 8622663..894197b 100644 --- a/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Sort.plan +++ b/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Sort.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(7) - => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc) + => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last) JOIN(11)(INNER) => Join Cond: default.t.n_regionkey (INT4) = default.region.r_regionkey (INT4) => target list: default.region.r_name (TEXT), s1 (TEXT) @@ -56,7 +56,7 @@ Block Id: eb_0000000000000_0000_000005 [LEAF] 1: type=Broadcast, tables=default.supplier SORT(17) - => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc) + => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last) JOIN(11)(INNER) => Join Cond: default.t.n_regionkey (INT4) = default.region.r_regionkey (INT4) => target list: default.region.r_name (TEXT), s1 (TEXT) @@ -99,7 +99,7 @@ Block Id: eb_0000000000000_0000_000006 [ROOT] 0: sorted input=eb_0000000000000_0000_000005 SORT(7) - => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc) + => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last) SCAN(18) on eb_0000000000000_0000_000005 => out schema: {(2) default.region.r_name (TEXT), s1 (TEXT)} => in schema: {(2) default.region.r_name (TEXT), s1 (TEXT)} http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Sort_NoBroadcast.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Sort_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Sort_NoBroadcast.plan index af9b3a5..791b296 100644 --- a/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Sort_NoBroadcast.plan +++ b/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Sort_NoBroadcast.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(7) - => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc) + => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last) JOIN(11)(INNER) => Join Cond: default.t.n_regionkey (INT4) = default.region.r_regionkey (INT4) => target list: default.region.r_name (TEXT), s1 (TEXT) @@ -131,7 +131,7 @@ Block Id: eb_0000000000000_0000_000005 [INTERMEDIATE] [q_0000000000000_0000] 5 => 6 (type=RANGE_SHUFFLE, key=default.region.r_name (TEXT), s1 (TEXT), num=32) SORT(17) - => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc) + => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last) JOIN(11)(INNER) => Join Cond: default.t.n_regionkey (INT4) = default.region.r_regionkey (INT4) => target list: default.region.r_name (TEXT), s1 (TEXT) @@ -155,7 +155,7 @@ Block Id: eb_0000000000000_0000_000006 [ROOT] 0: sorted input=eb_0000000000000_0000_000005 SORT(7) - => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc) + => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last) SCAN(18) on eb_0000000000000_0000_000005 => out schema: {(2) default.region.r_name (TEXT), s1 (TEXT)} => in schema: {(2) default.region.r_name (TEXT), s1 (TEXT)} http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Hash.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Hash.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Hash.plan index eab9940..8c98e69 100644 --- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Hash.plan +++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Hash.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(3) - => Sort Keys: default.customer.c_custkey (INT4) (asc),default.orders.o_orderkey (INT4) (asc) + => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.orders.o_orderkey (INT4) (asc, nulls last) JOIN(6)(FULL_OUTER) => Join Cond: default.customer.c_custkey (INT4) = default.orders.o_orderkey (INT4) => target list: default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4) @@ -71,7 +71,7 @@ Block Id: eb_0000000000000_0000_000003 [INTERMEDIATE] [q_0000000000000_0000] 3 => 4 (type=RANGE_SHUFFLE, key=default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4), num=32) SORT(10) - => Sort Keys: default.customer.c_custkey (INT4) (asc),default.orders.o_orderkey (INT4) (asc) + => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.orders.o_orderkey (INT4) (asc, nulls last) JOIN(6)(FULL_OUTER) => Join Cond: default.customer.c_custkey (INT4) = default.orders.o_orderkey (INT4) => target list: default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4) @@ -95,7 +95,7 @@ Block Id: eb_0000000000000_0000_000004 [ROOT] 0: sorted input=eb_0000000000000_0000_000003 SORT(3) - => Sort Keys: default.customer.c_custkey (INT4) (asc),default.orders.o_orderkey (INT4) (asc) + => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.orders.o_orderkey (INT4) (asc, nulls last) SCAN(11) on eb_0000000000000_0000_000003 => out schema: {(2) default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4)} => in schema: {(2) default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4)} http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Hash_NoBroadcast.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Hash_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Hash_NoBroadcast.plan index eab9940..8c98e69 100644 --- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Hash_NoBroadcast.plan +++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Hash_NoBroadcast.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(3) - => Sort Keys: default.customer.c_custkey (INT4) (asc),default.orders.o_orderkey (INT4) (asc) + => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.orders.o_orderkey (INT4) (asc, nulls last) JOIN(6)(FULL_OUTER) => Join Cond: default.customer.c_custkey (INT4) = default.orders.o_orderkey (INT4) => target list: default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4) @@ -71,7 +71,7 @@ Block Id: eb_0000000000000_0000_000003 [INTERMEDIATE] [q_0000000000000_0000] 3 => 4 (type=RANGE_SHUFFLE, key=default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4), num=32) SORT(10) - => Sort Keys: default.customer.c_custkey (INT4) (asc),default.orders.o_orderkey (INT4) (asc) + => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.orders.o_orderkey (INT4) (asc, nulls last) JOIN(6)(FULL_OUTER) => Join Cond: default.customer.c_custkey (INT4) = default.orders.o_orderkey (INT4) => target list: default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4) @@ -95,7 +95,7 @@ Block Id: eb_0000000000000_0000_000004 [ROOT] 0: sorted input=eb_0000000000000_0000_000003 SORT(3) - => Sort Keys: default.customer.c_custkey (INT4) (asc),default.orders.o_orderkey (INT4) (asc) + => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.orders.o_orderkey (INT4) (asc, nulls last) SCAN(11) on eb_0000000000000_0000_000003 => out schema: {(2) default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4)} => in schema: {(2) default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4)} http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Sort.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Sort.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Sort.plan index eab9940..8c98e69 100644 --- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Sort.plan +++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Sort.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(3) - => Sort Keys: default.customer.c_custkey (INT4) (asc),default.orders.o_orderkey (INT4) (asc) + => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.orders.o_orderkey (INT4) (asc, nulls last) JOIN(6)(FULL_OUTER) => Join Cond: default.customer.c_custkey (INT4) = default.orders.o_orderkey (INT4) => target list: default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4) @@ -71,7 +71,7 @@ Block Id: eb_0000000000000_0000_000003 [INTERMEDIATE] [q_0000000000000_0000] 3 => 4 (type=RANGE_SHUFFLE, key=default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4), num=32) SORT(10) - => Sort Keys: default.customer.c_custkey (INT4) (asc),default.orders.o_orderkey (INT4) (asc) + => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.orders.o_orderkey (INT4) (asc, nulls last) JOIN(6)(FULL_OUTER) => Join Cond: default.customer.c_custkey (INT4) = default.orders.o_orderkey (INT4) => target list: default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4) @@ -95,7 +95,7 @@ Block Id: eb_0000000000000_0000_000004 [ROOT] 0: sorted input=eb_0000000000000_0000_000003 SORT(3) - => Sort Keys: default.customer.c_custkey (INT4) (asc),default.orders.o_orderkey (INT4) (asc) + => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.orders.o_orderkey (INT4) (asc, nulls last) SCAN(11) on eb_0000000000000_0000_000003 => out schema: {(2) default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4)} => in schema: {(2) default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4)} http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Sort_NoBroadcast.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Sort_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Sort_NoBroadcast.plan index eab9940..8c98e69 100644 --- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Sort_NoBroadcast.plan +++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Sort_NoBroadcast.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(3) - => Sort Keys: default.customer.c_custkey (INT4) (asc),default.orders.o_orderkey (INT4) (asc) + => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.orders.o_orderkey (INT4) (asc, nulls last) JOIN(6)(FULL_OUTER) => Join Cond: default.customer.c_custkey (INT4) = default.orders.o_orderkey (INT4) => target list: default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4) @@ -71,7 +71,7 @@ Block Id: eb_0000000000000_0000_000003 [INTERMEDIATE] [q_0000000000000_0000] 3 => 4 (type=RANGE_SHUFFLE, key=default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4), num=32) SORT(10) - => Sort Keys: default.customer.c_custkey (INT4) (asc),default.orders.o_orderkey (INT4) (asc) + => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.orders.o_orderkey (INT4) (asc, nulls last) JOIN(6)(FULL_OUTER) => Join Cond: default.customer.c_custkey (INT4) = default.orders.o_orderkey (INT4) => target list: default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4) @@ -95,7 +95,7 @@ Block Id: eb_0000000000000_0000_000004 [ROOT] 0: sorted input=eb_0000000000000_0000_000003 SORT(3) - => Sort Keys: default.customer.c_custkey (INT4) (asc),default.orders.o_orderkey (INT4) (asc) + => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.orders.o_orderkey (INT4) (asc, nulls last) SCAN(11) on eb_0000000000000_0000_000003 => out schema: {(2) default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4)} => in schema: {(2) default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4)} http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinPredicationCaseByCase1.1.Hash.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinPredicationCaseByCase1.1.Hash.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinPredicationCaseByCase1.1.Hash.plan index 25f5eeb..8d16168 100644 --- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinPredicationCaseByCase1.1.Hash.plan +++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinPredicationCaseByCase1.1.Hash.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(5) - => Sort Keys: default.t4.id (INT4) (asc) + => Sort Keys: default.t4.id (INT4) (asc, nulls last) JOIN(9)(FULL_OUTER) => Join Cond: default.t1.id (INT4) = default.t3.id (INT4) => target list: default.t1.id (INT4), default.t1.name (TEXT), default.t3.id (INT4), default.t4.id (INT4) @@ -119,7 +119,7 @@ Block Id: eb_0000000000000_0000_000005 [INTERMEDIATE] [q_0000000000000_0000] 5 => 6 (type=RANGE_SHUFFLE, key=default.t4.id (INT4), num=32) SORT(15) - => Sort Keys: default.t4.id (INT4) (asc) + => Sort Keys: default.t4.id (INT4) (asc, nulls last) JOIN(9)(FULL_OUTER) => Join Cond: default.t1.id (INT4) = default.t3.id (INT4) => target list: default.t1.id (INT4), default.t1.name (TEXT), default.t3.id (INT4), default.t4.id (INT4) @@ -143,7 +143,7 @@ Block Id: eb_0000000000000_0000_000006 [ROOT] 0: sorted input=eb_0000000000000_0000_000005 SORT(5) - => Sort Keys: default.t4.id (INT4) (asc) + => Sort Keys: default.t4.id (INT4) (asc, nulls last) SCAN(16) on eb_0000000000000_0000_000005 => out schema: {(4) default.t1.id (INT4), default.t1.name (TEXT), default.t3.id (INT4), default.t4.id (INT4)} => in schema: {(4) default.t1.id (INT4), default.t1.name (TEXT), default.t3.id (INT4), default.t4.id (INT4)} http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinPredicationCaseByCase1.1.Hash_NoBroadcast.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinPredicationCaseByCase1.1.Hash_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinPredicationCaseByCase1.1.Hash_NoBroadcast.plan index 25f5eeb..8d16168 100644 --- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinPredicationCaseByCase1.1.Hash_NoBroadcast.plan +++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinPredicationCaseByCase1.1.Hash_NoBroadcast.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(5) - => Sort Keys: default.t4.id (INT4) (asc) + => Sort Keys: default.t4.id (INT4) (asc, nulls last) JOIN(9)(FULL_OUTER) => Join Cond: default.t1.id (INT4) = default.t3.id (INT4) => target list: default.t1.id (INT4), default.t1.name (TEXT), default.t3.id (INT4), default.t4.id (INT4) @@ -119,7 +119,7 @@ Block Id: eb_0000000000000_0000_000005 [INTERMEDIATE] [q_0000000000000_0000] 5 => 6 (type=RANGE_SHUFFLE, key=default.t4.id (INT4), num=32) SORT(15) - => Sort Keys: default.t4.id (INT4) (asc) + => Sort Keys: default.t4.id (INT4) (asc, nulls last) JOIN(9)(FULL_OUTER) => Join Cond: default.t1.id (INT4) = default.t3.id (INT4) => target list: default.t1.id (INT4), default.t1.name (TEXT), default.t3.id (INT4), default.t4.id (INT4) @@ -143,7 +143,7 @@ Block Id: eb_0000000000000_0000_000006 [ROOT] 0: sorted input=eb_0000000000000_0000_000005 SORT(5) - => Sort Keys: default.t4.id (INT4) (asc) + => Sort Keys: default.t4.id (INT4) (asc, nulls last) SCAN(16) on eb_0000000000000_0000_000005 => out schema: {(4) default.t1.id (INT4), default.t1.name (TEXT), default.t3.id (INT4), default.t4.id (INT4)} => in schema: {(4) default.t1.id (INT4), default.t1.name (TEXT), default.t3.id (INT4), default.t4.id (INT4)} http://git-wip-us.apache.org/repos/asf/tajo/blob/8209e4c8/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinPredicationCaseByCase1.1.Sort.plan ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinPredicationCaseByCase1.1.Sort.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinPredicationCaseByCase1.1.Sort.plan index 25f5eeb..8d16168 100644 --- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinPredicationCaseByCase1.1.Sort.plan +++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinPredicationCaseByCase1.1.Sort.plan @@ -1,7 +1,7 @@ explain ------------------------------- SORT(5) - => Sort Keys: default.t4.id (INT4) (asc) + => Sort Keys: default.t4.id (INT4) (asc, nulls last) JOIN(9)(FULL_OUTER) => Join Cond: default.t1.id (INT4) = default.t3.id (INT4) => target list: default.t1.id (INT4), default.t1.name (TEXT), default.t3.id (INT4), default.t4.id (INT4) @@ -119,7 +119,7 @@ Block Id: eb_0000000000000_0000_000005 [INTERMEDIATE] [q_0000000000000_0000] 5 => 6 (type=RANGE_SHUFFLE, key=default.t4.id (INT4), num=32) SORT(15) - => Sort Keys: default.t4.id (INT4) (asc) + => Sort Keys: default.t4.id (INT4) (asc, nulls last) JOIN(9)(FULL_OUTER) => Join Cond: default.t1.id (INT4) = default.t3.id (INT4) => target list: default.t1.id (INT4), default.t1.name (TEXT), default.t3.id (INT4), default.t4.id (INT4) @@ -143,7 +143,7 @@ Block Id: eb_0000000000000_0000_000006 [ROOT] 0: sorted input=eb_0000000000000_0000_000005 SORT(5) - => Sort Keys: default.t4.id (INT4) (asc) + => Sort Keys: default.t4.id (INT4) (asc, nulls last) SCAN(16) on eb_0000000000000_0000_000005 => out schema: {(4) default.t1.id (INT4), default.t1.name (TEXT), default.t3.id (INT4), default.t4.id (INT4)} => in schema: {(4) default.t1.id (INT4), default.t1.name (TEXT), default.t3.id (INT4), default.t4.id (INT4)}
