You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@tajo.apache.org by ji...@apache.org on 2015/11/18 13:12:58 UTC
[3/8] tajo git commit: TAJO-1981: Invalid nulls sort order in
VectorizedSorter.
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinPredicationCaseByCase1.1.Sort_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinPredicationCaseByCase1.1.Sort_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinPredicationCaseByCase1.1.Sort_NoBroadcast.plan
index 25f5eeb..8d16168 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinPredicationCaseByCase1.1.Sort_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinPredicationCaseByCase1.1.Sort_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/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinWithEmptyTable1.Hash.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinWithEmptyTable1.Hash.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinWithEmptyTable1.Hash.plan
index ae57b83..0de1459 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinWithEmptyTable1.Hash.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinWithEmptyTable1.Hash.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(3)
- => Sort Keys: default.customer.c_custkey (INT4) (asc),default.empty_orders.o_orderkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.empty_orders.o_orderkey (INT4) (asc, nulls last)
JOIN(6)(FULL_OUTER)
=> Join Cond: default.customer.c_custkey (INT4) = default.empty_orders.o_orderkey (INT4)
=> target list: default.customer.c_custkey (INT4), default.empty_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.empty_orders.o_orderkey (INT4), num=32)
SORT(10)
- => Sort Keys: default.customer.c_custkey (INT4) (asc),default.empty_orders.o_orderkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.empty_orders.o_orderkey (INT4) (asc, nulls last)
JOIN(6)(FULL_OUTER)
=> Join Cond: default.customer.c_custkey (INT4) = default.empty_orders.o_orderkey (INT4)
=> target list: default.customer.c_custkey (INT4), default.empty_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.empty_orders.o_orderkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.empty_orders.o_orderkey (INT4) (asc, nulls last)
SCAN(11) on eb_0000000000000_0000_000003
=> out schema: {(2) default.customer.c_custkey (INT4), default.empty_orders.o_orderkey (INT4)}
=> in schema: {(2) default.customer.c_custkey (INT4), default.empty_orders.o_orderkey (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinWithEmptyTable1.Hash_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinWithEmptyTable1.Hash_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinWithEmptyTable1.Hash_NoBroadcast.plan
index ae57b83..0de1459 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinWithEmptyTable1.Hash_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinWithEmptyTable1.Hash_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(3)
- => Sort Keys: default.customer.c_custkey (INT4) (asc),default.empty_orders.o_orderkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.empty_orders.o_orderkey (INT4) (asc, nulls last)
JOIN(6)(FULL_OUTER)
=> Join Cond: default.customer.c_custkey (INT4) = default.empty_orders.o_orderkey (INT4)
=> target list: default.customer.c_custkey (INT4), default.empty_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.empty_orders.o_orderkey (INT4), num=32)
SORT(10)
- => Sort Keys: default.customer.c_custkey (INT4) (asc),default.empty_orders.o_orderkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.empty_orders.o_orderkey (INT4) (asc, nulls last)
JOIN(6)(FULL_OUTER)
=> Join Cond: default.customer.c_custkey (INT4) = default.empty_orders.o_orderkey (INT4)
=> target list: default.customer.c_custkey (INT4), default.empty_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.empty_orders.o_orderkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.empty_orders.o_orderkey (INT4) (asc, nulls last)
SCAN(11) on eb_0000000000000_0000_000003
=> out schema: {(2) default.customer.c_custkey (INT4), default.empty_orders.o_orderkey (INT4)}
=> in schema: {(2) default.customer.c_custkey (INT4), default.empty_orders.o_orderkey (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinWithEmptyTable1.Sort.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinWithEmptyTable1.Sort.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinWithEmptyTable1.Sort.plan
index ae57b83..0de1459 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinWithEmptyTable1.Sort.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinWithEmptyTable1.Sort.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(3)
- => Sort Keys: default.customer.c_custkey (INT4) (asc),default.empty_orders.o_orderkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.empty_orders.o_orderkey (INT4) (asc, nulls last)
JOIN(6)(FULL_OUTER)
=> Join Cond: default.customer.c_custkey (INT4) = default.empty_orders.o_orderkey (INT4)
=> target list: default.customer.c_custkey (INT4), default.empty_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.empty_orders.o_orderkey (INT4), num=32)
SORT(10)
- => Sort Keys: default.customer.c_custkey (INT4) (asc),default.empty_orders.o_orderkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.empty_orders.o_orderkey (INT4) (asc, nulls last)
JOIN(6)(FULL_OUTER)
=> Join Cond: default.customer.c_custkey (INT4) = default.empty_orders.o_orderkey (INT4)
=> target list: default.customer.c_custkey (INT4), default.empty_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.empty_orders.o_orderkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.empty_orders.o_orderkey (INT4) (asc, nulls last)
SCAN(11) on eb_0000000000000_0000_000003
=> out schema: {(2) default.customer.c_custkey (INT4), default.empty_orders.o_orderkey (INT4)}
=> in schema: {(2) default.customer.c_custkey (INT4), default.empty_orders.o_orderkey (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinWithEmptyTable1.Sort_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinWithEmptyTable1.Sort_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinWithEmptyTable1.Sort_NoBroadcast.plan
index ae57b83..0de1459 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinWithEmptyTable1.Sort_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinWithEmptyTable1.Sort_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(3)
- => Sort Keys: default.customer.c_custkey (INT4) (asc),default.empty_orders.o_orderkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.empty_orders.o_orderkey (INT4) (asc, nulls last)
JOIN(6)(FULL_OUTER)
=> Join Cond: default.customer.c_custkey (INT4) = default.empty_orders.o_orderkey (INT4)
=> target list: default.customer.c_custkey (INT4), default.empty_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.empty_orders.o_orderkey (INT4), num=32)
SORT(10)
- => Sort Keys: default.customer.c_custkey (INT4) (asc),default.empty_orders.o_orderkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.empty_orders.o_orderkey (INT4) (asc, nulls last)
JOIN(6)(FULL_OUTER)
=> Join Cond: default.customer.c_custkey (INT4) = default.empty_orders.o_orderkey (INT4)
=> target list: default.customer.c_custkey (INT4), default.empty_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.empty_orders.o_orderkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.empty_orders.o_orderkey (INT4) (asc, nulls last)
SCAN(11) on eb_0000000000000_0000_000003
=> out schema: {(2) default.customer.c_custkey (INT4), default.empty_orders.o_orderkey (INT4)}
=> in schema: {(2) default.customer.c_custkey (INT4), default.empty_orders.o_orderkey (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testJoinFilterOfRowPreservedTable1.Hash.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testJoinFilterOfRowPreservedTable1.Hash.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testJoinFilterOfRowPreservedTable1.Hash.plan
index e9d4ea7..dd6c95d 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testJoinFilterOfRowPreservedTable1.Hash.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testJoinFilterOfRowPreservedTable1.Hash.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(3)
- => Sort Keys: default.region.r_name (TEXT) (asc),default.nation.n_name (TEXT) (asc)
+ => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last)
JOIN(6)(LEFT_OUTER)
=> Join Cond: (default.nation.n_regionkey (INT4) = default.region.r_regionkey (INT4) AND default.region.r_name (TEXT) IN (AMERICA, ASIA))
=> target list: default.nation.n_name (TEXT), default.nation.n_regionkey (INT4), default.region.r_name (TEXT), default.region.r_regionkey (INT4)
@@ -42,7 +42,7 @@ Block Id: eb_0000000000000_0000_000003 [LEAF]
0: type=Broadcast, tables=default.nation
SORT(10)
- => Sort Keys: default.region.r_name (TEXT) (asc),default.nation.n_name (TEXT) (asc)
+ => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last)
JOIN(6)(LEFT_OUTER)
=> Join Cond: (default.nation.n_regionkey (INT4) = default.region.r_regionkey (INT4) AND default.region.r_name (TEXT) IN (AMERICA, ASIA))
=> target list: default.nation.n_name (TEXT), default.nation.n_regionkey (INT4), default.region.r_name (TEXT), default.region.r_regionkey (INT4)
@@ -68,7 +68,7 @@ Block Id: eb_0000000000000_0000_000004 [ROOT]
0: sorted input=eb_0000000000000_0000_000003
SORT(3)
- => Sort Keys: default.region.r_name (TEXT) (asc),default.nation.n_name (TEXT) (asc)
+ => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last)
SCAN(11) on eb_0000000000000_0000_000003
=> out schema: {(4) default.nation.n_name (TEXT), default.nation.n_regionkey (INT4), default.region.r_name (TEXT), default.region.r_regionkey (INT4)}
=> in schema: {(4) default.nation.n_name (TEXT), default.nation.n_regionkey (INT4), default.region.r_name (TEXT), default.region.r_regionkey (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testJoinFilterOfRowPreservedTable1.Hash_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testJoinFilterOfRowPreservedTable1.Hash_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testJoinFilterOfRowPreservedTable1.Hash_NoBroadcast.plan
index 7a0bf29..85ad736 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testJoinFilterOfRowPreservedTable1.Hash_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testJoinFilterOfRowPreservedTable1.Hash_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(3)
- => Sort Keys: default.region.r_name (TEXT) (asc),default.nation.n_name (TEXT) (asc)
+ => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last)
JOIN(6)(LEFT_OUTER)
=> Join Cond: (default.nation.n_regionkey (INT4) = default.region.r_regionkey (INT4) AND default.region.r_name (TEXT) IN (AMERICA, ASIA))
=> target list: default.nation.n_name (TEXT), default.nation.n_regionkey (INT4), default.region.r_name (TEXT), default.region.r_regionkey (INT4)
@@ -71,7 +71,7 @@ Block Id: eb_0000000000000_0000_000003 [INTERMEDIATE]
[q_0000000000000_0000] 3 => 4 (type=RANGE_SHUFFLE, key=default.nation.n_name (TEXT), default.region.r_name (TEXT), num=32)
SORT(10)
- => Sort Keys: default.region.r_name (TEXT) (asc),default.nation.n_name (TEXT) (asc)
+ => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last)
JOIN(6)(LEFT_OUTER)
=> Join Cond: (default.nation.n_regionkey (INT4) = default.region.r_regionkey (INT4) AND default.region.r_name (TEXT) IN (AMERICA, ASIA))
=> target list: default.nation.n_name (TEXT), default.nation.n_regionkey (INT4), default.region.r_name (TEXT), default.region.r_regionkey (INT4)
@@ -95,7 +95,7 @@ Block Id: eb_0000000000000_0000_000004 [ROOT]
0: sorted input=eb_0000000000000_0000_000003
SORT(3)
- => Sort Keys: default.region.r_name (TEXT) (asc),default.nation.n_name (TEXT) (asc)
+ => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last)
SCAN(11) on eb_0000000000000_0000_000003
=> out schema: {(4) default.nation.n_name (TEXT), default.nation.n_regionkey (INT4), default.region.r_name (TEXT), default.region.r_regionkey (INT4)}
=> in schema: {(4) default.nation.n_name (TEXT), default.nation.n_regionkey (INT4), default.region.r_name (TEXT), default.region.r_regionkey (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testJoinFilterOfRowPreservedTable1.Sort.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testJoinFilterOfRowPreservedTable1.Sort.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testJoinFilterOfRowPreservedTable1.Sort.plan
index e9d4ea7..dd6c95d 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testJoinFilterOfRowPreservedTable1.Sort.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testJoinFilterOfRowPreservedTable1.Sort.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(3)
- => Sort Keys: default.region.r_name (TEXT) (asc),default.nation.n_name (TEXT) (asc)
+ => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last)
JOIN(6)(LEFT_OUTER)
=> Join Cond: (default.nation.n_regionkey (INT4) = default.region.r_regionkey (INT4) AND default.region.r_name (TEXT) IN (AMERICA, ASIA))
=> target list: default.nation.n_name (TEXT), default.nation.n_regionkey (INT4), default.region.r_name (TEXT), default.region.r_regionkey (INT4)
@@ -42,7 +42,7 @@ Block Id: eb_0000000000000_0000_000003 [LEAF]
0: type=Broadcast, tables=default.nation
SORT(10)
- => Sort Keys: default.region.r_name (TEXT) (asc),default.nation.n_name (TEXT) (asc)
+ => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last)
JOIN(6)(LEFT_OUTER)
=> Join Cond: (default.nation.n_regionkey (INT4) = default.region.r_regionkey (INT4) AND default.region.r_name (TEXT) IN (AMERICA, ASIA))
=> target list: default.nation.n_name (TEXT), default.nation.n_regionkey (INT4), default.region.r_name (TEXT), default.region.r_regionkey (INT4)
@@ -68,7 +68,7 @@ Block Id: eb_0000000000000_0000_000004 [ROOT]
0: sorted input=eb_0000000000000_0000_000003
SORT(3)
- => Sort Keys: default.region.r_name (TEXT) (asc),default.nation.n_name (TEXT) (asc)
+ => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last)
SCAN(11) on eb_0000000000000_0000_000003
=> out schema: {(4) default.nation.n_name (TEXT), default.nation.n_regionkey (INT4), default.region.r_name (TEXT), default.region.r_regionkey (INT4)}
=> in schema: {(4) default.nation.n_name (TEXT), default.nation.n_regionkey (INT4), default.region.r_name (TEXT), default.region.r_regionkey (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testJoinFilterOfRowPreservedTable1.Sort_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testJoinFilterOfRowPreservedTable1.Sort_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testJoinFilterOfRowPreservedTable1.Sort_NoBroadcast.plan
index 7a0bf29..85ad736 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testJoinFilterOfRowPreservedTable1.Sort_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testJoinFilterOfRowPreservedTable1.Sort_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(3)
- => Sort Keys: default.region.r_name (TEXT) (asc),default.nation.n_name (TEXT) (asc)
+ => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last)
JOIN(6)(LEFT_OUTER)
=> Join Cond: (default.nation.n_regionkey (INT4) = default.region.r_regionkey (INT4) AND default.region.r_name (TEXT) IN (AMERICA, ASIA))
=> target list: default.nation.n_name (TEXT), default.nation.n_regionkey (INT4), default.region.r_name (TEXT), default.region.r_regionkey (INT4)
@@ -71,7 +71,7 @@ Block Id: eb_0000000000000_0000_000003 [INTERMEDIATE]
[q_0000000000000_0000] 3 => 4 (type=RANGE_SHUFFLE, key=default.nation.n_name (TEXT), default.region.r_name (TEXT), num=32)
SORT(10)
- => Sort Keys: default.region.r_name (TEXT) (asc),default.nation.n_name (TEXT) (asc)
+ => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last)
JOIN(6)(LEFT_OUTER)
=> Join Cond: (default.nation.n_regionkey (INT4) = default.region.r_regionkey (INT4) AND default.region.r_name (TEXT) IN (AMERICA, ASIA))
=> target list: default.nation.n_name (TEXT), default.nation.n_regionkey (INT4), default.region.r_name (TEXT), default.region.r_regionkey (INT4)
@@ -95,7 +95,7 @@ Block Id: eb_0000000000000_0000_000004 [ROOT]
0: sorted input=eb_0000000000000_0000_000003
SORT(3)
- => Sort Keys: default.region.r_name (TEXT) (asc),default.nation.n_name (TEXT) (asc)
+ => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last)
SCAN(11) on eb_0000000000000_0000_000003
=> out schema: {(4) default.nation.n_name (TEXT), default.nation.n_regionkey (INT4), default.region.r_name (TEXT), default.region.r_regionkey (INT4)}
=> in schema: {(4) default.nation.n_name (TEXT), default.nation.n_regionkey (INT4), default.region.r_name (TEXT), default.region.r_regionkey (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoin1.Hash.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoin1.Hash.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoin1.Hash.plan
index ae40796..0c6e74c 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoin1.Hash.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoin1.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)(LEFT_OUTER)
=> Join Cond: default.customer.c_custkey (INT4) = default.orders.o_orderkey (INT4)
=> target list: default.customer.c_custkey (INT4), default.orders.o_orderdate (TEXT), default.orders.o_orderkey (INT4), default.orders.o_orderstatus (TEXT)
@@ -42,7 +42,7 @@ Block Id: eb_0000000000000_0000_000003 [LEAF]
0: type=Broadcast, tables=default.orders
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)(LEFT_OUTER)
=> Join Cond: default.customer.c_custkey (INT4) = default.orders.o_orderkey (INT4)
=> target list: default.customer.c_custkey (INT4), default.orders.o_orderdate (TEXT), default.orders.o_orderkey (INT4), default.orders.o_orderstatus (TEXT)
@@ -68,7 +68,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: {(4) default.customer.c_custkey (INT4), default.orders.o_orderdate (TEXT), default.orders.o_orderkey (INT4), default.orders.o_orderstatus (TEXT)}
=> in schema: {(4) default.customer.c_custkey (INT4), default.orders.o_orderdate (TEXT), default.orders.o_orderkey (INT4), default.orders.o_orderstatus (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoin1.Hash_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoin1.Hash_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoin1.Hash_NoBroadcast.plan
index 89c262b..68050ca 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoin1.Hash_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoin1.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)(LEFT_OUTER)
=> Join Cond: default.customer.c_custkey (INT4) = default.orders.o_orderkey (INT4)
=> target list: default.customer.c_custkey (INT4), default.orders.o_orderdate (TEXT), default.orders.o_orderkey (INT4), default.orders.o_orderstatus (TEXT)
@@ -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)(LEFT_OUTER)
=> Join Cond: default.customer.c_custkey (INT4) = default.orders.o_orderkey (INT4)
=> target list: default.customer.c_custkey (INT4), default.orders.o_orderdate (TEXT), default.orders.o_orderkey (INT4), default.orders.o_orderstatus (TEXT)
@@ -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: {(4) default.customer.c_custkey (INT4), default.orders.o_orderdate (TEXT), default.orders.o_orderkey (INT4), default.orders.o_orderstatus (TEXT)}
=> in schema: {(4) default.customer.c_custkey (INT4), default.orders.o_orderdate (TEXT), default.orders.o_orderkey (INT4), default.orders.o_orderstatus (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoin1.Sort.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoin1.Sort.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoin1.Sort.plan
index ae40796..0c6e74c 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoin1.Sort.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoin1.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)(LEFT_OUTER)
=> Join Cond: default.customer.c_custkey (INT4) = default.orders.o_orderkey (INT4)
=> target list: default.customer.c_custkey (INT4), default.orders.o_orderdate (TEXT), default.orders.o_orderkey (INT4), default.orders.o_orderstatus (TEXT)
@@ -42,7 +42,7 @@ Block Id: eb_0000000000000_0000_000003 [LEAF]
0: type=Broadcast, tables=default.orders
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)(LEFT_OUTER)
=> Join Cond: default.customer.c_custkey (INT4) = default.orders.o_orderkey (INT4)
=> target list: default.customer.c_custkey (INT4), default.orders.o_orderdate (TEXT), default.orders.o_orderkey (INT4), default.orders.o_orderstatus (TEXT)
@@ -68,7 +68,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: {(4) default.customer.c_custkey (INT4), default.orders.o_orderdate (TEXT), default.orders.o_orderkey (INT4), default.orders.o_orderstatus (TEXT)}
=> in schema: {(4) default.customer.c_custkey (INT4), default.orders.o_orderdate (TEXT), default.orders.o_orderkey (INT4), default.orders.o_orderstatus (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoin1.Sort_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoin1.Sort_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoin1.Sort_NoBroadcast.plan
index 89c262b..68050ca 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoin1.Sort_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoin1.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)(LEFT_OUTER)
=> Join Cond: default.customer.c_custkey (INT4) = default.orders.o_orderkey (INT4)
=> target list: default.customer.c_custkey (INT4), default.orders.o_orderdate (TEXT), default.orders.o_orderkey (INT4), default.orders.o_orderstatus (TEXT)
@@ -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)(LEFT_OUTER)
=> Join Cond: default.customer.c_custkey (INT4) = default.orders.o_orderkey (INT4)
=> target list: default.customer.c_custkey (INT4), default.orders.o_orderdate (TEXT), default.orders.o_orderkey (INT4), default.orders.o_orderstatus (TEXT)
@@ -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: {(4) default.customer.c_custkey (INT4), default.orders.o_orderdate (TEXT), default.orders.o_orderkey (INT4), default.orders.o_orderstatus (TEXT)}
=> in schema: {(4) default.customer.c_custkey (INT4), default.orders.o_orderdate (TEXT), default.orders.o_orderkey (INT4), default.orders.o_orderstatus (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinLeftSideSmallTable.1.Hash.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinLeftSideSmallTable.1.Hash.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinLeftSideSmallTable.1.Hash.plan
index 0f5e52f..9090000 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinLeftSideSmallTable.1.Hash.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinLeftSideSmallTable.1.Hash.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(3)
- => Sort Keys: default.a.id (INT4) (asc)
+ => Sort Keys: default.a.id (INT4) (asc, nulls last)
JOIN(6)(LEFT_OUTER)
=> Join Cond: default.a.id (INT4) = default.b.id (INT4)
=> target list: default.a.id (INT4), default.b.name (TEXT)
@@ -71,7 +71,7 @@ Block Id: eb_0000000000000_0000_000003 [INTERMEDIATE]
[q_0000000000000_0000] 3 => 4 (type=RANGE_SHUFFLE, key=default.a.id (INT4), num=32)
SORT(10)
- => Sort Keys: default.a.id (INT4) (asc)
+ => Sort Keys: default.a.id (INT4) (asc, nulls last)
JOIN(6)(LEFT_OUTER)
=> Join Cond: default.a.id (INT4) = default.b.id (INT4)
=> target list: default.a.id (INT4), default.b.name (TEXT)
@@ -95,7 +95,7 @@ Block Id: eb_0000000000000_0000_000004 [ROOT]
0: sorted input=eb_0000000000000_0000_000003
SORT(3)
- => Sort Keys: default.a.id (INT4) (asc)
+ => Sort Keys: default.a.id (INT4) (asc, nulls last)
SCAN(11) on eb_0000000000000_0000_000003
=> out schema: {(2) default.a.id (INT4), default.b.name (TEXT)}
=> in schema: {(2) default.a.id (INT4), default.b.name (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinLeftSideSmallTable.1.Hash_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinLeftSideSmallTable.1.Hash_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinLeftSideSmallTable.1.Hash_NoBroadcast.plan
index 0f5e52f..9090000 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinLeftSideSmallTable.1.Hash_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinLeftSideSmallTable.1.Hash_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(3)
- => Sort Keys: default.a.id (INT4) (asc)
+ => Sort Keys: default.a.id (INT4) (asc, nulls last)
JOIN(6)(LEFT_OUTER)
=> Join Cond: default.a.id (INT4) = default.b.id (INT4)
=> target list: default.a.id (INT4), default.b.name (TEXT)
@@ -71,7 +71,7 @@ Block Id: eb_0000000000000_0000_000003 [INTERMEDIATE]
[q_0000000000000_0000] 3 => 4 (type=RANGE_SHUFFLE, key=default.a.id (INT4), num=32)
SORT(10)
- => Sort Keys: default.a.id (INT4) (asc)
+ => Sort Keys: default.a.id (INT4) (asc, nulls last)
JOIN(6)(LEFT_OUTER)
=> Join Cond: default.a.id (INT4) = default.b.id (INT4)
=> target list: default.a.id (INT4), default.b.name (TEXT)
@@ -95,7 +95,7 @@ Block Id: eb_0000000000000_0000_000004 [ROOT]
0: sorted input=eb_0000000000000_0000_000003
SORT(3)
- => Sort Keys: default.a.id (INT4) (asc)
+ => Sort Keys: default.a.id (INT4) (asc, nulls last)
SCAN(11) on eb_0000000000000_0000_000003
=> out schema: {(2) default.a.id (INT4), default.b.name (TEXT)}
=> in schema: {(2) default.a.id (INT4), default.b.name (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinLeftSideSmallTable.1.Sort.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinLeftSideSmallTable.1.Sort.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinLeftSideSmallTable.1.Sort.plan
index 0f5e52f..9090000 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinLeftSideSmallTable.1.Sort.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinLeftSideSmallTable.1.Sort.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(3)
- => Sort Keys: default.a.id (INT4) (asc)
+ => Sort Keys: default.a.id (INT4) (asc, nulls last)
JOIN(6)(LEFT_OUTER)
=> Join Cond: default.a.id (INT4) = default.b.id (INT4)
=> target list: default.a.id (INT4), default.b.name (TEXT)
@@ -71,7 +71,7 @@ Block Id: eb_0000000000000_0000_000003 [INTERMEDIATE]
[q_0000000000000_0000] 3 => 4 (type=RANGE_SHUFFLE, key=default.a.id (INT4), num=32)
SORT(10)
- => Sort Keys: default.a.id (INT4) (asc)
+ => Sort Keys: default.a.id (INT4) (asc, nulls last)
JOIN(6)(LEFT_OUTER)
=> Join Cond: default.a.id (INT4) = default.b.id (INT4)
=> target list: default.a.id (INT4), default.b.name (TEXT)
@@ -95,7 +95,7 @@ Block Id: eb_0000000000000_0000_000004 [ROOT]
0: sorted input=eb_0000000000000_0000_000003
SORT(3)
- => Sort Keys: default.a.id (INT4) (asc)
+ => Sort Keys: default.a.id (INT4) (asc, nulls last)
SCAN(11) on eb_0000000000000_0000_000003
=> out schema: {(2) default.a.id (INT4), default.b.name (TEXT)}
=> in schema: {(2) default.a.id (INT4), default.b.name (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinLeftSideSmallTable.1.Sort_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinLeftSideSmallTable.1.Sort_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinLeftSideSmallTable.1.Sort_NoBroadcast.plan
index 0f5e52f..9090000 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinLeftSideSmallTable.1.Sort_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinLeftSideSmallTable.1.Sort_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(3)
- => Sort Keys: default.a.id (INT4) (asc)
+ => Sort Keys: default.a.id (INT4) (asc, nulls last)
JOIN(6)(LEFT_OUTER)
=> Join Cond: default.a.id (INT4) = default.b.id (INT4)
=> target list: default.a.id (INT4), default.b.name (TEXT)
@@ -71,7 +71,7 @@ Block Id: eb_0000000000000_0000_000003 [INTERMEDIATE]
[q_0000000000000_0000] 3 => 4 (type=RANGE_SHUFFLE, key=default.a.id (INT4), num=32)
SORT(10)
- => Sort Keys: default.a.id (INT4) (asc)
+ => Sort Keys: default.a.id (INT4) (asc, nulls last)
JOIN(6)(LEFT_OUTER)
=> Join Cond: default.a.id (INT4) = default.b.id (INT4)
=> target list: default.a.id (INT4), default.b.name (TEXT)
@@ -95,7 +95,7 @@ Block Id: eb_0000000000000_0000_000004 [ROOT]
0: sorted input=eb_0000000000000_0000_000003
SORT(3)
- => Sort Keys: default.a.id (INT4) (asc)
+ => Sort Keys: default.a.id (INT4) (asc, nulls last)
SCAN(11) on eb_0000000000000_0000_000003
=> out schema: {(2) default.a.id (INT4), default.b.name (TEXT)}
=> in schema: {(2) default.a.id (INT4), default.b.name (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithConstantExpr1.Hash.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithConstantExpr1.Hash.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithConstantExpr1.Hash.plan
index 9ce925e..fbfe7f8 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithConstantExpr1.Hash.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithConstantExpr1.Hash.plan
@@ -5,7 +5,7 @@ PROJECTION(4)
=> out schema: {(3) default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4), val (TEXT)}
=> in schema: {(2) default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4)}
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)(LEFT_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)
@@ -46,7 +46,7 @@ Block Id: eb_0000000000000_0000_000003 [LEAF]
0: type=Broadcast, tables=default.orders
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)(LEFT_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)
@@ -76,7 +76,7 @@ PROJECTION(4)
=> out schema: {(3) default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4), val (TEXT)}
=> in schema: {(2) default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4)}
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/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithConstantExpr1.Hash_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithConstantExpr1.Hash_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithConstantExpr1.Hash_NoBroadcast.plan
index 4ddcf30..93ee8ba 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithConstantExpr1.Hash_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithConstantExpr1.Hash_NoBroadcast.plan
@@ -5,7 +5,7 @@ PROJECTION(4)
=> out schema: {(3) default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4), val (TEXT)}
=> in schema: {(2) default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4)}
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)(LEFT_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)
@@ -75,7 +75,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)(LEFT_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)
@@ -103,7 +103,7 @@ PROJECTION(4)
=> out schema: {(3) default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4), val (TEXT)}
=> in schema: {(2) default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4)}
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/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithConstantExpr1.Sort.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithConstantExpr1.Sort.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithConstantExpr1.Sort.plan
index 9ce925e..fbfe7f8 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithConstantExpr1.Sort.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithConstantExpr1.Sort.plan
@@ -5,7 +5,7 @@ PROJECTION(4)
=> out schema: {(3) default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4), val (TEXT)}
=> in schema: {(2) default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4)}
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)(LEFT_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)
@@ -46,7 +46,7 @@ Block Id: eb_0000000000000_0000_000003 [LEAF]
0: type=Broadcast, tables=default.orders
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)(LEFT_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)
@@ -76,7 +76,7 @@ PROJECTION(4)
=> out schema: {(3) default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4), val (TEXT)}
=> in schema: {(2) default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4)}
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/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithConstantExpr1.Sort_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithConstantExpr1.Sort_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithConstantExpr1.Sort_NoBroadcast.plan
index 4ddcf30..93ee8ba 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithConstantExpr1.Sort_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithConstantExpr1.Sort_NoBroadcast.plan
@@ -5,7 +5,7 @@ PROJECTION(4)
=> out schema: {(3) default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4), val (TEXT)}
=> in schema: {(2) default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4)}
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)(LEFT_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)
@@ -75,7 +75,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)(LEFT_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)
@@ -103,7 +103,7 @@ PROJECTION(4)
=> out schema: {(3) default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4), val (TEXT)}
=> in schema: {(2) default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4)}
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/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable1.Hash.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable1.Hash.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable1.Hash.plan
index 8861bab..3a14030 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable1.Hash.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable1.Hash.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(3)
- => Sort Keys: default.customer.c_custkey (INT4) (asc),default.empty_orders.o_orderkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.empty_orders.o_orderkey (INT4) (asc, nulls last)
JOIN(6)(LEFT_OUTER)
=> Join Cond: default.customer.c_custkey (INT4) = default.empty_orders.o_orderkey (INT4)
=> target list: default.customer.c_custkey (INT4), default.empty_orders.o_orderdate (TEXT), default.empty_orders.o_orderkey (INT4), default.empty_orders.o_orderstatus (TEXT)
@@ -42,7 +42,7 @@ Block Id: eb_0000000000000_0000_000003 [LEAF]
0: type=Broadcast, tables=default.empty_orders
SORT(10)
- => Sort Keys: default.customer.c_custkey (INT4) (asc),default.empty_orders.o_orderkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.empty_orders.o_orderkey (INT4) (asc, nulls last)
JOIN(6)(LEFT_OUTER)
=> Join Cond: default.customer.c_custkey (INT4) = default.empty_orders.o_orderkey (INT4)
=> target list: default.customer.c_custkey (INT4), default.empty_orders.o_orderdate (TEXT), default.empty_orders.o_orderkey (INT4), default.empty_orders.o_orderstatus (TEXT)
@@ -68,7 +68,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.empty_orders.o_orderkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.empty_orders.o_orderkey (INT4) (asc, nulls last)
SCAN(11) on eb_0000000000000_0000_000003
=> out schema: {(4) default.customer.c_custkey (INT4), default.empty_orders.o_orderdate (TEXT), default.empty_orders.o_orderkey (INT4), default.empty_orders.o_orderstatus (TEXT)}
=> in schema: {(4) default.customer.c_custkey (INT4), default.empty_orders.o_orderdate (TEXT), default.empty_orders.o_orderkey (INT4), default.empty_orders.o_orderstatus (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable1.Hash_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable1.Hash_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable1.Hash_NoBroadcast.plan
index 9bf9a3e..1f9575b 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable1.Hash_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable1.Hash_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(3)
- => Sort Keys: default.customer.c_custkey (INT4) (asc),default.empty_orders.o_orderkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.empty_orders.o_orderkey (INT4) (asc, nulls last)
JOIN(6)(LEFT_OUTER)
=> Join Cond: default.customer.c_custkey (INT4) = default.empty_orders.o_orderkey (INT4)
=> target list: default.customer.c_custkey (INT4), default.empty_orders.o_orderdate (TEXT), default.empty_orders.o_orderkey (INT4), default.empty_orders.o_orderstatus (TEXT)
@@ -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.empty_orders.o_orderkey (INT4), num=32)
SORT(10)
- => Sort Keys: default.customer.c_custkey (INT4) (asc),default.empty_orders.o_orderkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.empty_orders.o_orderkey (INT4) (asc, nulls last)
JOIN(6)(LEFT_OUTER)
=> Join Cond: default.customer.c_custkey (INT4) = default.empty_orders.o_orderkey (INT4)
=> target list: default.customer.c_custkey (INT4), default.empty_orders.o_orderdate (TEXT), default.empty_orders.o_orderkey (INT4), default.empty_orders.o_orderstatus (TEXT)
@@ -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.empty_orders.o_orderkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.empty_orders.o_orderkey (INT4) (asc, nulls last)
SCAN(11) on eb_0000000000000_0000_000003
=> out schema: {(4) default.customer.c_custkey (INT4), default.empty_orders.o_orderdate (TEXT), default.empty_orders.o_orderkey (INT4), default.empty_orders.o_orderstatus (TEXT)}
=> in schema: {(4) default.customer.c_custkey (INT4), default.empty_orders.o_orderdate (TEXT), default.empty_orders.o_orderkey (INT4), default.empty_orders.o_orderstatus (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable1.Sort.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable1.Sort.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable1.Sort.plan
index 8861bab..3a14030 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable1.Sort.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable1.Sort.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(3)
- => Sort Keys: default.customer.c_custkey (INT4) (asc),default.empty_orders.o_orderkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.empty_orders.o_orderkey (INT4) (asc, nulls last)
JOIN(6)(LEFT_OUTER)
=> Join Cond: default.customer.c_custkey (INT4) = default.empty_orders.o_orderkey (INT4)
=> target list: default.customer.c_custkey (INT4), default.empty_orders.o_orderdate (TEXT), default.empty_orders.o_orderkey (INT4), default.empty_orders.o_orderstatus (TEXT)
@@ -42,7 +42,7 @@ Block Id: eb_0000000000000_0000_000003 [LEAF]
0: type=Broadcast, tables=default.empty_orders
SORT(10)
- => Sort Keys: default.customer.c_custkey (INT4) (asc),default.empty_orders.o_orderkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.empty_orders.o_orderkey (INT4) (asc, nulls last)
JOIN(6)(LEFT_OUTER)
=> Join Cond: default.customer.c_custkey (INT4) = default.empty_orders.o_orderkey (INT4)
=> target list: default.customer.c_custkey (INT4), default.empty_orders.o_orderdate (TEXT), default.empty_orders.o_orderkey (INT4), default.empty_orders.o_orderstatus (TEXT)
@@ -68,7 +68,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.empty_orders.o_orderkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.empty_orders.o_orderkey (INT4) (asc, nulls last)
SCAN(11) on eb_0000000000000_0000_000003
=> out schema: {(4) default.customer.c_custkey (INT4), default.empty_orders.o_orderdate (TEXT), default.empty_orders.o_orderkey (INT4), default.empty_orders.o_orderstatus (TEXT)}
=> in schema: {(4) default.customer.c_custkey (INT4), default.empty_orders.o_orderdate (TEXT), default.empty_orders.o_orderkey (INT4), default.empty_orders.o_orderstatus (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable1.Sort_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable1.Sort_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable1.Sort_NoBroadcast.plan
index 9bf9a3e..1f9575b 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable1.Sort_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable1.Sort_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(3)
- => Sort Keys: default.customer.c_custkey (INT4) (asc),default.empty_orders.o_orderkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.empty_orders.o_orderkey (INT4) (asc, nulls last)
JOIN(6)(LEFT_OUTER)
=> Join Cond: default.customer.c_custkey (INT4) = default.empty_orders.o_orderkey (INT4)
=> target list: default.customer.c_custkey (INT4), default.empty_orders.o_orderdate (TEXT), default.empty_orders.o_orderkey (INT4), default.empty_orders.o_orderstatus (TEXT)
@@ -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.empty_orders.o_orderkey (INT4), num=32)
SORT(10)
- => Sort Keys: default.customer.c_custkey (INT4) (asc),default.empty_orders.o_orderkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.empty_orders.o_orderkey (INT4) (asc, nulls last)
JOIN(6)(LEFT_OUTER)
=> Join Cond: default.customer.c_custkey (INT4) = default.empty_orders.o_orderkey (INT4)
=> target list: default.customer.c_custkey (INT4), default.empty_orders.o_orderdate (TEXT), default.empty_orders.o_orderkey (INT4), default.empty_orders.o_orderstatus (TEXT)
@@ -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.empty_orders.o_orderkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.empty_orders.o_orderkey (INT4) (asc, nulls last)
SCAN(11) on eb_0000000000000_0000_000003
=> out schema: {(4) default.customer.c_custkey (INT4), default.empty_orders.o_orderdate (TEXT), default.empty_orders.o_orderkey (INT4), default.empty_orders.o_orderstatus (TEXT)}
=> in schema: {(4) default.customer.c_custkey (INT4), default.empty_orders.o_orderdate (TEXT), default.empty_orders.o_orderkey (INT4), default.empty_orders.o_orderstatus (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable2.Hash.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable2.Hash.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable2.Hash.plan
index 1fa968f..abf76d6 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable2.Hash.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable2.Hash.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(4)
- => Sort Keys: default.customer.c_custkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last)
GROUP_BY(3)(c_custkey)
=> exprs: (sum(default.empty_orders.o_orderkey (INT4)),max(default.empty_orders.o_orderstatus (TEXT)),max(default.empty_orders.o_orderdate (TEXT)))
=> target list: default.customer.c_custkey (INT4), ?sum (INT8), ?max_1 (TEXT), ?max_2 (TEXT)
@@ -78,7 +78,7 @@ Block Id: eb_0000000000000_0000_000004 [INTERMEDIATE]
[q_0000000000000_0000] 4 => 5 (type=RANGE_SHUFFLE, key=default.customer.c_custkey (INT4), num=32)
SORT(13)
- => Sort Keys: default.customer.c_custkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last)
GROUP_BY(3)(c_custkey)
=> exprs: (sum(?sum_5 (INT8)),max(?max_6 (TEXT)),max(?max_7 (TEXT)))
=> target list: default.customer.c_custkey (INT4), ?sum (INT8), ?max_1 (TEXT), ?max_2 (TEXT)
@@ -99,7 +99,7 @@ Block Id: eb_0000000000000_0000_000005 [ROOT]
0: sorted input=eb_0000000000000_0000_000004
SORT(4)
- => Sort Keys: default.customer.c_custkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last)
SCAN(14) on eb_0000000000000_0000_000004
=> out schema: {(4) ?max_1 (TEXT), ?max_2 (TEXT), ?sum (INT8), default.customer.c_custkey (INT4)}
=> in schema: {(4) ?max_1 (TEXT), ?max_2 (TEXT), ?sum (INT8), default.customer.c_custkey (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable2.Hash_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable2.Hash_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable2.Hash_NoBroadcast.plan
index fd2e0d0..dd151b2 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable2.Hash_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable2.Hash_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(4)
- => Sort Keys: default.customer.c_custkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last)
GROUP_BY(3)(c_custkey)
=> exprs: (sum(default.empty_orders.o_orderkey (INT4)),max(default.empty_orders.o_orderstatus (TEXT)),max(default.empty_orders.o_orderdate (TEXT)))
=> target list: default.customer.c_custkey (INT4), ?sum (INT8), ?max_1 (TEXT), ?max_2 (TEXT)
@@ -105,7 +105,7 @@ Block Id: eb_0000000000000_0000_000004 [INTERMEDIATE]
[q_0000000000000_0000] 4 => 5 (type=RANGE_SHUFFLE, key=default.customer.c_custkey (INT4), num=32)
SORT(13)
- => Sort Keys: default.customer.c_custkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last)
GROUP_BY(3)(c_custkey)
=> exprs: (sum(?sum_5 (INT8)),max(?max_6 (TEXT)),max(?max_7 (TEXT)))
=> target list: default.customer.c_custkey (INT4), ?sum (INT8), ?max_1 (TEXT), ?max_2 (TEXT)
@@ -126,7 +126,7 @@ Block Id: eb_0000000000000_0000_000005 [ROOT]
0: sorted input=eb_0000000000000_0000_000004
SORT(4)
- => Sort Keys: default.customer.c_custkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last)
SCAN(14) on eb_0000000000000_0000_000004
=> out schema: {(4) ?max_1 (TEXT), ?max_2 (TEXT), ?sum (INT8), default.customer.c_custkey (INT4)}
=> in schema: {(4) ?max_1 (TEXT), ?max_2 (TEXT), ?sum (INT8), default.customer.c_custkey (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable2.Sort.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable2.Sort.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable2.Sort.plan
index 1fa968f..abf76d6 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable2.Sort.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable2.Sort.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(4)
- => Sort Keys: default.customer.c_custkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last)
GROUP_BY(3)(c_custkey)
=> exprs: (sum(default.empty_orders.o_orderkey (INT4)),max(default.empty_orders.o_orderstatus (TEXT)),max(default.empty_orders.o_orderdate (TEXT)))
=> target list: default.customer.c_custkey (INT4), ?sum (INT8), ?max_1 (TEXT), ?max_2 (TEXT)
@@ -78,7 +78,7 @@ Block Id: eb_0000000000000_0000_000004 [INTERMEDIATE]
[q_0000000000000_0000] 4 => 5 (type=RANGE_SHUFFLE, key=default.customer.c_custkey (INT4), num=32)
SORT(13)
- => Sort Keys: default.customer.c_custkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last)
GROUP_BY(3)(c_custkey)
=> exprs: (sum(?sum_5 (INT8)),max(?max_6 (TEXT)),max(?max_7 (TEXT)))
=> target list: default.customer.c_custkey (INT4), ?sum (INT8), ?max_1 (TEXT), ?max_2 (TEXT)
@@ -99,7 +99,7 @@ Block Id: eb_0000000000000_0000_000005 [ROOT]
0: sorted input=eb_0000000000000_0000_000004
SORT(4)
- => Sort Keys: default.customer.c_custkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last)
SCAN(14) on eb_0000000000000_0000_000004
=> out schema: {(4) ?max_1 (TEXT), ?max_2 (TEXT), ?sum (INT8), default.customer.c_custkey (INT4)}
=> in schema: {(4) ?max_1 (TEXT), ?max_2 (TEXT), ?sum (INT8), default.customer.c_custkey (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable2.Sort_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable2.Sort_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable2.Sort_NoBroadcast.plan
index fd2e0d0..dd151b2 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable2.Sort_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable2.Sort_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(4)
- => Sort Keys: default.customer.c_custkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last)
GROUP_BY(3)(c_custkey)
=> exprs: (sum(default.empty_orders.o_orderkey (INT4)),max(default.empty_orders.o_orderstatus (TEXT)),max(default.empty_orders.o_orderdate (TEXT)))
=> target list: default.customer.c_custkey (INT4), ?sum (INT8), ?max_1 (TEXT), ?max_2 (TEXT)
@@ -105,7 +105,7 @@ Block Id: eb_0000000000000_0000_000004 [INTERMEDIATE]
[q_0000000000000_0000] 4 => 5 (type=RANGE_SHUFFLE, key=default.customer.c_custkey (INT4), num=32)
SORT(13)
- => Sort Keys: default.customer.c_custkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last)
GROUP_BY(3)(c_custkey)
=> exprs: (sum(?sum_5 (INT8)),max(?max_6 (TEXT)),max(?max_7 (TEXT)))
=> target list: default.customer.c_custkey (INT4), ?sum (INT8), ?max_1 (TEXT), ?max_2 (TEXT)
@@ -126,7 +126,7 @@ Block Id: eb_0000000000000_0000_000005 [ROOT]
0: sorted input=eb_0000000000000_0000_000004
SORT(4)
- => Sort Keys: default.customer.c_custkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last)
SCAN(14) on eb_0000000000000_0000_000004
=> out schema: {(4) ?max_1 (TEXT), ?max_2 (TEXT), ?sum (INT8), default.customer.c_custkey (INT4)}
=> in schema: {(4) ?max_1 (TEXT), ?max_2 (TEXT), ?sum (INT8), default.customer.c_custkey (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable3.Hash.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable3.Hash.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable3.Hash.plan
index 6640d69..65bce10 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable3.Hash.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable3.Hash.plan
@@ -5,7 +5,7 @@ PROJECTION(8)
=> out schema: {(1) ?count (INT8)}
=> in schema: {(2) ?count (INT8), default.t1.c_custkey (INT4)}
SORT(7)
- => Sort Keys: default.t1.c_custkey (INT4) (asc)
+ => Sort Keys: default.t1.c_custkey (INT4) (asc, nulls last)
GROUP_BY(6)(c_custkey)
=> exprs: (count())
=> target list: default.t1.c_custkey (INT4), ?count (INT8)
@@ -125,7 +125,7 @@ Block Id: eb_0000000000000_0000_000005 [INTERMEDIATE]
[q_0000000000000_0000] 5 => 6 (type=RANGE_SHUFFLE, key=default.t1.c_custkey (INT4), num=32)
SORT(18)
- => Sort Keys: default.t1.c_custkey (INT4) (asc)
+ => Sort Keys: default.t1.c_custkey (INT4) (asc, nulls last)
GROUP_BY(6)(c_custkey)
=> exprs: (count(?count_6 (INT8)))
=> target list: default.t1.c_custkey (INT4), ?count (INT8)
@@ -150,7 +150,7 @@ PROJECTION(8)
=> out schema: {(1) ?count (INT8)}
=> in schema: {(2) ?count (INT8), default.t1.c_custkey (INT4)}
SORT(7)
- => Sort Keys: default.t1.c_custkey (INT4) (asc)
+ => Sort Keys: default.t1.c_custkey (INT4) (asc, nulls last)
SCAN(19) on eb_0000000000000_0000_000005
=> out schema: {(2) ?count (INT8), default.t1.c_custkey (INT4)}
=> in schema: {(2) ?count (INT8), default.t1.c_custkey (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable3.Hash_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable3.Hash_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable3.Hash_NoBroadcast.plan
index ad48532..4c0e603 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable3.Hash_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable3.Hash_NoBroadcast.plan
@@ -5,7 +5,7 @@ PROJECTION(8)
=> out schema: {(1) ?count (INT8)}
=> in schema: {(2) ?count (INT8), default.t1.c_custkey (INT4)}
SORT(7)
- => Sort Keys: default.t1.c_custkey (INT4) (asc)
+ => Sort Keys: default.t1.c_custkey (INT4) (asc, nulls last)
GROUP_BY(6)(c_custkey)
=> exprs: (count())
=> target list: default.t1.c_custkey (INT4), ?count (INT8)
@@ -152,7 +152,7 @@ Block Id: eb_0000000000000_0000_000005 [INTERMEDIATE]
[q_0000000000000_0000] 5 => 6 (type=RANGE_SHUFFLE, key=default.t1.c_custkey (INT4), num=32)
SORT(18)
- => Sort Keys: default.t1.c_custkey (INT4) (asc)
+ => Sort Keys: default.t1.c_custkey (INT4) (asc, nulls last)
GROUP_BY(6)(c_custkey)
=> exprs: (count(?count_6 (INT8)))
=> target list: default.t1.c_custkey (INT4), ?count (INT8)
@@ -177,7 +177,7 @@ PROJECTION(8)
=> out schema: {(1) ?count (INT8)}
=> in schema: {(2) ?count (INT8), default.t1.c_custkey (INT4)}
SORT(7)
- => Sort Keys: default.t1.c_custkey (INT4) (asc)
+ => Sort Keys: default.t1.c_custkey (INT4) (asc, nulls last)
SCAN(19) on eb_0000000000000_0000_000005
=> out schema: {(2) ?count (INT8), default.t1.c_custkey (INT4)}
=> in schema: {(2) ?count (INT8), default.t1.c_custkey (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable3.Sort.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable3.Sort.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable3.Sort.plan
index 6640d69..65bce10 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable3.Sort.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable3.Sort.plan
@@ -5,7 +5,7 @@ PROJECTION(8)
=> out schema: {(1) ?count (INT8)}
=> in schema: {(2) ?count (INT8), default.t1.c_custkey (INT4)}
SORT(7)
- => Sort Keys: default.t1.c_custkey (INT4) (asc)
+ => Sort Keys: default.t1.c_custkey (INT4) (asc, nulls last)
GROUP_BY(6)(c_custkey)
=> exprs: (count())
=> target list: default.t1.c_custkey (INT4), ?count (INT8)
@@ -125,7 +125,7 @@ Block Id: eb_0000000000000_0000_000005 [INTERMEDIATE]
[q_0000000000000_0000] 5 => 6 (type=RANGE_SHUFFLE, key=default.t1.c_custkey (INT4), num=32)
SORT(18)
- => Sort Keys: default.t1.c_custkey (INT4) (asc)
+ => Sort Keys: default.t1.c_custkey (INT4) (asc, nulls last)
GROUP_BY(6)(c_custkey)
=> exprs: (count(?count_6 (INT8)))
=> target list: default.t1.c_custkey (INT4), ?count (INT8)
@@ -150,7 +150,7 @@ PROJECTION(8)
=> out schema: {(1) ?count (INT8)}
=> in schema: {(2) ?count (INT8), default.t1.c_custkey (INT4)}
SORT(7)
- => Sort Keys: default.t1.c_custkey (INT4) (asc)
+ => Sort Keys: default.t1.c_custkey (INT4) (asc, nulls last)
SCAN(19) on eb_0000000000000_0000_000005
=> out schema: {(2) ?count (INT8), default.t1.c_custkey (INT4)}
=> in schema: {(2) ?count (INT8), default.t1.c_custkey (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable3.Sort_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable3.Sort_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable3.Sort_NoBroadcast.plan
index ad48532..4c0e603 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable3.Sort_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable3.Sort_NoBroadcast.plan
@@ -5,7 +5,7 @@ PROJECTION(8)
=> out schema: {(1) ?count (INT8)}
=> in schema: {(2) ?count (INT8), default.t1.c_custkey (INT4)}
SORT(7)
- => Sort Keys: default.t1.c_custkey (INT4) (asc)
+ => Sort Keys: default.t1.c_custkey (INT4) (asc, nulls last)
GROUP_BY(6)(c_custkey)
=> exprs: (count())
=> target list: default.t1.c_custkey (INT4), ?count (INT8)
@@ -152,7 +152,7 @@ Block Id: eb_0000000000000_0000_000005 [INTERMEDIATE]
[q_0000000000000_0000] 5 => 6 (type=RANGE_SHUFFLE, key=default.t1.c_custkey (INT4), num=32)
SORT(18)
- => Sort Keys: default.t1.c_custkey (INT4) (asc)
+ => Sort Keys: default.t1.c_custkey (INT4) (asc, nulls last)
GROUP_BY(6)(c_custkey)
=> exprs: (count(?count_6 (INT8)))
=> target list: default.t1.c_custkey (INT4), ?count (INT8)
@@ -177,7 +177,7 @@ PROJECTION(8)
=> out schema: {(1) ?count (INT8)}
=> in schema: {(2) ?count (INT8), default.t1.c_custkey (INT4)}
SORT(7)
- => Sort Keys: default.t1.c_custkey (INT4) (asc)
+ => Sort Keys: default.t1.c_custkey (INT4) (asc, nulls last)
SCAN(19) on eb_0000000000000_0000_000005
=> out schema: {(2) ?count (INT8), default.t1.c_custkey (INT4)}
=> in schema: {(2) ?count (INT8), default.t1.c_custkey (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable5.Hash.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable5.Hash.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable5.Hash.plan
index a0476d1..359630f 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable5.Hash.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable5.Hash.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(4)
- => Sort Keys: default.lineitem.l_linenumber (INT4) (asc)
+ => Sort Keys: default.lineitem.l_linenumber (INT4) (asc, nulls last)
GROUP_BY(3)(l_linenumber)
=> exprs: (sum(default.empty_orders.o_orderkey (INT4)),max(default.empty_orders.o_orderstatus (TEXT)),max(default.empty_orders.o_orderdate (TEXT)),avg(default.lineitem.l_quantity (FLOAT8)),sum(default.lineitem.l_quantity (FLOAT8)))
=> target list: default.lineitem.l_linenumber (INT4), ?sum (INT8), ?max_1 (TEXT), ?max_2 (TEXT), ?avg_3 (FLOAT8), ?sum_4 (FLOAT8)
@@ -78,7 +78,7 @@ Block Id: eb_0000000000000_0000_000004 [INTERMEDIATE]
[q_0000000000000_0000] 4 => 5 (type=RANGE_SHUFFLE, key=default.lineitem.l_linenumber (INT4), num=32)
SORT(13)
- => Sort Keys: default.lineitem.l_linenumber (INT4) (asc)
+ => Sort Keys: default.lineitem.l_linenumber (INT4) (asc, nulls last)
GROUP_BY(3)(l_linenumber)
=> exprs: (sum(?sum_7 (INT8)),max(?max_8 (TEXT)),max(?max_9 (TEXT)),avg(?avg_10 (PROTOBUF)),sum(?sum_11 (FLOAT8)))
=> target list: default.lineitem.l_linenumber (INT4), ?sum (INT8), ?max_1 (TEXT), ?max_2 (TEXT), ?avg_3 (FLOAT8), ?sum_4 (FLOAT8)
@@ -99,7 +99,7 @@ Block Id: eb_0000000000000_0000_000005 [ROOT]
0: sorted input=eb_0000000000000_0000_000004
SORT(4)
- => Sort Keys: default.lineitem.l_linenumber (INT4) (asc)
+ => Sort Keys: default.lineitem.l_linenumber (INT4) (asc, nulls last)
SCAN(14) on eb_0000000000000_0000_000004
=> out schema: {(6) ?avg_3 (FLOAT8), ?max_1 (TEXT), ?max_2 (TEXT), ?sum (INT8), ?sum_4 (FLOAT8), default.lineitem.l_linenumber (INT4)}
=> in schema: {(6) ?avg_3 (FLOAT8), ?max_1 (TEXT), ?max_2 (TEXT), ?sum (INT8), ?sum_4 (FLOAT8), default.lineitem.l_linenumber (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable5.Hash_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable5.Hash_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable5.Hash_NoBroadcast.plan
index 99b7def..5e32a29 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable5.Hash_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable5.Hash_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(4)
- => Sort Keys: default.lineitem.l_linenumber (INT4) (asc)
+ => Sort Keys: default.lineitem.l_linenumber (INT4) (asc, nulls last)
GROUP_BY(3)(l_linenumber)
=> exprs: (sum(default.empty_orders.o_orderkey (INT4)),max(default.empty_orders.o_orderstatus (TEXT)),max(default.empty_orders.o_orderdate (TEXT)),avg(default.lineitem.l_quantity (FLOAT8)),sum(default.lineitem.l_quantity (FLOAT8)))
=> target list: default.lineitem.l_linenumber (INT4), ?sum (INT8), ?max_1 (TEXT), ?max_2 (TEXT), ?avg_3 (FLOAT8), ?sum_4 (FLOAT8)
@@ -105,7 +105,7 @@ Block Id: eb_0000000000000_0000_000004 [INTERMEDIATE]
[q_0000000000000_0000] 4 => 5 (type=RANGE_SHUFFLE, key=default.lineitem.l_linenumber (INT4), num=32)
SORT(13)
- => Sort Keys: default.lineitem.l_linenumber (INT4) (asc)
+ => Sort Keys: default.lineitem.l_linenumber (INT4) (asc, nulls last)
GROUP_BY(3)(l_linenumber)
=> exprs: (sum(?sum_7 (INT8)),max(?max_8 (TEXT)),max(?max_9 (TEXT)),avg(?avg_10 (PROTOBUF)),sum(?sum_11 (FLOAT8)))
=> target list: default.lineitem.l_linenumber (INT4), ?sum (INT8), ?max_1 (TEXT), ?max_2 (TEXT), ?avg_3 (FLOAT8), ?sum_4 (FLOAT8)
@@ -126,7 +126,7 @@ Block Id: eb_0000000000000_0000_000005 [ROOT]
0: sorted input=eb_0000000000000_0000_000004
SORT(4)
- => Sort Keys: default.lineitem.l_linenumber (INT4) (asc)
+ => Sort Keys: default.lineitem.l_linenumber (INT4) (asc, nulls last)
SCAN(14) on eb_0000000000000_0000_000004
=> out schema: {(6) ?avg_3 (FLOAT8), ?max_1 (TEXT), ?max_2 (TEXT), ?sum (INT8), ?sum_4 (FLOAT8), default.lineitem.l_linenumber (INT4)}
=> in schema: {(6) ?avg_3 (FLOAT8), ?max_1 (TEXT), ?max_2 (TEXT), ?sum (INT8), ?sum_4 (FLOAT8), default.lineitem.l_linenumber (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable5.Sort.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable5.Sort.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable5.Sort.plan
index a0476d1..359630f 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable5.Sort.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable5.Sort.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(4)
- => Sort Keys: default.lineitem.l_linenumber (INT4) (asc)
+ => Sort Keys: default.lineitem.l_linenumber (INT4) (asc, nulls last)
GROUP_BY(3)(l_linenumber)
=> exprs: (sum(default.empty_orders.o_orderkey (INT4)),max(default.empty_orders.o_orderstatus (TEXT)),max(default.empty_orders.o_orderdate (TEXT)),avg(default.lineitem.l_quantity (FLOAT8)),sum(default.lineitem.l_quantity (FLOAT8)))
=> target list: default.lineitem.l_linenumber (INT4), ?sum (INT8), ?max_1 (TEXT), ?max_2 (TEXT), ?avg_3 (FLOAT8), ?sum_4 (FLOAT8)
@@ -78,7 +78,7 @@ Block Id: eb_0000000000000_0000_000004 [INTERMEDIATE]
[q_0000000000000_0000] 4 => 5 (type=RANGE_SHUFFLE, key=default.lineitem.l_linenumber (INT4), num=32)
SORT(13)
- => Sort Keys: default.lineitem.l_linenumber (INT4) (asc)
+ => Sort Keys: default.lineitem.l_linenumber (INT4) (asc, nulls last)
GROUP_BY(3)(l_linenumber)
=> exprs: (sum(?sum_7 (INT8)),max(?max_8 (TEXT)),max(?max_9 (TEXT)),avg(?avg_10 (PROTOBUF)),sum(?sum_11 (FLOAT8)))
=> target list: default.lineitem.l_linenumber (INT4), ?sum (INT8), ?max_1 (TEXT), ?max_2 (TEXT), ?avg_3 (FLOAT8), ?sum_4 (FLOAT8)
@@ -99,7 +99,7 @@ Block Id: eb_0000000000000_0000_000005 [ROOT]
0: sorted input=eb_0000000000000_0000_000004
SORT(4)
- => Sort Keys: default.lineitem.l_linenumber (INT4) (asc)
+ => Sort Keys: default.lineitem.l_linenumber (INT4) (asc, nulls last)
SCAN(14) on eb_0000000000000_0000_000004
=> out schema: {(6) ?avg_3 (FLOAT8), ?max_1 (TEXT), ?max_2 (TEXT), ?sum (INT8), ?sum_4 (FLOAT8), default.lineitem.l_linenumber (INT4)}
=> in schema: {(6) ?avg_3 (FLOAT8), ?max_1 (TEXT), ?max_2 (TEXT), ?sum (INT8), ?sum_4 (FLOAT8), default.lineitem.l_linenumber (INT4)}