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:13:01 UTC
[6/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/TestInnerJoinQuery/testComplexJoinCondition2.Sort_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition2.Sort_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition2.Sort_NoBroadcast.plan
index 53b6430..a6b958f 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition2.Sort_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition2.Sort_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(3)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
JOIN(6)(INNER)
=> Join Cond: default.n1.n_name (TEXT) = name (TEXT)
=> target list: default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), name (TEXT)
@@ -71,7 +71,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(10)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
JOIN(6)(INNER)
=> Join Cond: default.n1.n_name (TEXT) = name (TEXT)
=> target list: default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), 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.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
SCAN(11) on eb_0000000000000_0000_000003
=> out schema: {(3) default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), name (TEXT)}
=> in schema: {(3) default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), name (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition3.Hash.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition3.Hash.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition3.Hash.plan
index 2f639c2..f1ad02d 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition3.Hash.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition3.Hash.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(3)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
JOIN(6)(INNER)
=> Join Cond: ?lower_1 (TEXT) = ?lower_2 (TEXT)
=> target list: default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_name (TEXT)
@@ -42,7 +42,7 @@ Block Id: eb_0000000000000_0000_000003 [LEAF]
0: type=Broadcast, tables=default.n1
SORT(10)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
JOIN(6)(INNER)
=> Join Cond: ?lower_1 (TEXT) = ?lower_2 (TEXT)
=> target list: default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_name (TEXT)
@@ -68,7 +68,7 @@ Block Id: eb_0000000000000_0000_000004 [ROOT]
0: sorted input=eb_0000000000000_0000_000003
SORT(3)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
SCAN(11) 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/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition3.Hash_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition3.Hash_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition3.Hash_NoBroadcast.plan
index 3f3e632..9978790 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition3.Hash_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition3.Hash_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(3)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
JOIN(6)(INNER)
=> Join Cond: ?lower_1 (TEXT) = ?lower_2 (TEXT)
=> target list: default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_name (TEXT)
@@ -71,7 +71,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(10)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
JOIN(6)(INNER)
=> Join Cond: ?lower_1 (TEXT) = ?lower_2 (TEXT)
=> target list: default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_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.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
SCAN(11) 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/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition3.Sort.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition3.Sort.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition3.Sort.plan
index 2f639c2..f1ad02d 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition3.Sort.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition3.Sort.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(3)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
JOIN(6)(INNER)
=> Join Cond: ?lower_1 (TEXT) = ?lower_2 (TEXT)
=> target list: default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_name (TEXT)
@@ -42,7 +42,7 @@ Block Id: eb_0000000000000_0000_000003 [LEAF]
0: type=Broadcast, tables=default.n1
SORT(10)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
JOIN(6)(INNER)
=> Join Cond: ?lower_1 (TEXT) = ?lower_2 (TEXT)
=> target list: default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_name (TEXT)
@@ -68,7 +68,7 @@ Block Id: eb_0000000000000_0000_000004 [ROOT]
0: sorted input=eb_0000000000000_0000_000003
SORT(3)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
SCAN(11) 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/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition3.Sort_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition3.Sort_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition3.Sort_NoBroadcast.plan
index 3f3e632..9978790 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition3.Sort_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition3.Sort_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(3)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
JOIN(6)(INNER)
=> Join Cond: ?lower_1 (TEXT) = ?lower_2 (TEXT)
=> target list: default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_name (TEXT)
@@ -71,7 +71,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(10)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
JOIN(6)(INNER)
=> Join Cond: ?lower_1 (TEXT) = ?lower_2 (TEXT)
=> target list: default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_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.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
SCAN(11) 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/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition4.Hash.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition4.Hash.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition4.Hash.plan
index 1d0e9ff..a8c117a 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition4.Hash.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition4.Hash.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(3)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
JOIN(6)(INNER)
=> Join Cond: name1 (TEXT) = name2 (TEXT)
=> target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)
@@ -42,7 +42,7 @@ Block Id: eb_0000000000000_0000_000003 [LEAF]
0: type=Broadcast, tables=default.n1
SORT(10)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
JOIN(6)(INNER)
=> Join Cond: name1 (TEXT) = name2 (TEXT)
=> target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)
@@ -68,7 +68,7 @@ Block Id: eb_0000000000000_0000_000004 [ROOT]
0: sorted input=eb_0000000000000_0000_000003
SORT(3)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
SCAN(11) 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/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition4.Hash_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition4.Hash_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition4.Hash_NoBroadcast.plan
index feec5d9..e2e72c7 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition4.Hash_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition4.Hash_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(3)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
JOIN(6)(INNER)
=> Join Cond: name1 (TEXT) = name2 (TEXT)
=> target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)
@@ -71,7 +71,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(10)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
JOIN(6)(INNER)
=> Join Cond: name1 (TEXT) = name2 (TEXT)
=> target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)
@@ -95,7 +95,7 @@ Block Id: eb_0000000000000_0000_000004 [ROOT]
0: sorted input=eb_0000000000000_0000_000003
SORT(3)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
SCAN(11) 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/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition4.Sort.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition4.Sort.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition4.Sort.plan
index 1d0e9ff..a8c117a 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition4.Sort.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition4.Sort.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(3)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
JOIN(6)(INNER)
=> Join Cond: name1 (TEXT) = name2 (TEXT)
=> target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)
@@ -42,7 +42,7 @@ Block Id: eb_0000000000000_0000_000003 [LEAF]
0: type=Broadcast, tables=default.n1
SORT(10)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
JOIN(6)(INNER)
=> Join Cond: name1 (TEXT) = name2 (TEXT)
=> target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)
@@ -68,7 +68,7 @@ Block Id: eb_0000000000000_0000_000004 [ROOT]
0: sorted input=eb_0000000000000_0000_000003
SORT(3)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
SCAN(11) 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/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition4.Sort_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition4.Sort_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition4.Sort_NoBroadcast.plan
index feec5d9..e2e72c7 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition4.Sort_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testComplexJoinCondition4.Sort_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(3)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
JOIN(6)(INNER)
=> Join Cond: name1 (TEXT) = name2 (TEXT)
=> target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)
@@ -71,7 +71,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(10)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
JOIN(6)(INNER)
=> Join Cond: name1 (TEXT) = name2 (TEXT)
=> target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)
@@ -95,7 +95,7 @@ Block Id: eb_0000000000000_0000_000004 [ROOT]
0: sorted input=eb_0000000000000_0000_000003
SORT(3)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
SCAN(11) 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/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testInnerJoinAndCaseWhen.Hash.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testInnerJoinAndCaseWhen.Hash.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testInnerJoinAndCaseWhen.Hash.plan
index de4fc4f..8015b51 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testInnerJoinAndCaseWhen.Hash.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testInnerJoinAndCaseWhen.Hash.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(3)
- => Sort Keys: default.region.r_regionkey (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: default.region.r_regionkey (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
JOIN(7)(INNER)
=> Join Cond: default.region.r_regionkey (INT4) = default.nation.n_regionkey (INT4)
=> target list: cond (TEXT), default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4)
@@ -42,7 +42,7 @@ Block Id: eb_0000000000000_0000_000003 [LEAF]
0: type=Broadcast, tables=default.region
SORT(11)
- => Sort Keys: default.region.r_regionkey (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: default.region.r_regionkey (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
JOIN(7)(INNER)
=> Join Cond: default.region.r_regionkey (INT4) = default.nation.n_regionkey (INT4)
=> target list: cond (TEXT), default.nation.n_regionkey (INT4), 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_regionkey (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: default.region.r_regionkey (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
SCAN(12) on eb_0000000000000_0000_000003
=> out schema: {(3) cond (TEXT), default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4)}
=> in schema: {(3) cond (TEXT), default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testInnerJoinAndCaseWhen.Hash_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testInnerJoinAndCaseWhen.Hash_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testInnerJoinAndCaseWhen.Hash_NoBroadcast.plan
index 6153908..40dfe18 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testInnerJoinAndCaseWhen.Hash_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testInnerJoinAndCaseWhen.Hash_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(3)
- => Sort Keys: default.region.r_regionkey (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: default.region.r_regionkey (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
JOIN(7)(INNER)
=> Join Cond: default.region.r_regionkey (INT4) = default.nation.n_regionkey (INT4)
=> target list: cond (TEXT), default.nation.n_regionkey (INT4), 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_regionkey (INT4), default.region.r_regionkey (INT4), num=32)
SORT(11)
- => Sort Keys: default.region.r_regionkey (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: default.region.r_regionkey (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
JOIN(7)(INNER)
=> Join Cond: default.region.r_regionkey (INT4) = default.nation.n_regionkey (INT4)
=> target list: cond (TEXT), default.nation.n_regionkey (INT4), 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_regionkey (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: default.region.r_regionkey (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
SCAN(12) on eb_0000000000000_0000_000003
=> out schema: {(3) cond (TEXT), default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4)}
=> in schema: {(3) cond (TEXT), default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testInnerJoinAndCaseWhen.Sort.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testInnerJoinAndCaseWhen.Sort.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testInnerJoinAndCaseWhen.Sort.plan
index de4fc4f..8015b51 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testInnerJoinAndCaseWhen.Sort.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testInnerJoinAndCaseWhen.Sort.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(3)
- => Sort Keys: default.region.r_regionkey (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: default.region.r_regionkey (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
JOIN(7)(INNER)
=> Join Cond: default.region.r_regionkey (INT4) = default.nation.n_regionkey (INT4)
=> target list: cond (TEXT), default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4)
@@ -42,7 +42,7 @@ Block Id: eb_0000000000000_0000_000003 [LEAF]
0: type=Broadcast, tables=default.region
SORT(11)
- => Sort Keys: default.region.r_regionkey (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: default.region.r_regionkey (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
JOIN(7)(INNER)
=> Join Cond: default.region.r_regionkey (INT4) = default.nation.n_regionkey (INT4)
=> target list: cond (TEXT), default.nation.n_regionkey (INT4), 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_regionkey (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: default.region.r_regionkey (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
SCAN(12) on eb_0000000000000_0000_000003
=> out schema: {(3) cond (TEXT), default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4)}
=> in schema: {(3) cond (TEXT), default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testInnerJoinAndCaseWhen.Sort_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testInnerJoinAndCaseWhen.Sort_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testInnerJoinAndCaseWhen.Sort_NoBroadcast.plan
index 6153908..40dfe18 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testInnerJoinAndCaseWhen.Sort_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testInnerJoinAndCaseWhen.Sort_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(3)
- => Sort Keys: default.region.r_regionkey (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: default.region.r_regionkey (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
JOIN(7)(INNER)
=> Join Cond: default.region.r_regionkey (INT4) = default.nation.n_regionkey (INT4)
=> target list: cond (TEXT), default.nation.n_regionkey (INT4), 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_regionkey (INT4), default.region.r_regionkey (INT4), num=32)
SORT(11)
- => Sort Keys: default.region.r_regionkey (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: default.region.r_regionkey (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
JOIN(7)(INNER)
=> Join Cond: default.region.r_regionkey (INT4) = default.nation.n_regionkey (INT4)
=> target list: cond (TEXT), default.nation.n_regionkey (INT4), 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_regionkey (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: default.region.r_regionkey (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
SCAN(12) on eb_0000000000000_0000_000003
=> out schema: {(3) cond (TEXT), default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4)}
=> in schema: {(3) cond (TEXT), default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testInnerJoinWithEmptyTable.Hash.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testInnerJoinWithEmptyTable.Hash.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testInnerJoinWithEmptyTable.Hash.plan
index 988980c..df9dfb7 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testInnerJoinWithEmptyTable.Hash.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testInnerJoinWithEmptyTable.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(7)(INNER)
=> 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)
@@ -42,7 +42,7 @@ Block Id: eb_0000000000000_0000_000003 [LEAF]
0: type=Broadcast, tables=default.empty_orders
SORT(11)
- => 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(7)(INNER)
=> 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)
@@ -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(12) 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/TestInnerJoinQuery/testInnerJoinWithEmptyTable.Hash_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testInnerJoinWithEmptyTable.Hash_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testInnerJoinWithEmptyTable.Hash_NoBroadcast.plan
index 742e346..7e412c5 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testInnerJoinWithEmptyTable.Hash_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testInnerJoinWithEmptyTable.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(7)(INNER)
=> 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(11)
- => 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(7)(INNER)
=> 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(12) 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/TestInnerJoinQuery/testInnerJoinWithEmptyTable.Sort.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testInnerJoinWithEmptyTable.Sort.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testInnerJoinWithEmptyTable.Sort.plan
index 988980c..df9dfb7 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testInnerJoinWithEmptyTable.Sort.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testInnerJoinWithEmptyTable.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(7)(INNER)
=> 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)
@@ -42,7 +42,7 @@ Block Id: eb_0000000000000_0000_000003 [LEAF]
0: type=Broadcast, tables=default.empty_orders
SORT(11)
- => 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(7)(INNER)
=> 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)
@@ -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(12) 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/TestInnerJoinQuery/testInnerJoinWithEmptyTable.Sort_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testInnerJoinWithEmptyTable.Sort_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testInnerJoinWithEmptyTable.Sort_NoBroadcast.plan
index 742e346..7e412c5 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testInnerJoinWithEmptyTable.Sort_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testInnerJoinWithEmptyTable.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(7)(INNER)
=> 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(11)
- => 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(7)(INNER)
=> 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(12) 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/TestInnerJoinQuery/testJoinCoReferredEvals1.Hash.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvals1.Hash.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvals1.Hash.plan
index 21e765d..ca091fc 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvals1.Hash.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvals1.Hash.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(3)
- => Sort Keys: default.region.r_regionkey (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: default.region.r_regionkey (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
JOIN(7)(INNER)
=> Join Cond: default.region.r_regionkey (INT4) = default.nation.n_regionkey (INT4)
=> target list: default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), default.region.r_regionkey (INT4) + default.nation.n_regionkey (INT4) as plus
@@ -42,7 +42,7 @@ Block Id: eb_0000000000000_0000_000003 [LEAF]
0: type=Broadcast, tables=default.region
SORT(11)
- => Sort Keys: default.region.r_regionkey (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: default.region.r_regionkey (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
JOIN(7)(INNER)
=> Join Cond: default.region.r_regionkey (INT4) = default.nation.n_regionkey (INT4)
=> target list: default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), default.region.r_regionkey (INT4) + default.nation.n_regionkey (INT4) as plus
@@ -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_regionkey (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: default.region.r_regionkey (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
SCAN(12) on eb_0000000000000_0000_000003
=> out schema: {(3) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus (INT4)}
=> in schema: {(3) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvals1.Hash_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvals1.Hash_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvals1.Hash_NoBroadcast.plan
index 4250b5c..901ce82 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvals1.Hash_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvals1.Hash_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(3)
- => Sort Keys: default.region.r_regionkey (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: default.region.r_regionkey (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
JOIN(7)(INNER)
=> Join Cond: default.region.r_regionkey (INT4) = default.nation.n_regionkey (INT4)
=> target list: default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), default.region.r_regionkey (INT4) + default.nation.n_regionkey (INT4) as plus
@@ -71,7 +71,7 @@ Block Id: eb_0000000000000_0000_000003 [INTERMEDIATE]
[q_0000000000000_0000] 3 => 4 (type=RANGE_SHUFFLE, key=default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), num=32)
SORT(11)
- => Sort Keys: default.region.r_regionkey (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: default.region.r_regionkey (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
JOIN(7)(INNER)
=> Join Cond: default.region.r_regionkey (INT4) = default.nation.n_regionkey (INT4)
=> target list: default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), default.region.r_regionkey (INT4) + default.nation.n_regionkey (INT4) as plus
@@ -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_regionkey (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: default.region.r_regionkey (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
SCAN(12) on eb_0000000000000_0000_000003
=> out schema: {(3) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus (INT4)}
=> in schema: {(3) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvals1.Sort.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvals1.Sort.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvals1.Sort.plan
index 21e765d..ca091fc 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvals1.Sort.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvals1.Sort.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(3)
- => Sort Keys: default.region.r_regionkey (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: default.region.r_regionkey (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
JOIN(7)(INNER)
=> Join Cond: default.region.r_regionkey (INT4) = default.nation.n_regionkey (INT4)
=> target list: default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), default.region.r_regionkey (INT4) + default.nation.n_regionkey (INT4) as plus
@@ -42,7 +42,7 @@ Block Id: eb_0000000000000_0000_000003 [LEAF]
0: type=Broadcast, tables=default.region
SORT(11)
- => Sort Keys: default.region.r_regionkey (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: default.region.r_regionkey (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
JOIN(7)(INNER)
=> Join Cond: default.region.r_regionkey (INT4) = default.nation.n_regionkey (INT4)
=> target list: default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), default.region.r_regionkey (INT4) + default.nation.n_regionkey (INT4) as plus
@@ -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_regionkey (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: default.region.r_regionkey (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
SCAN(12) on eb_0000000000000_0000_000003
=> out schema: {(3) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus (INT4)}
=> in schema: {(3) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvals1.Sort_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvals1.Sort_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvals1.Sort_NoBroadcast.plan
index 4250b5c..901ce82 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvals1.Sort_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvals1.Sort_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(3)
- => Sort Keys: default.region.r_regionkey (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: default.region.r_regionkey (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
JOIN(7)(INNER)
=> Join Cond: default.region.r_regionkey (INT4) = default.nation.n_regionkey (INT4)
=> target list: default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), default.region.r_regionkey (INT4) + default.nation.n_regionkey (INT4) as plus
@@ -71,7 +71,7 @@ Block Id: eb_0000000000000_0000_000003 [INTERMEDIATE]
[q_0000000000000_0000] 3 => 4 (type=RANGE_SHUFFLE, key=default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), num=32)
SORT(11)
- => Sort Keys: default.region.r_regionkey (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: default.region.r_regionkey (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
JOIN(7)(INNER)
=> Join Cond: default.region.r_regionkey (INT4) = default.nation.n_regionkey (INT4)
=> target list: default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), default.region.r_regionkey (INT4) + default.nation.n_regionkey (INT4) as plus
@@ -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_regionkey (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: default.region.r_regionkey (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
SCAN(12) on eb_0000000000000_0000_000003
=> out schema: {(3) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus (INT4)}
=> in schema: {(3) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs1.Hash.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs1.Hash.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs1.Hash.plan
index a8f9f8b..648b1a6 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs1.Hash.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs1.Hash.plan
@@ -5,7 +5,7 @@ PROJECTION(4)
=> out schema: {(6) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), plus2 (INT4), result (INT4), v1 (INT4)}
=> in schema: {(5) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), result (INT4), v1 (INT4)}
SORT(3)
- => Sort Keys: v1 (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: v1 (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
JOIN(7)(INNER)
=> Join Cond: default.region.r_regionkey (INT4) = default.nation.n_regionkey (INT4)
=> target list: default.region.r_regionkey (INT4) + default.nation.n_regionkey (INT4) / 2 as result, default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), v1 (INT4), default.region.r_regionkey (INT4) + default.nation.n_regionkey (INT4) as plus1
@@ -47,7 +47,7 @@ Block Id: eb_0000000000000_0000_000003 [LEAF]
0: type=Broadcast, tables=default.region
SORT(11)
- => Sort Keys: v1 (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: v1 (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
JOIN(7)(INNER)
=> Join Cond: default.region.r_regionkey (INT4) = default.nation.n_regionkey (INT4)
=> target list: default.region.r_regionkey (INT4) + default.nation.n_regionkey (INT4) / 2 as result, default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), v1 (INT4), default.region.r_regionkey (INT4) + default.nation.n_regionkey (INT4) as plus1
@@ -78,7 +78,7 @@ PROJECTION(4)
=> out schema: {(6) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), plus2 (INT4), result (INT4), v1 (INT4)}
=> in schema: {(5) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), result (INT4), v1 (INT4)}
SORT(3)
- => Sort Keys: v1 (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: v1 (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
SCAN(12) on eb_0000000000000_0000_000003
=> out schema: {(5) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), result (INT4), v1 (INT4)}
=> in schema: {(5) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), result (INT4), v1 (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs1.Hash_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs1.Hash_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs1.Hash_NoBroadcast.plan
index 936e4fc..a87cd1b 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs1.Hash_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs1.Hash_NoBroadcast.plan
@@ -5,7 +5,7 @@ PROJECTION(4)
=> out schema: {(6) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), plus2 (INT4), result (INT4), v1 (INT4)}
=> in schema: {(5) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), result (INT4), v1 (INT4)}
SORT(3)
- => Sort Keys: v1 (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: v1 (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
JOIN(7)(INNER)
=> Join Cond: default.region.r_regionkey (INT4) = default.nation.n_regionkey (INT4)
=> target list: default.region.r_regionkey (INT4) + default.nation.n_regionkey (INT4) / 2 as result, default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), v1 (INT4), default.region.r_regionkey (INT4) + default.nation.n_regionkey (INT4) as plus1
@@ -77,7 +77,7 @@ Block Id: eb_0000000000000_0000_000003 [INTERMEDIATE]
[q_0000000000000_0000] 3 => 4 (type=RANGE_SHUFFLE, key=default.nation.n_regionkey (INT4), v1 (INT4), num=32)
SORT(11)
- => Sort Keys: v1 (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: v1 (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
JOIN(7)(INNER)
=> Join Cond: default.region.r_regionkey (INT4) = default.nation.n_regionkey (INT4)
=> target list: default.region.r_regionkey (INT4) + default.nation.n_regionkey (INT4) / 2 as result, default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), v1 (INT4), default.region.r_regionkey (INT4) + default.nation.n_regionkey (INT4) as plus1
@@ -105,7 +105,7 @@ PROJECTION(4)
=> out schema: {(6) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), plus2 (INT4), result (INT4), v1 (INT4)}
=> in schema: {(5) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), result (INT4), v1 (INT4)}
SORT(3)
- => Sort Keys: v1 (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: v1 (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
SCAN(12) on eb_0000000000000_0000_000003
=> out schema: {(5) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), result (INT4), v1 (INT4)}
=> in schema: {(5) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), result (INT4), v1 (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs1.Sort.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs1.Sort.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs1.Sort.plan
index a8f9f8b..648b1a6 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs1.Sort.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs1.Sort.plan
@@ -5,7 +5,7 @@ PROJECTION(4)
=> out schema: {(6) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), plus2 (INT4), result (INT4), v1 (INT4)}
=> in schema: {(5) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), result (INT4), v1 (INT4)}
SORT(3)
- => Sort Keys: v1 (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: v1 (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
JOIN(7)(INNER)
=> Join Cond: default.region.r_regionkey (INT4) = default.nation.n_regionkey (INT4)
=> target list: default.region.r_regionkey (INT4) + default.nation.n_regionkey (INT4) / 2 as result, default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), v1 (INT4), default.region.r_regionkey (INT4) + default.nation.n_regionkey (INT4) as plus1
@@ -47,7 +47,7 @@ Block Id: eb_0000000000000_0000_000003 [LEAF]
0: type=Broadcast, tables=default.region
SORT(11)
- => Sort Keys: v1 (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: v1 (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
JOIN(7)(INNER)
=> Join Cond: default.region.r_regionkey (INT4) = default.nation.n_regionkey (INT4)
=> target list: default.region.r_regionkey (INT4) + default.nation.n_regionkey (INT4) / 2 as result, default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), v1 (INT4), default.region.r_regionkey (INT4) + default.nation.n_regionkey (INT4) as plus1
@@ -78,7 +78,7 @@ PROJECTION(4)
=> out schema: {(6) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), plus2 (INT4), result (INT4), v1 (INT4)}
=> in schema: {(5) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), result (INT4), v1 (INT4)}
SORT(3)
- => Sort Keys: v1 (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: v1 (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
SCAN(12) on eb_0000000000000_0000_000003
=> out schema: {(5) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), result (INT4), v1 (INT4)}
=> in schema: {(5) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), result (INT4), v1 (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs1.Sort_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs1.Sort_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs1.Sort_NoBroadcast.plan
index 936e4fc..a87cd1b 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs1.Sort_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs1.Sort_NoBroadcast.plan
@@ -5,7 +5,7 @@ PROJECTION(4)
=> out schema: {(6) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), plus2 (INT4), result (INT4), v1 (INT4)}
=> in schema: {(5) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), result (INT4), v1 (INT4)}
SORT(3)
- => Sort Keys: v1 (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: v1 (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
JOIN(7)(INNER)
=> Join Cond: default.region.r_regionkey (INT4) = default.nation.n_regionkey (INT4)
=> target list: default.region.r_regionkey (INT4) + default.nation.n_regionkey (INT4) / 2 as result, default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), v1 (INT4), default.region.r_regionkey (INT4) + default.nation.n_regionkey (INT4) as plus1
@@ -77,7 +77,7 @@ Block Id: eb_0000000000000_0000_000003 [INTERMEDIATE]
[q_0000000000000_0000] 3 => 4 (type=RANGE_SHUFFLE, key=default.nation.n_regionkey (INT4), v1 (INT4), num=32)
SORT(11)
- => Sort Keys: v1 (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: v1 (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
JOIN(7)(INNER)
=> Join Cond: default.region.r_regionkey (INT4) = default.nation.n_regionkey (INT4)
=> target list: default.region.r_regionkey (INT4) + default.nation.n_regionkey (INT4) / 2 as result, default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), v1 (INT4), default.region.r_regionkey (INT4) + default.nation.n_regionkey (INT4) as plus1
@@ -105,7 +105,7 @@ PROJECTION(4)
=> out schema: {(6) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), plus2 (INT4), result (INT4), v1 (INT4)}
=> in schema: {(5) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), result (INT4), v1 (INT4)}
SORT(3)
- => Sort Keys: v1 (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: v1 (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
SCAN(12) on eb_0000000000000_0000_000003
=> out schema: {(5) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), result (INT4), v1 (INT4)}
=> in schema: {(5) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), result (INT4), v1 (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs2.Hash.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs2.Hash.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs2.Hash.plan
index d6252ea..5d3c1f4 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs2.Hash.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs2.Hash.plan
@@ -5,7 +5,7 @@ PROJECTION(5)
=> out schema: {(7) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), plus2 (INT4), result (INT4), total (INT8), v1 (INT4)}
=> in schema: {(6) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), result (INT4), total (INT8), v1 (INT4)}
SORT(4)
- => Sort Keys: v1 (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: v1 (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
GROUP_BY(3)(v1,n_regionkey,r_regionkey,?plus,result)
=> exprs: (sum(?plus (INT4)))
=> target list: v1 (INT4), default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), ?plus (INT4) as plus1, result (INT4), total (INT8)
@@ -84,7 +84,7 @@ Block Id: eb_0000000000000_0000_000004 [INTERMEDIATE]
[q_0000000000000_0000] 4 => 5 (type=RANGE_SHUFFLE, key=default.nation.n_regionkey (INT4), v1 (INT4), num=32)
SORT(14)
- => Sort Keys: v1 (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: v1 (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
GROUP_BY(3)(v1,n_regionkey,r_regionkey,?plus,result)
=> exprs: (sum(?sum_3 (INT8)))
=> target list: v1 (INT4), default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), ?plus (INT4) as plus1, result (INT4), total (INT8)
@@ -109,7 +109,7 @@ PROJECTION(5)
=> out schema: {(7) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), plus2 (INT4), result (INT4), total (INT8), v1 (INT4)}
=> in schema: {(6) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), result (INT4), total (INT8), v1 (INT4)}
SORT(4)
- => Sort Keys: v1 (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: v1 (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
SCAN(15) on eb_0000000000000_0000_000004
=> out schema: {(6) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), result (INT4), total (INT8), v1 (INT4)}
=> in schema: {(6) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), result (INT4), total (INT8), v1 (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs2.Hash_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs2.Hash_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs2.Hash_NoBroadcast.plan
index f3a2084..78dd565 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs2.Hash_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs2.Hash_NoBroadcast.plan
@@ -5,7 +5,7 @@ PROJECTION(5)
=> out schema: {(7) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), plus2 (INT4), result (INT4), total (INT8), v1 (INT4)}
=> in schema: {(6) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), result (INT4), total (INT8), v1 (INT4)}
SORT(4)
- => Sort Keys: v1 (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: v1 (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
GROUP_BY(3)(v1,n_regionkey,r_regionkey,?plus,result)
=> exprs: (sum(?plus (INT4)))
=> target list: v1 (INT4), default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), ?plus (INT4) as plus1, result (INT4), total (INT8)
@@ -111,7 +111,7 @@ Block Id: eb_0000000000000_0000_000004 [INTERMEDIATE]
[q_0000000000000_0000] 4 => 5 (type=RANGE_SHUFFLE, key=default.nation.n_regionkey (INT4), v1 (INT4), num=32)
SORT(14)
- => Sort Keys: v1 (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: v1 (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
GROUP_BY(3)(v1,n_regionkey,r_regionkey,?plus,result)
=> exprs: (sum(?sum_3 (INT8)))
=> target list: v1 (INT4), default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), ?plus (INT4) as plus1, result (INT4), total (INT8)
@@ -136,7 +136,7 @@ PROJECTION(5)
=> out schema: {(7) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), plus2 (INT4), result (INT4), total (INT8), v1 (INT4)}
=> in schema: {(6) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), result (INT4), total (INT8), v1 (INT4)}
SORT(4)
- => Sort Keys: v1 (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: v1 (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
SCAN(15) on eb_0000000000000_0000_000004
=> out schema: {(6) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), result (INT4), total (INT8), v1 (INT4)}
=> in schema: {(6) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), result (INT4), total (INT8), v1 (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs2.Sort.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs2.Sort.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs2.Sort.plan
index d6252ea..5d3c1f4 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs2.Sort.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs2.Sort.plan
@@ -5,7 +5,7 @@ PROJECTION(5)
=> out schema: {(7) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), plus2 (INT4), result (INT4), total (INT8), v1 (INT4)}
=> in schema: {(6) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), result (INT4), total (INT8), v1 (INT4)}
SORT(4)
- => Sort Keys: v1 (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: v1 (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
GROUP_BY(3)(v1,n_regionkey,r_regionkey,?plus,result)
=> exprs: (sum(?plus (INT4)))
=> target list: v1 (INT4), default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), ?plus (INT4) as plus1, result (INT4), total (INT8)
@@ -84,7 +84,7 @@ Block Id: eb_0000000000000_0000_000004 [INTERMEDIATE]
[q_0000000000000_0000] 4 => 5 (type=RANGE_SHUFFLE, key=default.nation.n_regionkey (INT4), v1 (INT4), num=32)
SORT(14)
- => Sort Keys: v1 (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: v1 (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
GROUP_BY(3)(v1,n_regionkey,r_regionkey,?plus,result)
=> exprs: (sum(?sum_3 (INT8)))
=> target list: v1 (INT4), default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), ?plus (INT4) as plus1, result (INT4), total (INT8)
@@ -109,7 +109,7 @@ PROJECTION(5)
=> out schema: {(7) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), plus2 (INT4), result (INT4), total (INT8), v1 (INT4)}
=> in schema: {(6) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), result (INT4), total (INT8), v1 (INT4)}
SORT(4)
- => Sort Keys: v1 (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: v1 (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
SCAN(15) on eb_0000000000000_0000_000004
=> out schema: {(6) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), result (INT4), total (INT8), v1 (INT4)}
=> in schema: {(6) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), result (INT4), total (INT8), v1 (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs2.Sort_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs2.Sort_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs2.Sort_NoBroadcast.plan
index f3a2084..78dd565 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs2.Sort_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinCoReferredEvalsWithSameExprs2.Sort_NoBroadcast.plan
@@ -5,7 +5,7 @@ PROJECTION(5)
=> out schema: {(7) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), plus2 (INT4), result (INT4), total (INT8), v1 (INT4)}
=> in schema: {(6) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), result (INT4), total (INT8), v1 (INT4)}
SORT(4)
- => Sort Keys: v1 (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: v1 (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
GROUP_BY(3)(v1,n_regionkey,r_regionkey,?plus,result)
=> exprs: (sum(?plus (INT4)))
=> target list: v1 (INT4), default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), ?plus (INT4) as plus1, result (INT4), total (INT8)
@@ -111,7 +111,7 @@ Block Id: eb_0000000000000_0000_000004 [INTERMEDIATE]
[q_0000000000000_0000] 4 => 5 (type=RANGE_SHUFFLE, key=default.nation.n_regionkey (INT4), v1 (INT4), num=32)
SORT(14)
- => Sort Keys: v1 (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: v1 (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
GROUP_BY(3)(v1,n_regionkey,r_regionkey,?plus,result)
=> exprs: (sum(?sum_3 (INT8)))
=> target list: v1 (INT4), default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), ?plus (INT4) as plus1, result (INT4), total (INT8)
@@ -136,7 +136,7 @@ PROJECTION(5)
=> out schema: {(7) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), plus2 (INT4), result (INT4), total (INT8), v1 (INT4)}
=> in schema: {(6) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), result (INT4), total (INT8), v1 (INT4)}
SORT(4)
- => Sort Keys: v1 (INT4) (asc),default.nation.n_regionkey (INT4) (asc)
+ => Sort Keys: v1 (INT4) (asc, nulls last),default.nation.n_regionkey (INT4) (asc, nulls last)
SCAN(15) on eb_0000000000000_0000_000004
=> out schema: {(6) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), result (INT4), total (INT8), v1 (INT4)}
=> in schema: {(6) default.nation.n_regionkey (INT4), default.region.r_regionkey (INT4), plus1 (INT4), result (INT4), total (INT8), v1 (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinOnMultipleDatabases.Hash.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinOnMultipleDatabases.Hash.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinOnMultipleDatabases.Hash.plan
index 4bb88a4..466c0be 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinOnMultipleDatabases.Hash.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinOnMultipleDatabases.Hash.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(6)
- => Sort Keys: joins.supplier_.s_acctbal (FLOAT8) (asc),joins.supplier_.s_name (TEXT) (asc),default.nation.n_name (TEXT) (asc),joins.part_.p_partkey (INT4) (asc)
+ => Sort Keys: joins.supplier_.s_acctbal (FLOAT8) (asc, nulls last),joins.supplier_.s_name (TEXT) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last),joins.part_.p_partkey (INT4) (asc, nulls last)
JOIN(16)(INNER)
=> Join Cond: joins.supplier_.s_nationkey (INT4) = default.nation.n_nationkey (INT4)
=> target list: default.nation.n_name (TEXT), joins.part_.p_mfgr (TEXT), joins.part_.p_partkey (INT4), joins.supplier_.s_acctbal (FLOAT8), joins.supplier_.s_address (TEXT), joins.supplier_.s_comment (TEXT), joins.supplier_.s_name (TEXT), joins.supplier_.s_phone (TEXT)
@@ -72,7 +72,7 @@ Block Id: eb_0000000000000_0000_000009 [LEAF]
3: type=Broadcast, tables=joins.supplier_
SORT(26)
- => Sort Keys: joins.supplier_.s_acctbal (FLOAT8) (asc),joins.supplier_.s_name (TEXT) (asc),default.nation.n_name (TEXT) (asc),joins.part_.p_partkey (INT4) (asc)
+ => Sort Keys: joins.supplier_.s_acctbal (FLOAT8) (asc, nulls last),joins.supplier_.s_name (TEXT) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last),joins.part_.p_partkey (INT4) (asc, nulls last)
JOIN(16)(INNER)
=> Join Cond: joins.supplier_.s_nationkey (INT4) = default.nation.n_nationkey (INT4)
=> target list: default.nation.n_name (TEXT), joins.part_.p_mfgr (TEXT), joins.part_.p_partkey (INT4), joins.supplier_.s_acctbal (FLOAT8), joins.supplier_.s_address (TEXT), joins.supplier_.s_comment (TEXT), joins.supplier_.s_name (TEXT), joins.supplier_.s_phone (TEXT)
@@ -125,7 +125,7 @@ Block Id: eb_0000000000000_0000_000010 [ROOT]
0: sorted input=eb_0000000000000_0000_000009
SORT(6)
- => Sort Keys: joins.supplier_.s_acctbal (FLOAT8) (asc),joins.supplier_.s_name (TEXT) (asc),default.nation.n_name (TEXT) (asc),joins.part_.p_partkey (INT4) (asc)
+ => Sort Keys: joins.supplier_.s_acctbal (FLOAT8) (asc, nulls last),joins.supplier_.s_name (TEXT) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last),joins.part_.p_partkey (INT4) (asc, nulls last)
SCAN(27) on eb_0000000000000_0000_000009
=> out schema: {(8) default.nation.n_name (TEXT), joins.part_.p_mfgr (TEXT), joins.part_.p_partkey (INT4), joins.supplier_.s_acctbal (FLOAT8), joins.supplier_.s_address (TEXT), joins.supplier_.s_comment (TEXT), joins.supplier_.s_name (TEXT), joins.supplier_.s_phone (TEXT)}
=> in schema: {(8) default.nation.n_name (TEXT), joins.part_.p_mfgr (TEXT), joins.part_.p_partkey (INT4), joins.supplier_.s_acctbal (FLOAT8), joins.supplier_.s_address (TEXT), joins.supplier_.s_comment (TEXT), joins.supplier_.s_name (TEXT), joins.supplier_.s_phone (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinOnMultipleDatabases.Hash_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinOnMultipleDatabases.Hash_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinOnMultipleDatabases.Hash_NoBroadcast.plan
index 19750a2..df2c800 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinOnMultipleDatabases.Hash_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinOnMultipleDatabases.Hash_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(6)
- => Sort Keys: joins.supplier_.s_acctbal (FLOAT8) (asc),joins.supplier_.s_name (TEXT) (asc),default.nation.n_name (TEXT) (asc),joins.part_.p_partkey (INT4) (asc)
+ => Sort Keys: joins.supplier_.s_acctbal (FLOAT8) (asc, nulls last),joins.supplier_.s_name (TEXT) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last),joins.part_.p_partkey (INT4) (asc, nulls last)
JOIN(16)(INNER)
=> Join Cond: joins.supplier_.s_nationkey (INT4) = default.nation.n_nationkey (INT4)
=> target list: default.nation.n_name (TEXT), joins.part_.p_mfgr (TEXT), joins.part_.p_partkey (INT4), joins.supplier_.s_acctbal (FLOAT8), joins.supplier_.s_address (TEXT), joins.supplier_.s_comment (TEXT), joins.supplier_.s_name (TEXT), joins.supplier_.s_phone (TEXT)
@@ -215,7 +215,7 @@ Block Id: eb_0000000000000_0000_000009 [INTERMEDIATE]
[q_0000000000000_0000] 9 => 10 (type=RANGE_SHUFFLE, key=default.nation.n_name (TEXT), joins.part_.p_partkey (INT4), joins.supplier_.s_acctbal (FLOAT8), joins.supplier_.s_name (TEXT), num=32)
SORT(26)
- => Sort Keys: joins.supplier_.s_acctbal (FLOAT8) (asc),joins.supplier_.s_name (TEXT) (asc),default.nation.n_name (TEXT) (asc),joins.part_.p_partkey (INT4) (asc)
+ => Sort Keys: joins.supplier_.s_acctbal (FLOAT8) (asc, nulls last),joins.supplier_.s_name (TEXT) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last),joins.part_.p_partkey (INT4) (asc, nulls last)
JOIN(16)(INNER)
=> Join Cond: joins.supplier_.s_nationkey (INT4) = default.nation.n_nationkey (INT4)
=> target list: default.nation.n_name (TEXT), joins.part_.p_mfgr (TEXT), joins.part_.p_partkey (INT4), joins.supplier_.s_acctbal (FLOAT8), joins.supplier_.s_address (TEXT), joins.supplier_.s_comment (TEXT), joins.supplier_.s_name (TEXT), joins.supplier_.s_phone (TEXT)
@@ -239,7 +239,7 @@ Block Id: eb_0000000000000_0000_000010 [ROOT]
0: sorted input=eb_0000000000000_0000_000009
SORT(6)
- => Sort Keys: joins.supplier_.s_acctbal (FLOAT8) (asc),joins.supplier_.s_name (TEXT) (asc),default.nation.n_name (TEXT) (asc),joins.part_.p_partkey (INT4) (asc)
+ => Sort Keys: joins.supplier_.s_acctbal (FLOAT8) (asc, nulls last),joins.supplier_.s_name (TEXT) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last),joins.part_.p_partkey (INT4) (asc, nulls last)
SCAN(27) on eb_0000000000000_0000_000009
=> out schema: {(8) default.nation.n_name (TEXT), joins.part_.p_mfgr (TEXT), joins.part_.p_partkey (INT4), joins.supplier_.s_acctbal (FLOAT8), joins.supplier_.s_address (TEXT), joins.supplier_.s_comment (TEXT), joins.supplier_.s_name (TEXT), joins.supplier_.s_phone (TEXT)}
=> in schema: {(8) default.nation.n_name (TEXT), joins.part_.p_mfgr (TEXT), joins.part_.p_partkey (INT4), joins.supplier_.s_acctbal (FLOAT8), joins.supplier_.s_address (TEXT), joins.supplier_.s_comment (TEXT), joins.supplier_.s_name (TEXT), joins.supplier_.s_phone (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinOnMultipleDatabases.Sort.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinOnMultipleDatabases.Sort.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinOnMultipleDatabases.Sort.plan
index 4bb88a4..466c0be 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinOnMultipleDatabases.Sort.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinOnMultipleDatabases.Sort.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(6)
- => Sort Keys: joins.supplier_.s_acctbal (FLOAT8) (asc),joins.supplier_.s_name (TEXT) (asc),default.nation.n_name (TEXT) (asc),joins.part_.p_partkey (INT4) (asc)
+ => Sort Keys: joins.supplier_.s_acctbal (FLOAT8) (asc, nulls last),joins.supplier_.s_name (TEXT) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last),joins.part_.p_partkey (INT4) (asc, nulls last)
JOIN(16)(INNER)
=> Join Cond: joins.supplier_.s_nationkey (INT4) = default.nation.n_nationkey (INT4)
=> target list: default.nation.n_name (TEXT), joins.part_.p_mfgr (TEXT), joins.part_.p_partkey (INT4), joins.supplier_.s_acctbal (FLOAT8), joins.supplier_.s_address (TEXT), joins.supplier_.s_comment (TEXT), joins.supplier_.s_name (TEXT), joins.supplier_.s_phone (TEXT)
@@ -72,7 +72,7 @@ Block Id: eb_0000000000000_0000_000009 [LEAF]
3: type=Broadcast, tables=joins.supplier_
SORT(26)
- => Sort Keys: joins.supplier_.s_acctbal (FLOAT8) (asc),joins.supplier_.s_name (TEXT) (asc),default.nation.n_name (TEXT) (asc),joins.part_.p_partkey (INT4) (asc)
+ => Sort Keys: joins.supplier_.s_acctbal (FLOAT8) (asc, nulls last),joins.supplier_.s_name (TEXT) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last),joins.part_.p_partkey (INT4) (asc, nulls last)
JOIN(16)(INNER)
=> Join Cond: joins.supplier_.s_nationkey (INT4) = default.nation.n_nationkey (INT4)
=> target list: default.nation.n_name (TEXT), joins.part_.p_mfgr (TEXT), joins.part_.p_partkey (INT4), joins.supplier_.s_acctbal (FLOAT8), joins.supplier_.s_address (TEXT), joins.supplier_.s_comment (TEXT), joins.supplier_.s_name (TEXT), joins.supplier_.s_phone (TEXT)
@@ -125,7 +125,7 @@ Block Id: eb_0000000000000_0000_000010 [ROOT]
0: sorted input=eb_0000000000000_0000_000009
SORT(6)
- => Sort Keys: joins.supplier_.s_acctbal (FLOAT8) (asc),joins.supplier_.s_name (TEXT) (asc),default.nation.n_name (TEXT) (asc),joins.part_.p_partkey (INT4) (asc)
+ => Sort Keys: joins.supplier_.s_acctbal (FLOAT8) (asc, nulls last),joins.supplier_.s_name (TEXT) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last),joins.part_.p_partkey (INT4) (asc, nulls last)
SCAN(27) on eb_0000000000000_0000_000009
=> out schema: {(8) default.nation.n_name (TEXT), joins.part_.p_mfgr (TEXT), joins.part_.p_partkey (INT4), joins.supplier_.s_acctbal (FLOAT8), joins.supplier_.s_address (TEXT), joins.supplier_.s_comment (TEXT), joins.supplier_.s_name (TEXT), joins.supplier_.s_phone (TEXT)}
=> in schema: {(8) default.nation.n_name (TEXT), joins.part_.p_mfgr (TEXT), joins.part_.p_partkey (INT4), joins.supplier_.s_acctbal (FLOAT8), joins.supplier_.s_address (TEXT), joins.supplier_.s_comment (TEXT), joins.supplier_.s_name (TEXT), joins.supplier_.s_phone (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinOnMultipleDatabases.Sort_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinOnMultipleDatabases.Sort_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinOnMultipleDatabases.Sort_NoBroadcast.plan
index 19750a2..df2c800 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinOnMultipleDatabases.Sort_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinOnMultipleDatabases.Sort_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(6)
- => Sort Keys: joins.supplier_.s_acctbal (FLOAT8) (asc),joins.supplier_.s_name (TEXT) (asc),default.nation.n_name (TEXT) (asc),joins.part_.p_partkey (INT4) (asc)
+ => Sort Keys: joins.supplier_.s_acctbal (FLOAT8) (asc, nulls last),joins.supplier_.s_name (TEXT) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last),joins.part_.p_partkey (INT4) (asc, nulls last)
JOIN(16)(INNER)
=> Join Cond: joins.supplier_.s_nationkey (INT4) = default.nation.n_nationkey (INT4)
=> target list: default.nation.n_name (TEXT), joins.part_.p_mfgr (TEXT), joins.part_.p_partkey (INT4), joins.supplier_.s_acctbal (FLOAT8), joins.supplier_.s_address (TEXT), joins.supplier_.s_comment (TEXT), joins.supplier_.s_name (TEXT), joins.supplier_.s_phone (TEXT)
@@ -215,7 +215,7 @@ Block Id: eb_0000000000000_0000_000009 [INTERMEDIATE]
[q_0000000000000_0000] 9 => 10 (type=RANGE_SHUFFLE, key=default.nation.n_name (TEXT), joins.part_.p_partkey (INT4), joins.supplier_.s_acctbal (FLOAT8), joins.supplier_.s_name (TEXT), num=32)
SORT(26)
- => Sort Keys: joins.supplier_.s_acctbal (FLOAT8) (asc),joins.supplier_.s_name (TEXT) (asc),default.nation.n_name (TEXT) (asc),joins.part_.p_partkey (INT4) (asc)
+ => Sort Keys: joins.supplier_.s_acctbal (FLOAT8) (asc, nulls last),joins.supplier_.s_name (TEXT) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last),joins.part_.p_partkey (INT4) (asc, nulls last)
JOIN(16)(INNER)
=> Join Cond: joins.supplier_.s_nationkey (INT4) = default.nation.n_nationkey (INT4)
=> target list: default.nation.n_name (TEXT), joins.part_.p_mfgr (TEXT), joins.part_.p_partkey (INT4), joins.supplier_.s_acctbal (FLOAT8), joins.supplier_.s_address (TEXT), joins.supplier_.s_comment (TEXT), joins.supplier_.s_name (TEXT), joins.supplier_.s_phone (TEXT)
@@ -239,7 +239,7 @@ Block Id: eb_0000000000000_0000_000010 [ROOT]
0: sorted input=eb_0000000000000_0000_000009
SORT(6)
- => Sort Keys: joins.supplier_.s_acctbal (FLOAT8) (asc),joins.supplier_.s_name (TEXT) (asc),default.nation.n_name (TEXT) (asc),joins.part_.p_partkey (INT4) (asc)
+ => Sort Keys: joins.supplier_.s_acctbal (FLOAT8) (asc, nulls last),joins.supplier_.s_name (TEXT) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last),joins.part_.p_partkey (INT4) (asc, nulls last)
SCAN(27) on eb_0000000000000_0000_000009
=> out schema: {(8) default.nation.n_name (TEXT), joins.part_.p_mfgr (TEXT), joins.part_.p_partkey (INT4), joins.supplier_.s_acctbal (FLOAT8), joins.supplier_.s_address (TEXT), joins.supplier_.s_comment (TEXT), joins.supplier_.s_name (TEXT), joins.supplier_.s_phone (TEXT)}
=> in schema: {(8) default.nation.n_name (TEXT), joins.part_.p_mfgr (TEXT), joins.part_.p_partkey (INT4), joins.supplier_.s_acctbal (FLOAT8), joins.supplier_.s_address (TEXT), joins.supplier_.s_comment (TEXT), joins.supplier_.s_name (TEXT), joins.supplier_.s_phone (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinWithMultipleJoinQual1.Hash.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinWithMultipleJoinQual1.Hash.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinWithMultipleJoinQual1.Hash.plan
index ccbd219..da5cc8f 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinWithMultipleJoinQual1.Hash.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testJoinWithMultipleJoinQual1.Hash.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(10)
- => Sort Keys: default.s.s_acctbal (FLOAT8) (asc),default.s.s_name (TEXT) (asc),default.n.n_name (TEXT) (asc),default.p.p_partkey (INT4) (asc)
+ => Sort Keys: default.s.s_acctbal (FLOAT8) (asc, nulls last),default.s.s_name (TEXT) (asc, nulls last),default.n.n_name (TEXT) (asc, nulls last),default.p.p_partkey (INT4) (asc, nulls last)
JOIN(16)(INNER)
=> Join Cond: (default.n.n_regionkey (INT4) = default.ps.ps_suppkey (INT4) AND default.s.s_nationkey (INT4) = default.n.n_nationkey (INT4))
=> target list: default.n.n_name (TEXT), default.p.p_mfgr (TEXT), default.p.p_partkey (INT4), default.s.s_acctbal (FLOAT8), default.s.s_address (TEXT), default.s.s_comment (TEXT), default.s.s_name (TEXT), default.s.s_phone (TEXT)
@@ -72,7 +72,7 @@ Block Id: eb_0000000000000_0000_000009 [LEAF]
3: type=Broadcast, tables=default.s
SORT(26)
- => Sort Keys: default.s.s_acctbal (FLOAT8) (asc),default.s.s_name (TEXT) (asc),default.n.n_name (TEXT) (asc),default.p.p_partkey (INT4) (asc)
+ => Sort Keys: default.s.s_acctbal (FLOAT8) (asc, nulls last),default.s.s_name (TEXT) (asc, nulls last),default.n.n_name (TEXT) (asc, nulls last),default.p.p_partkey (INT4) (asc, nulls last)
JOIN(16)(INNER)
=> Join Cond: (default.n.n_regionkey (INT4) = default.ps.ps_suppkey (INT4) AND default.s.s_nationkey (INT4) = default.n.n_nationkey (INT4))
=> target list: default.n.n_name (TEXT), default.p.p_mfgr (TEXT), default.p.p_partkey (INT4), default.s.s_acctbal (FLOAT8), default.s.s_address (TEXT), default.s.s_comment (TEXT), default.s.s_name (TEXT), default.s.s_phone (TEXT)
@@ -125,7 +125,7 @@ Block Id: eb_0000000000000_0000_000010 [ROOT]
0: sorted input=eb_0000000000000_0000_000009
SORT(10)
- => Sort Keys: default.s.s_acctbal (FLOAT8) (asc),default.s.s_name (TEXT) (asc),default.n.n_name (TEXT) (asc),default.p.p_partkey (INT4) (asc)
+ => Sort Keys: default.s.s_acctbal (FLOAT8) (asc, nulls last),default.s.s_name (TEXT) (asc, nulls last),default.n.n_name (TEXT) (asc, nulls last),default.p.p_partkey (INT4) (asc, nulls last)
SCAN(27) on eb_0000000000000_0000_000009
=> out schema: {(8) default.n.n_name (TEXT), default.p.p_mfgr (TEXT), default.p.p_partkey (INT4), default.s.s_acctbal (FLOAT8), default.s.s_address (TEXT), default.s.s_comment (TEXT), default.s.s_name (TEXT), default.s.s_phone (TEXT)}
=> in schema: {(8) default.n.n_name (TEXT), default.p.p_mfgr (TEXT), default.p.p_partkey (INT4), default.s.s_acctbal (FLOAT8), default.s.s_address (TEXT), default.s.s_comment (TEXT), default.s.s_name (TEXT), default.s.s_phone (TEXT)}