tajo-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jihoon...@apache.org
Subject [3/8] tajo git commit: TAJO-2135: Invalid join result when join key columns contain nulls.
Date Wed, 04 May 2016 10:38:19 GMT
http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable5.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable5.result b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable5.result
index ca202cb..05bc52d 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable5.result
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithEmptyTable5.result
@@ -2,3 +2,4 @@ l_linenumber,?sum,?max_1,?max_2,?avg_3,?sum_4
 -------------------------------
 1,null,null,null,33.333333333333336,100.0
 2,null,null,null,42.5,85.0
+null,null,null,null,null,null

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithNull1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithNull1.result b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithNull1.result
index 299d8c5..c7c33f5 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithNull1.result
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testLeftOuterJoinWithNull1.result
@@ -2,3 +2,6 @@ c_custkey,o_orderkey,?coalesce,o_orderdate
 -------------------------------
 4,null,N/A,null
 5,null,N/A,null
+null,null,N/A,null
+null,null,N/A,null
+null,null,N/A,null

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testMultipleBroadcastDataFileWithZeroLength.Hash.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testMultipleBroadcastDataFileWithZeroLength.Hash.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testMultipleBroadcastDataFileWithZeroLength.Hash.plan
index cad2151..a61d2b2 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testMultipleBroadcastDataFileWithZeroLength.Hash.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testMultipleBroadcastDataFileWithZeroLength.Hash.plan
@@ -1,7 +1,7 @@
 explain
 -------------------------------
 SELECTION(3)
-  => Search Cond: default.b.n_nationkey (INT4) IS NULL
+  => Search Cond: default.b.n_nationkey (INT4) = 100
    JOIN(6)(LEFT_OUTER)
      => Join Cond: default.a.c_nationkey (INT4) = default.b.n_nationkey (INT4)
      => target list: default.a.c_acctbal (FLOAT8), default.a.c_address (TEXT), default.a.c_comment (TEXT), default.a.c_custkey (INT4), default.a.c_mktsegment (TEXT), default.a.c_name (TEXT), default.a.c_nationkey (INT4), default.a.c_phone (TEXT), default.b.n_comment (TEXT), default.b.n_name (TEXT), default.b.n_nationkey (INT4), default.b.n_regionkey (INT4)
@@ -37,7 +37,7 @@ Block Id: eb_0000000000000_0000_000003 [ROOT]
  0: type=Broadcast, tables=default.b
 
 SELECTION(3)
-  => Search Cond: default.b.n_nationkey (INT4) IS NULL
+  => Search Cond: default.b.n_nationkey (INT4) = 100
    JOIN(6)(LEFT_OUTER)
      => Join Cond: default.a.c_nationkey (INT4) = default.b.n_nationkey (INT4)
      => target list: default.a.c_acctbal (FLOAT8), default.a.c_address (TEXT), default.a.c_comment (TEXT), default.a.c_custkey (INT4), default.a.c_mktsegment (TEXT), default.a.c_name (TEXT), default.a.c_nationkey (INT4), default.a.c_phone (TEXT), default.b.n_comment (TEXT), default.b.n_name (TEXT), default.b.n_nationkey (INT4), default.b.n_regionkey (INT4)

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testMultipleBroadcastDataFileWithZeroLength.Hash_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testMultipleBroadcastDataFileWithZeroLength.Hash_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testMultipleBroadcastDataFileWithZeroLength.Hash_NoBroadcast.plan
index a708b1d..852ca29 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testMultipleBroadcastDataFileWithZeroLength.Hash_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testMultipleBroadcastDataFileWithZeroLength.Hash_NoBroadcast.plan
@@ -1,7 +1,7 @@
 explain
 -------------------------------
 SELECTION(3)
-  => Search Cond: default.b.n_nationkey (INT4) IS NULL
+  => Search Cond: default.b.n_nationkey (INT4) = 100
    JOIN(6)(LEFT_OUTER)
      => Join Cond: default.a.c_nationkey (INT4) = default.b.n_nationkey (INT4)
      => target list: default.a.c_acctbal (FLOAT8), default.a.c_address (TEXT), default.a.c_comment (TEXT), default.a.c_custkey (INT4), default.a.c_mktsegment (TEXT), default.a.c_name (TEXT), default.a.c_nationkey (INT4), default.a.c_phone (TEXT), default.b.n_comment (TEXT), default.b.n_name (TEXT), default.b.n_nationkey (INT4), default.b.n_regionkey (INT4)
@@ -66,7 +66,7 @@ Block Id: eb_0000000000000_0000_000003 [ROOT]
 [q_0000000000000_0000] 2 => 3 (type=HASH_SHUFFLE, key=default.b.n_nationkey (INT4), num=32)
 
 SELECTION(3)
-  => Search Cond: default.b.n_nationkey (INT4) IS NULL
+  => Search Cond: default.b.n_nationkey (INT4) = 100
    JOIN(6)(LEFT_OUTER)
      => Join Cond: default.a.c_nationkey (INT4) = default.b.n_nationkey (INT4)
      => target list: default.a.c_acctbal (FLOAT8), default.a.c_address (TEXT), default.a.c_comment (TEXT), default.a.c_custkey (INT4), default.a.c_mktsegment (TEXT), default.a.c_name (TEXT), default.a.c_nationkey (INT4), default.a.c_phone (TEXT), default.b.n_comment (TEXT), default.b.n_name (TEXT), default.b.n_nationkey (INT4), default.b.n_regionkey (INT4)

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testMultipleBroadcastDataFileWithZeroLength.Sort.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testMultipleBroadcastDataFileWithZeroLength.Sort.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testMultipleBroadcastDataFileWithZeroLength.Sort.plan
index cad2151..a61d2b2 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testMultipleBroadcastDataFileWithZeroLength.Sort.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testMultipleBroadcastDataFileWithZeroLength.Sort.plan
@@ -1,7 +1,7 @@
 explain
 -------------------------------
 SELECTION(3)
-  => Search Cond: default.b.n_nationkey (INT4) IS NULL
+  => Search Cond: default.b.n_nationkey (INT4) = 100
    JOIN(6)(LEFT_OUTER)
      => Join Cond: default.a.c_nationkey (INT4) = default.b.n_nationkey (INT4)
      => target list: default.a.c_acctbal (FLOAT8), default.a.c_address (TEXT), default.a.c_comment (TEXT), default.a.c_custkey (INT4), default.a.c_mktsegment (TEXT), default.a.c_name (TEXT), default.a.c_nationkey (INT4), default.a.c_phone (TEXT), default.b.n_comment (TEXT), default.b.n_name (TEXT), default.b.n_nationkey (INT4), default.b.n_regionkey (INT4)
@@ -37,7 +37,7 @@ Block Id: eb_0000000000000_0000_000003 [ROOT]
  0: type=Broadcast, tables=default.b
 
 SELECTION(3)
-  => Search Cond: default.b.n_nationkey (INT4) IS NULL
+  => Search Cond: default.b.n_nationkey (INT4) = 100
    JOIN(6)(LEFT_OUTER)
      => Join Cond: default.a.c_nationkey (INT4) = default.b.n_nationkey (INT4)
      => target list: default.a.c_acctbal (FLOAT8), default.a.c_address (TEXT), default.a.c_comment (TEXT), default.a.c_custkey (INT4), default.a.c_mktsegment (TEXT), default.a.c_name (TEXT), default.a.c_nationkey (INT4), default.a.c_phone (TEXT), default.b.n_comment (TEXT), default.b.n_name (TEXT), default.b.n_nationkey (INT4), default.b.n_regionkey (INT4)

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testMultipleBroadcastDataFileWithZeroLength.Sort_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testMultipleBroadcastDataFileWithZeroLength.Sort_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testMultipleBroadcastDataFileWithZeroLength.Sort_NoBroadcast.plan
index a708b1d..852ca29 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testMultipleBroadcastDataFileWithZeroLength.Sort_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testMultipleBroadcastDataFileWithZeroLength.Sort_NoBroadcast.plan
@@ -1,7 +1,7 @@
 explain
 -------------------------------
 SELECTION(3)
-  => Search Cond: default.b.n_nationkey (INT4) IS NULL
+  => Search Cond: default.b.n_nationkey (INT4) = 100
    JOIN(6)(LEFT_OUTER)
      => Join Cond: default.a.c_nationkey (INT4) = default.b.n_nationkey (INT4)
      => target list: default.a.c_acctbal (FLOAT8), default.a.c_address (TEXT), default.a.c_comment (TEXT), default.a.c_custkey (INT4), default.a.c_mktsegment (TEXT), default.a.c_name (TEXT), default.a.c_nationkey (INT4), default.a.c_phone (TEXT), default.b.n_comment (TEXT), default.b.n_name (TEXT), default.b.n_nationkey (INT4), default.b.n_regionkey (INT4)
@@ -66,7 +66,7 @@ Block Id: eb_0000000000000_0000_000003 [ROOT]
 [q_0000000000000_0000] 2 => 3 (type=HASH_SHUFFLE, key=default.b.n_nationkey (INT4), num=32)
 
 SELECTION(3)
-  => Search Cond: default.b.n_nationkey (INT4) IS NULL
+  => Search Cond: default.b.n_nationkey (INT4) = 100
    JOIN(6)(LEFT_OUTER)
      => Join Cond: default.a.c_nationkey (INT4) = default.b.n_nationkey (INT4)
      => target list: default.a.c_acctbal (FLOAT8), default.a.c_address (TEXT), default.a.c_comment (TEXT), default.a.c_custkey (INT4), default.a.c_mktsegment (TEXT), default.a.c_name (TEXT), default.a.c_nationkey (INT4), default.a.c_phone (TEXT), default.b.n_comment (TEXT), default.b.n_name (TEXT), default.b.n_nationkey (INT4), default.b.n_regionkey (INT4)

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testRightOuterJoin1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testRightOuterJoin1.result b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testRightOuterJoin1.result
index b4f308a..2e4b24b 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testRightOuterJoin1.result
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testRightOuterJoin1.result
@@ -5,3 +5,6 @@ c_custkey,o_orderkey
 3,3
 4,null
 5,null
+null,null
+null,null
+null,null

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testRightOuterJoinWithEmptyTable1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testRightOuterJoinWithEmptyTable1.result b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testRightOuterJoinWithEmptyTable1.result
index 4475f03..aba341c 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testRightOuterJoinWithEmptyTable1.result
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testRightOuterJoinWithEmptyTable1.result
@@ -5,3 +5,6 @@ c_custkey,o_orderkey
 3,null
 4,null
 5,null
+null,null
+null,null
+null,null

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestOuterJoinWithSubQuery/testLeftOuterJoinWithConstantExpr2.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinWithSubQuery/testLeftOuterJoinWithConstantExpr2.result b/tajo-core-tests/src/test/resources/results/TestOuterJoinWithSubQuery/testLeftOuterJoinWithConstantExpr2.result
index a4a0818..a3c7143 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinWithSubQuery/testLeftOuterJoinWithConstantExpr2.result
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinWithSubQuery/testLeftOuterJoinWithConstantExpr2.result
@@ -5,3 +5,6 @@ c_custkey,o_orderkey,val
 3,3,val
 4,null,val
 5,null,val
+null,null,val
+null,null,val
+null,null,val

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestOuterJoinWithSubQuery/testLeftOuterJoinWithConstantExpr3.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinWithSubQuery/testLeftOuterJoinWithConstantExpr3.result b/tajo-core-tests/src/test/resources/results/TestOuterJoinWithSubQuery/testLeftOuterJoinWithConstantExpr3.result
index ab1487b..1210f4f 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinWithSubQuery/testLeftOuterJoinWithConstantExpr3.result
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinWithSubQuery/testLeftOuterJoinWithConstantExpr3.result
@@ -5,3 +5,6 @@ c_custkey,const_val,min_name
 3,123,Customer#000000003
 4,123,Customer#000000004
 5,123,Customer#000000005
+null,123,null
+null,123,null
+null,123,null

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestQueryOnSelfDescTable/testCrossJoin.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestQueryOnSelfDescTable/testCrossJoin.result b/tajo-core-tests/src/test/resources/results/TestQueryOnSelfDescTable/testCrossJoin.result
index 52f385a..c53a4c3 100644
--- a/tajo-core-tests/src/test/resources/results/TestQueryOnSelfDescTable/testCrossJoin.result
+++ b/tajo-core-tests/src/test/resources/results/TestQueryOnSelfDescTable/testCrossJoin.result
@@ -5,18 +5,30 @@
 0,1,ven requests. deposits breach a
 0,2, unusual accounts. eve
 0,2,ly final dependencies: slyly bold 
+0,null,for null test
+0,null,for null test2
+0,null,for null test3
 19,1,egular courts above the
 19,1,ongside of the furiously brave acco
 19,1,ven requests. deposits breach a
 19,2, unusual accounts. eve
 19,2,ly final dependencies: slyly bold 
+19,null,for null test
+19,null,for null test2
+19,null,for null test3
 647,1,egular courts above the
 647,1,ongside of the furiously brave acco
 647,1,ven requests. deposits breach a
 647,2, unusual accounts. eve
 647,2,ly final dependencies: slyly bold 
+647,null,for null test
+647,null,for null test2
+647,null,for null test3
 8,1,egular courts above the
 8,1,ongside of the furiously brave acco
 8,1,ven requests. deposits breach a
 8,2, unusual accounts. eve
 8,2,ly final dependencies: slyly bold 
+8,null,for null test
+8,null,for null test2
+8,null,for null test3

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestQueryResult/testTemporalResultOnClose.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestQueryResult/testTemporalResultOnClose.result b/tajo-core-tests/src/test/resources/results/TestQueryResult/testTemporalResultOnClose.result
index 1378536..14fc054 100644
--- a/tajo-core-tests/src/test/resources/results/TestQueryResult/testTemporalResultOnClose.result
+++ b/tajo-core-tests/src/test/resources/results/TestQueryResult/testTemporalResultOnClose.result
@@ -4,4 +4,7 @@ l_orderkey,l_partkey
 1,1
 2,2
 3,2
-3,3
\ No newline at end of file
+3,3
+null,null
+null,null
+null,null
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestSelectQuery/testCaseWhen.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestSelectQuery/testCaseWhen.result b/tajo-core-tests/src/test/resources/results/TestSelectQuery/testCaseWhen.result
index 68a5572..7fd1f8d 100644
--- a/tajo-core-tests/src/test/resources/results/TestSelectQuery/testCaseWhen.result
+++ b/tajo-core-tests/src/test/resources/results/TestSelectQuery/testCaseWhen.result
@@ -4,4 +4,7 @@ r_regionkey,cond
 1,one
 2,two
 3,three
-4,four
\ No newline at end of file
+4,four
+null,zero
+null,zero
+null,zero
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestSelectQuery/testCaseWhenWithoutElse.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestSelectQuery/testCaseWhenWithoutElse.result b/tajo-core-tests/src/test/resources/results/TestSelectQuery/testCaseWhenWithoutElse.result
index bde7df8..c4d39ed 100644
--- a/tajo-core-tests/src/test/resources/results/TestSelectQuery/testCaseWhenWithoutElse.result
+++ b/tajo-core-tests/src/test/resources/results/TestSelectQuery/testCaseWhenWithoutElse.result
@@ -4,4 +4,7 @@ r_regionkey,cond
 1,11
 2,12
 3,13
-4,14
\ No newline at end of file
+4,14
+null,null
+null,null
+null,null
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestSelectQuery/testDatabaseRef.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestSelectQuery/testDatabaseRef.result b/tajo-core-tests/src/test/resources/results/TestSelectQuery/testDatabaseRef.result
index 337de32..3c2104a 100644
--- a/tajo-core-tests/src/test/resources/results/TestSelectQuery/testDatabaseRef.result
+++ b/tajo-core-tests/src/test/resources/results/TestSelectQuery/testDatabaseRef.result
@@ -4,4 +4,7 @@ l_orderkey
 1
 2
 3
-3
\ No newline at end of file
+3
+null
+null
+null
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestSelectQuery/testNonQualifiedNames.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestSelectQuery/testNonQualifiedNames.result b/tajo-core-tests/src/test/resources/results/TestSelectQuery/testNonQualifiedNames.result
index 1378536..14fc054 100644
--- a/tajo-core-tests/src/test/resources/results/TestSelectQuery/testNonQualifiedNames.result
+++ b/tajo-core-tests/src/test/resources/results/TestSelectQuery/testNonQualifiedNames.result
@@ -4,4 +4,7 @@ l_orderkey,l_partkey
 1,1
 2,2
 3,2
-3,3
\ No newline at end of file
+3,3
+null,null
+null,null
+null,null
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelect.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelect.result b/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelect.result
index 1378536..14fc054 100644
--- a/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelect.result
+++ b/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelect.result
@@ -4,4 +4,7 @@ l_orderkey,l_partkey
 1,1
 2,2
 3,2
-3,3
\ No newline at end of file
+3,3
+null,null
+null,null
+null,null
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelect2.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelect2.result b/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelect2.result
index 934c2c8..9669d2a 100644
--- a/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelect2.result
+++ b/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelect2.result
@@ -4,4 +4,7 @@ l_orderkey,l_partkey,plus
 1,1,2
 2,2,4
 3,2,5
-3,3,6
\ No newline at end of file
+3,3,6
+null,null,null
+null,null,null
+null,null,null
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelect3.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelect3.result b/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelect3.result
index 1530637..43a43ca 100644
--- a/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelect3.result
+++ b/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelect3.result
@@ -4,4 +4,7 @@ plus
 2
 4
 5
-6
\ No newline at end of file
+6
+null
+null
+null
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelectAsterisk1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelectAsterisk1.result b/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelectAsterisk1.result
index ec6b911..02f2c9b 100644
--- a/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelectAsterisk1.result
+++ b/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelectAsterisk1.result
@@ -4,4 +4,7 @@ l_orderkey,l_partkey,l_suppkey,l_linenumber,l_quantity,l_extendedprice,l_discoun
 1,1,7311,2,36.0,45983.16,0.09,0.06,N,O,1996-04-12,1996-02-28,1996-04-20,TAKE BACK RETURN,MAIL,ly final dependencies: slyly bold 
 2,2,1191,1,38.0,44694.46,0.0,0.05,N,O,1997-01-28,1997-01-14,1997-02-02,TAKE BACK RETURN,RAIL,ven requests. deposits breach a
 3,2,1798,1,45.0,54058.05,0.06,0.0,R,F,1994-02-02,1994-01-04,1994-02-23,NONE,AIR,ongside of the furiously brave acco
-3,3,6540,2,49.0,46796.47,0.1,0.0,R,F,1993-11-09,1993-12-20,1993-11-24,TAKE BACK RETURN,RAIL, unusual accounts. eve
\ No newline at end of file
+3,3,6540,2,49.0,46796.47,0.1,0.0,R,F,1993-11-09,1993-12-20,1993-11-24,TAKE BACK RETURN,RAIL, unusual accounts. eve
+null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test
+null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test2
+null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test3
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelectAsterisk4.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelectAsterisk4.result b/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelectAsterisk4.result
index 9c6bcb9..78a204d 100644
--- a/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelectAsterisk4.result
+++ b/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelectAsterisk4.result
@@ -4,4 +4,7 @@
 34,4138.4844,1,1,7311,2,36.0,45983.16,0.09,0.06,N,O,1996-04-12,1996-02-28,1996-04-20,TAKE BACK RETURN,MAIL,ly final dependencies: slyly bold ,0.6
 31,0.0,2,2,1191,1,38.0,44694.46,0.0,0.05,N,O,1997-01-28,1997-01-14,1997-02-02,TAKE BACK RETURN,RAIL,ven requests. deposits breach a,0.5
 35,3243.483,3,2,1798,1,45.0,54058.05,0.06,0.0,R,F,1994-02-02,1994-01-04,1994-02-23,NONE,AIR,ongside of the furiously brave acco,0.0
-22,4679.647,3,3,6540,2,49.0,46796.47,0.1,0.0,R,F,1993-11-09,1993-12-20,1993-11-24,TAKE BACK RETURN,RAIL, unusual accounts. eve,0.0
\ No newline at end of file
+22,4679.647,3,3,6540,2,49.0,46796.47,0.1,0.0,R,F,1993-11-09,1993-12-20,1993-11-24,TAKE BACK RETURN,RAIL, unusual accounts. eve,0.0
+13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test,null
+14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test2,null
+14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test3,null
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelectColumnAlias1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelectColumnAlias1.result b/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelectColumnAlias1.result
index eecb82a..d6d7b29 100644
--- a/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelectColumnAlias1.result
+++ b/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelectColumnAlias1.result
@@ -4,4 +4,7 @@ col1,col2
 1,2
 2,3
 3,4
-3,4
\ No newline at end of file
+3,4
+null,null
+null,null
+null,null
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelectColumnAliasExistingInRelation2.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelectColumnAliasExistingInRelation2.result b/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelectColumnAliasExistingInRelation2.result
index f0cf700..c162803 100644
--- a/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelectColumnAliasExistingInRelation2.result
+++ b/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelectColumnAliasExistingInRelation2.result
@@ -4,4 +4,7 @@ l_orderkey
 -3
 -2
 -1
--1
\ No newline at end of file
+-1
+null
+null
+null
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelectDistinct.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelectDistinct.result b/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelectDistinct.result
index 75e7d72..8f208d1 100644
--- a/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelectDistinct.result
+++ b/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSelectDistinct.result
@@ -4,4 +4,5 @@ l_orderkey,l_linenumber
 1,2
 2,1
 3,1
-3,2
\ No newline at end of file
+3,2
+null,null
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSimpleQuery.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSimpleQuery.result b/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSimpleQuery.result
index ec6b911..02f2c9b 100644
--- a/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSimpleQuery.result
+++ b/tajo-core-tests/src/test/resources/results/TestSelectQuery/testSimpleQuery.result
@@ -4,4 +4,7 @@ l_orderkey,l_partkey,l_suppkey,l_linenumber,l_quantity,l_extendedprice,l_discoun
 1,1,7311,2,36.0,45983.16,0.09,0.06,N,O,1996-04-12,1996-02-28,1996-04-20,TAKE BACK RETURN,MAIL,ly final dependencies: slyly bold 
 2,2,1191,1,38.0,44694.46,0.0,0.05,N,O,1997-01-28,1997-01-14,1997-02-02,TAKE BACK RETURN,RAIL,ven requests. deposits breach a
 3,2,1798,1,45.0,54058.05,0.06,0.0,R,F,1994-02-02,1994-01-04,1994-02-23,NONE,AIR,ongside of the furiously brave acco
-3,3,6540,2,49.0,46796.47,0.1,0.0,R,F,1993-11-09,1993-12-20,1993-11-24,TAKE BACK RETURN,RAIL, unusual accounts. eve
\ No newline at end of file
+3,3,6540,2,49.0,46796.47,0.1,0.0,R,F,1993-11-09,1993-12-20,1993-11-24,TAKE BACK RETURN,RAIL, unusual accounts. eve
+null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test
+null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test2
+null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test3
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestSimpleQuery/testNoWhere.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestSimpleQuery/testNoWhere.result b/tajo-core-tests/src/test/resources/results/TestSimpleQuery/testNoWhere.result
index ba5c0ea..a8a1dfc 100644
--- a/tajo-core-tests/src/test/resources/results/TestSimpleQuery/testNoWhere.result
+++ b/tajo-core-tests/src/test/resources/results/TestSimpleQuery/testNoWhere.result
@@ -4,4 +4,7 @@ N,1,1,17.0
 N,1,1,36.0
 N,2,2,38.0
 R,3,2,45.0
-R,3,3,49.0
\ No newline at end of file
+R,3,3,49.0
+null,null,null,null
+null,null,null,null
+null,null,null,null
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestSortQuery/testAsterisk.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestSortQuery/testAsterisk.result b/tajo-core-tests/src/test/resources/results/TestSortQuery/testAsterisk.result
index f2e3c84..7d6643b 100644
--- a/tajo-core-tests/src/test/resources/results/TestSortQuery/testAsterisk.result
+++ b/tajo-core-tests/src/test/resources/results/TestSortQuery/testAsterisk.result
@@ -1,5 +1,8 @@
 l_orderkey,l_partkey,l_suppkey,l_linenumber,l_quantity,l_extendedprice,l_discount,l_tax,l_returnflag,l_linestatus,l_shipdate,l_commitdate,l_receiptdate,l_shipinstruct,l_shipmode,l_comment,len_comment
 -------------------------------
+null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test,13
+null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test2,14
+null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test3,14
 3,3,6540,2,49.0,46796.47,0.1,0.0,R,F,1993-11-09,1993-12-20,1993-11-24,TAKE BACK RETURN,RAIL, unusual accounts. eve,22
 1,1,7706,1,17.0,21168.23,0.04,0.02,N,O,1996-03-13,1996-02-12,1996-03-22,DELIVER IN PERSON,TRUCK,egular courts above the,23
 2,2,1191,1,38.0,44694.46,0.0,0.05,N,O,1997-01-28,1997-01-14,1997-02-02,TAKE BACK RETURN,RAIL,ven requests. deposits breach a,31

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestSortQuery/testSort.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestSortQuery/testSort.result b/tajo-core-tests/src/test/resources/results/TestSortQuery/testSort.result
index a5e9af3..6e662f5 100644
--- a/tajo-core-tests/src/test/resources/results/TestSortQuery/testSort.result
+++ b/tajo-core-tests/src/test/resources/results/TestSortQuery/testSort.result
@@ -4,4 +4,7 @@ l_linenumber,l_orderkey
 2,1
 1,2
 1,3
-2,3
\ No newline at end of file
+2,3
+null,null
+null,null
+null,null
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortAfterGroupby.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortAfterGroupby.result b/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortAfterGroupby.result
index be89a9f..77a769e 100644
--- a/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortAfterGroupby.result
+++ b/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortAfterGroupby.result
@@ -2,4 +2,5 @@ maxq,l_orderkey
 -------------------------------
 36.0,1
 38.0,2
-49.0,3
\ No newline at end of file
+49.0,3
+null,null
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortAfterGroupbyWithAlias.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortAfterGroupbyWithAlias.result b/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortAfterGroupbyWithAlias.result
index bc0bf1b..96860f8 100644
--- a/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortAfterGroupbyWithAlias.result
+++ b/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortAfterGroupbyWithAlias.result
@@ -2,4 +2,5 @@ max_quantity,l_orderkey
 -------------------------------
 36.0,1
 38.0,2
-49.0,3
\ No newline at end of file
+49.0,3
+null,null
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortDesc.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortDesc.result b/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortDesc.result
index 6450adf..889dbe6 100644
--- a/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortDesc.result
+++ b/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortDesc.result
@@ -1,5 +1,8 @@
 l_linenumber,l_orderkey
 -------------------------------
+null,null
+null,null
+null,null
 1,3
 2,3
 1,2

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortWithAlias1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortWithAlias1.result b/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortWithAlias1.result
index 81bb293..e14f042 100644
--- a/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortWithAlias1.result
+++ b/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortWithAlias1.result
@@ -4,4 +4,7 @@ l_linenumber,sortkey
 2,1
 1,2
 1,3
-2,3
\ No newline at end of file
+2,3
+null,null
+null,null
+null,null
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortWithAlias2.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortWithAlias2.result b/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortWithAlias2.result
index 32c93ed..fe5771a 100644
--- a/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortWithAlias2.result
+++ b/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortWithAlias2.result
@@ -2,4 +2,5 @@ l_orderkey,cnt
 -------------------------------
 1,2
 2,1
-3,2
\ No newline at end of file
+3,2
+null,0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortWithAliasButOriginalName.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortWithAliasButOriginalName.result b/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortWithAliasButOriginalName.result
index 81bb293..e14f042 100644
--- a/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortWithAliasButOriginalName.result
+++ b/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortWithAliasButOriginalName.result
@@ -4,4 +4,7 @@ l_linenumber,sortkey
 2,1
 1,2
 1,3
-2,3
\ No newline at end of file
+2,3
+null,null
+null,null
+null,null
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortWithConstKeys.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortWithConstKeys.result b/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortWithConstKeys.result
index bfc709f..1ff1fd9 100644
--- a/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortWithConstKeys.result
+++ b/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortWithConstKeys.result
@@ -4,4 +4,7 @@ l_orderkey,l_linenumber,key1,key2
 1,2,1,2
 2,1,1,2
 3,1,1,2
-3,2,1,2
\ No newline at end of file
+3,2,1,2
+null,null,1,2
+null,null,1,2
+null,null,1,2
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortWithExpr1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortWithExpr1.result b/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortWithExpr1.result
index 81bb293..e14f042 100644
--- a/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortWithExpr1.result
+++ b/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortWithExpr1.result
@@ -4,4 +4,7 @@ l_linenumber,sortkey
 2,1
 1,2
 1,3
-2,3
\ No newline at end of file
+2,3
+null,null
+null,null
+null,null
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortWithExpr2.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortWithExpr2.result b/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortWithExpr2.result
index 0d447c8..2932f6a 100644
--- a/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortWithExpr2.result
+++ b/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortWithExpr2.result
@@ -4,4 +4,7 @@ l_linenumber,sortkey
 1,2
 1,3
 2,1
-2,3
\ No newline at end of file
+2,3
+null,null
+null,null
+null,null
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortWithJson.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortWithJson.result b/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortWithJson.result
index bc0bf1b..96860f8 100644
--- a/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortWithJson.result
+++ b/tajo-core-tests/src/test/resources/results/TestSortQuery/testSortWithJson.result
@@ -2,4 +2,5 @@ max_quantity,l_orderkey
 -------------------------------
 36.0,1
 38.0,2
-49.0,3
\ No newline at end of file
+49.0,3
+null,null
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestSortQuery/testSubQuerySortAfterGroupMultiBlocks.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestSortQuery/testSubQuerySortAfterGroupMultiBlocks.result b/tajo-core-tests/src/test/resources/results/TestSortQuery/testSubQuerySortAfterGroupMultiBlocks.result
index 2b63526..932f0ec 100644
--- a/tajo-core-tests/src/test/resources/results/TestSortQuery/testSubQuerySortAfterGroupMultiBlocks.result
+++ b/tajo-core-tests/src/test/resources/results/TestSortQuery/testSubQuerySortAfterGroupMultiBlocks.result
@@ -3,3 +3,4 @@ l_orderkey,revenue
 1,4985.2136
 2,0.0
 3,7923.13
+null,null

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestSortQuery/testTopK.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestSortQuery/testTopK.result b/tajo-core-tests/src/test/resources/results/TestSortQuery/testTopK.result
index df40678..17e199c 100644
--- a/tajo-core-tests/src/test/resources/results/TestSortQuery/testTopK.result
+++ b/tajo-core-tests/src/test/resources/results/TestSortQuery/testTopK.result
@@ -1,5 +1,7 @@
 l_orderkey,l_linenumber
 -------------------------------
+null,null
+null,null
+null,null
 3,1
-3,2
-2,1
\ No newline at end of file
+3,2
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestSortQuery/testTopkWithJson.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestSortQuery/testTopkWithJson.result b/tajo-core-tests/src/test/resources/results/TestSortQuery/testTopkWithJson.result
index df40678..17e199c 100644
--- a/tajo-core-tests/src/test/resources/results/TestSortQuery/testTopkWithJson.result
+++ b/tajo-core-tests/src/test/resources/results/TestSortQuery/testTopkWithJson.result
@@ -1,5 +1,7 @@
 l_orderkey,l_linenumber
 -------------------------------
+null,null
+null,null
+null,null
 3,1
-3,2
-2,1
\ No newline at end of file
+3,2
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestTPCH/testQ1OrderBy.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestTPCH/testQ1OrderBy.result b/tajo-core-tests/src/test/resources/results/TestTPCH/testQ1OrderBy.result
index a34b514..6d74ba8 100644
--- a/tajo-core-tests/src/test/resources/results/TestTPCH/testQ1OrderBy.result
+++ b/tajo-core-tests/src/test/resources/results/TestTPCH/testQ1OrderBy.result
@@ -2,3 +2,4 @@ l_returnflag,l_linestatus,count_order
 -------------------------------
 N,O,3
 R,F,2
+null,null,3

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestTablePartitions/case10.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestTablePartitions/case10.result b/tajo-core-tests/src/test/resources/results/TestTablePartitions/case10.result
index a6be56d..9050b9f 100644
--- a/tajo-core-tests/src/test/resources/results/TestTablePartitions/case10.result
+++ b/tajo-core-tests/src/test/resources/results/TestTablePartitions/case10.result
@@ -4,4 +4,7 @@ col1,key,res
 1,36.0,-36.0
 2,38.0,-38.0
 3,45.0,-45.0
-3,49.0,-49.0
\ No newline at end of file
+3,49.0,-49.0
+null,null,null
+null,null,null
+null,null,null
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestTablePartitions/case11.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestTablePartitions/case11.result b/tajo-core-tests/src/test/resources/results/TestTablePartitions/case11.result
index 95750fd..31ea549 100644
--- a/tajo-core-tests/src/test/resources/results/TestTablePartitions/case11.result
+++ b/tajo-core-tests/src/test/resources/results/TestTablePartitions/case11.result
@@ -4,4 +4,7 @@ key_alias
 36.0
 38.0
 45.0
-49.0
\ No newline at end of file
+49.0
+null
+null
+null
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestTablePartitions/case12.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestTablePartitions/case12.result b/tajo-core-tests/src/test/resources/results/TestTablePartitions/case12.result
index ac0f9b7..b988915 100644
--- a/tajo-core-tests/src/test/resources/results/TestTablePartitions/case12.result
+++ b/tajo-core-tests/src/test/resources/results/TestTablePartitions/case12.result
@@ -1,5 +1,6 @@
 key_alias,cnt
 -------------------------------
+null,3
 49.0,1
 45.0,1
 38.0,1

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestTablePartitions/case13.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestTablePartitions/case13.result b/tajo-core-tests/src/test/resources/results/TestTablePartitions/case13.result
index 5c92e79..fcabebc 100644
--- a/tajo-core-tests/src/test/resources/results/TestTablePartitions/case13.result
+++ b/tajo-core-tests/src/test/resources/results/TestTablePartitions/case13.result
@@ -1,5 +1,6 @@
 key,cnt
 -------------------------------
+null,3
 49.0,1
 45.0,1
 38.0,1

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestTablePartitions/case4.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestTablePartitions/case4.result b/tajo-core-tests/src/test/resources/results/TestTablePartitions/case4.result
index bcf2197..88d7b15 100644
--- a/tajo-core-tests/src/test/resources/results/TestTablePartitions/case4.result
+++ b/tajo-core-tests/src/test/resources/results/TestTablePartitions/case4.result
@@ -4,4 +4,7 @@
 1296.0
 1444.0
 2025.0
-2401.0
\ No newline at end of file
+2401.0
+null
+null
+null
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestTablePartitions/case5.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestTablePartitions/case5.result b/tajo-core-tests/src/test/resources/results/TestTablePartitions/case5.result
index 2c2918d..1f38c92 100644
--- a/tajo-core-tests/src/test/resources/results/TestTablePartitions/case5.result
+++ b/tajo-core-tests/src/test/resources/results/TestTablePartitions/case5.result
@@ -4,4 +4,7 @@
 1369
 1521
 2116
-2500
\ No newline at end of file
+2500
+null
+null
+null
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestTablePartitions/case6.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestTablePartitions/case6.result b/tajo-core-tests/src/test/resources/results/TestTablePartitions/case6.result
index 3c49070..4ec9438 100644
--- a/tajo-core-tests/src/test/resources/results/TestTablePartitions/case6.result
+++ b/tajo-core-tests/src/test/resources/results/TestTablePartitions/case6.result
@@ -1,5 +1,8 @@
 col1,key
 -------------------------------
+null,null
+null,null
+null,null
 3,49.0
 3,45.0
 2,38.0

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestTablePartitions/case8.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestTablePartitions/case8.result b/tajo-core-tests/src/test/resources/results/TestTablePartitions/case8.result
index cb51cd6..668497e 100644
--- a/tajo-core-tests/src/test/resources/results/TestTablePartitions/case8.result
+++ b/tajo-core-tests/src/test/resources/results/TestTablePartitions/case8.result
@@ -4,4 +4,7 @@ col1,?casewhen
 1,36.0
 2,38.0
 3,45.0
-3,49.0
\ No newline at end of file
+3,49.0
+null,null
+null,null
+null,null
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestTablePartitions/case9.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestTablePartitions/case9.result b/tajo-core-tests/src/test/resources/results/TestTablePartitions/case9.result
index ebfaad2..49c80fe 100644
--- a/tajo-core-tests/src/test/resources/results/TestTablePartitions/case9.result
+++ b/tajo-core-tests/src/test/resources/results/TestTablePartitions/case9.result
@@ -4,4 +4,7 @@ col1,?cast
 1,36
 2,38
 3,45
-3,49
\ No newline at end of file
+3,49
+null,null
+null,null
+null,null
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestTablePartitions/testColumnPartitionedTableWithSmallerExpressions5.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestTablePartitions/testColumnPartitionedTableWithSmallerExpressions5.result b/tajo-core-tests/src/test/resources/results/TestTablePartitions/testColumnPartitionedTableWithSmallerExpressions5.result
index f972753..33b689e 100644
--- a/tajo-core-tests/src/test/resources/results/TestTablePartitions/testColumnPartitionedTableWithSmallerExpressions5.result
+++ b/tajo-core-tests/src/test/resources/results/TestTablePartitions/testColumnPartitionedTableWithSmallerExpressions5.result
@@ -1,7 +1,10 @@
 col1,col2
 -------------------------------
-N,__TAJO_DEFAULT_PARTITION__
-N,__TAJO_DEFAULT_PARTITION__
-N,__TAJO_DEFAULT_PARTITION__
-R,__TAJO_DEFAULT_PARTITION__
-R,__TAJO_DEFAULT_PARTITION__
\ No newline at end of file
+N,null
+N,null
+N,null
+R,null
+R,null
+null,null
+null,null
+null,null
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestTablePartitions/testColumnPartitionedTableWithSmallerExpressions6.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestTablePartitions/testColumnPartitionedTableWithSmallerExpressions6.result b/tajo-core-tests/src/test/resources/results/TestTablePartitions/testColumnPartitionedTableWithSmallerExpressions6.result
index 6b8e2f1..07e3756 100644
--- a/tajo-core-tests/src/test/resources/results/TestTablePartitions/testColumnPartitionedTableWithSmallerExpressions6.result
+++ b/tajo-core-tests/src/test/resources/results/TestTablePartitions/testColumnPartitionedTableWithSmallerExpressions6.result
@@ -1,4 +1,4 @@
 col1,col2
 -------------------------------
-N,__TAJO_DEFAULT_PARTITION__
-N,__TAJO_DEFAULT_PARTITION__
\ No newline at end of file
+N,null
+N,null
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestTableSubQuery/testTableSubquery1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestTableSubQuery/testTableSubquery1.result b/tajo-core-tests/src/test/resources/results/TestTableSubQuery/testTableSubquery1.result
index 337de32..3c2104a 100644
--- a/tajo-core-tests/src/test/resources/results/TestTableSubQuery/testTableSubquery1.result
+++ b/tajo-core-tests/src/test/resources/results/TestTableSubQuery/testTableSubquery1.result
@@ -4,4 +4,7 @@ l_orderkey
 1
 2
 3
-3
\ No newline at end of file
+3
+null
+null
+null
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestTajoCli/testDescTable1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestTajoCli/testDescTable1.result b/tajo-core-tests/src/test/resources/results/TestTajoCli/testDescTable1.result
index 093c4d9..5d9af41 100644
--- a/tajo-core-tests/src/test/resources/results/TestTajoCli/testDescTable1.result
+++ b/tajo-core-tests/src/test/resources/results/TestTajoCli/testDescTable1.result
@@ -7,6 +7,7 @@ number of rows: 0
 volume: 0 B
 Options:
 	'timezone'='${table.timezone}'
+	'text.null'='\\N'
 	'text.delimiter'='|'
 
 schema: 
@@ -22,6 +23,7 @@ number of rows: 0
 volume: 0 B
 Options:
 	'timezone'='${table.timezone}'
+	'text.null'='\\N'
 	'text.delimiter'='|'
 
 schema: 

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestTajoCli/testDescTable2.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestTajoCli/testDescTable2.result b/tajo-core-tests/src/test/resources/results/TestTajoCli/testDescTable2.result
index 9c0abbf..00fd8a1 100644
--- a/tajo-core-tests/src/test/resources/results/TestTajoCli/testDescTable2.result
+++ b/tajo-core-tests/src/test/resources/results/TestTajoCli/testDescTable2.result
@@ -7,6 +7,7 @@ number of rows: 0
 volume: 0 B
 Options:
 	'timezone'='${table.timezone}'
+	'text.null'='\\N'
 	'text.delimiter'='|'
 
 schema: 
@@ -22,6 +23,7 @@ number of rows: 0
 volume: 0 B
 Options:
 	'timezone'='${table.timezone}'
+	'text.null'='\\N'
 	'text.delimiter'='|'
 
 schema: 

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestTajoCli/testDescTableForNestedSchema.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestTajoCli/testDescTableForNestedSchema.result b/tajo-core-tests/src/test/resources/results/TestTajoCli/testDescTableForNestedSchema.result
index 31481f1..1d5d7f0 100644
--- a/tajo-core-tests/src/test/resources/results/TestTajoCli/testDescTableForNestedSchema.result
+++ b/tajo-core-tests/src/test/resources/results/TestTajoCli/testDescTableForNestedSchema.result
@@ -7,6 +7,7 @@ number of rows: 0
 volume: 0 B
 Options:
 	'timezone'='${table.timezone}'
+	'text.null'='\\N'
 	'text.delimiter'='|'
 
 schema: 
@@ -23,6 +24,7 @@ number of rows: 0
 volume: 0 B
 Options:
 	'timezone'='${table.timezone}'
+	'text.null'='\\N'
 	'text.delimiter'='|'
 
 schema: 

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestTajoCli/testSelectResultWithNullFalse.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestTajoCli/testSelectResultWithNullFalse.result b/tajo-core-tests/src/test/resources/results/TestTajoCli/testSelectResultWithNullFalse.result
index 6169092..4e01e4b 100644
--- a/tajo-core-tests/src/test/resources/results/TestTajoCli/testSelectResultWithNullFalse.result
+++ b/tajo-core-tests/src/test/resources/results/TestTajoCli/testSelectResultWithNullFalse.result
@@ -3,6 +3,12 @@ c_custkey,  o_orderkey,  o_orderstatus
 1,  1,  O
 2,  2,  O
 3,  3,  F
-4,  ,  
-5,  ,  
-(5 rows, , 127 B selected)
+4,  testnull,  testnull
+5,  testnull,  testnull
+testnull,  testnull,  testnull
+testnull,  testnull,  testnull
+testnull,  testnull,  testnull
+testnull,  testnull,  testnull
+testnull,  testnull,  testnull
+testnull,  testnull,  testnull
+(11 rows, , 223 B selected)
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestTajoCli/testSelectResultWithNullTrue.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestTajoCli/testSelectResultWithNullTrue.result b/tajo-core-tests/src/test/resources/results/TestTajoCli/testSelectResultWithNullTrue.result
index dfc920b..4e01e4b 100644
--- a/tajo-core-tests/src/test/resources/results/TestTajoCli/testSelectResultWithNullTrue.result
+++ b/tajo-core-tests/src/test/resources/results/TestTajoCli/testSelectResultWithNullTrue.result
@@ -5,4 +5,10 @@ c_custkey,  o_orderkey,  o_orderstatus
 3,  3,  F
 4,  testnull,  testnull
 5,  testnull,  testnull
-(5 rows, , 127 B selected)
+testnull,  testnull,  testnull
+testnull,  testnull,  testnull
+testnull,  testnull,  testnull
+testnull,  testnull,  testnull
+testnull,  testnull,  testnull
+testnull,  testnull,  testnull
+(11 rows, , 223 B selected)
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestTajoCli/testSelectResultWithNullTrueDeprecated.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestTajoCli/testSelectResultWithNullTrueDeprecated.result b/tajo-core-tests/src/test/resources/results/TestTajoCli/testSelectResultWithNullTrueDeprecated.result
index 302d80c..4e01e4b 100644
--- a/tajo-core-tests/src/test/resources/results/TestTajoCli/testSelectResultWithNullTrueDeprecated.result
+++ b/tajo-core-tests/src/test/resources/results/TestTajoCli/testSelectResultWithNullTrueDeprecated.result
@@ -5,4 +5,10 @@ c_custkey,  o_orderkey,  o_orderstatus
 3,  3,  F
 4,  testnull,  testnull
 5,  testnull,  testnull
-(5 rows, , 127 B selected)
\ No newline at end of file
+testnull,  testnull,  testnull
+testnull,  testnull,  testnull
+testnull,  testnull,  testnull
+testnull,  testnull,  testnull
+testnull,  testnull,  testnull
+testnull,  testnull,  testnull
+(11 rows, , 223 B selected)
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestTajoCli/testStopWhenError.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestTajoCli/testStopWhenError.result b/tajo-core-tests/src/test/resources/results/TestTajoCli/testStopWhenError.result
index d480b2b..f3977d5 100644
--- a/tajo-core-tests/src/test/resources/results/TestTajoCli/testStopWhenError.result
+++ b/tajo-core-tests/src/test/resources/results/TestTajoCli/testStopWhenError.result
@@ -1,4 +1,4 @@
 ?count
 -------------------------------
-5
+8
 (1 rows, , 16 B selected)
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestTajoCli/testStopWhenErrorDeprecated.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestTajoCli/testStopWhenErrorDeprecated.result b/tajo-core-tests/src/test/resources/results/TestTajoCli/testStopWhenErrorDeprecated.result
index d480b2b..f3977d5 100644
--- a/tajo-core-tests/src/test/resources/results/TestTajoCli/testStopWhenErrorDeprecated.result
+++ b/tajo-core-tests/src/test/resources/results/TestTajoCli/testStopWhenErrorDeprecated.result
@@ -1,4 +1,4 @@
 ?count
 -------------------------------
-5
+8
 (1 rows, , 16 B selected)
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestTajoClientV2/testExecuteQueryType1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestTajoClientV2/testExecuteQueryType1.result b/tajo-core-tests/src/test/resources/results/TestTajoClientV2/testExecuteQueryType1.result
index ec6b911..02f2c9b 100644
--- a/tajo-core-tests/src/test/resources/results/TestTajoClientV2/testExecuteQueryType1.result
+++ b/tajo-core-tests/src/test/resources/results/TestTajoClientV2/testExecuteQueryType1.result
@@ -4,4 +4,7 @@ l_orderkey,l_partkey,l_suppkey,l_linenumber,l_quantity,l_extendedprice,l_discoun
 1,1,7311,2,36.0,45983.16,0.09,0.06,N,O,1996-04-12,1996-02-28,1996-04-20,TAKE BACK RETURN,MAIL,ly final dependencies: slyly bold 
 2,2,1191,1,38.0,44694.46,0.0,0.05,N,O,1997-01-28,1997-01-14,1997-02-02,TAKE BACK RETURN,RAIL,ven requests. deposits breach a
 3,2,1798,1,45.0,54058.05,0.06,0.0,R,F,1994-02-02,1994-01-04,1994-02-23,NONE,AIR,ongside of the furiously brave acco
-3,3,6540,2,49.0,46796.47,0.1,0.0,R,F,1993-11-09,1993-12-20,1993-11-24,TAKE BACK RETURN,RAIL, unusual accounts. eve
\ No newline at end of file
+3,3,6540,2,49.0,46796.47,0.1,0.0,R,F,1993-11-09,1993-12-20,1993-11-24,TAKE BACK RETURN,RAIL, unusual accounts. eve
+null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test
+null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test2
+null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test3
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestTajoDump/testDump1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestTajoDump/testDump1.result b/tajo-core-tests/src/test/resources/results/TestTajoDump/testDump1.result
index 328b852..741ec4f 100644
--- a/tajo-core-tests/src/test/resources/results/TestTajoDump/testDump1.result
+++ b/tajo-core-tests/src/test/resources/results/TestTajoDump/testDump1.result
@@ -12,5 +12,5 @@ CREATE DATABASE IF NOT EXISTS "TestTajoDump";
 --
 -- Name: "TestTajoDump"."TableName1"; Type: TABLE; Storage: TEXT
 --
-CREATE TABLE "TestTajoDump"."TableName1" ("Age" INT4, "FirstName" TEXT, lastname TEXT) USING TEXT WITH ('text.delimiter'='|', 'timezone'='${table.timezone}');
+CREATE TABLE "TestTajoDump"."TableName1" ("Age" INT4, "FirstName" TEXT, lastname TEXT) USING TEXT WITH ('text.delimiter'='|', 'text.null'='\\N', 'timezone'='${table.timezone}');
 

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestTajoDump/testDump2.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestTajoDump/testDump2.result b/tajo-core-tests/src/test/resources/results/TestTajoDump/testDump2.result
index d84e830..690e8aa 100644
--- a/tajo-core-tests/src/test/resources/results/TestTajoDump/testDump2.result
+++ b/tajo-core-tests/src/test/resources/results/TestTajoDump/testDump2.result
@@ -12,5 +12,5 @@ CREATE DATABASE IF NOT EXISTS "TestTajoDump";
 --
 -- Name: "TestTajoDump"."TableName2"; Type: TABLE; Storage: TEXT
 --
-CREATE TABLE "TestTajoDump"."TableName2" ("Age" INT4, "Name" RECORD ("FirstName" TEXT, lastname TEXT)) USING TEXT WITH ('text.delimiter'='|', 'timezone'='${table.timezone}');
+CREATE TABLE "TestTajoDump"."TableName2" ("Age" INT4, "Name" RECORD ("FirstName" TEXT, lastname TEXT)) USING TEXT WITH ('text.delimiter'='|', 'text.null'='\\N', 'timezone'='${table.timezone}');
 

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestTajoDump/testDump3.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestTajoDump/testDump3.result b/tajo-core-tests/src/test/resources/results/TestTajoDump/testDump3.result
index b3cd13f..e99050d 100644
--- a/tajo-core-tests/src/test/resources/results/TestTajoDump/testDump3.result
+++ b/tajo-core-tests/src/test/resources/results/TestTajoDump/testDump3.result
@@ -12,7 +12,7 @@ CREATE DATABASE IF NOT EXISTS "TestTajoDump";
 --
 -- Name: "TestTajoDump"."TableName1"; Type: TABLE; Storage: TEXT
 --
-CREATE TABLE "TestTajoDump"."TableName1" ("Age" INT4, "FirstName" TEXT, lastname TEXT) USING TEXT WITH ('text.delimiter'='|', 'timezone'='${table.timezone}');
+CREATE TABLE "TestTajoDump"."TableName1" ("Age" INT4, "FirstName" TEXT, lastname TEXT) USING TEXT WITH ('text.delimiter'='|', 'text.null'='\\N', 'timezone'='${table.timezone}');
 
 --
 -- Name: test_idx; Type: INDEX; Index Method: TWO_LEVEL_BIN_TREE

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestTajoDump/testPartitionsDump.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestTajoDump/testPartitionsDump.result b/tajo-core-tests/src/test/resources/results/TestTajoDump/testPartitionsDump.result
index 1dacb01..ddd3cab 100644
--- a/tajo-core-tests/src/test/resources/results/TestTajoDump/testPartitionsDump.result
+++ b/tajo-core-tests/src/test/resources/results/TestTajoDump/testPartitionsDump.result
@@ -12,7 +12,7 @@ CREATE DATABASE IF NOT EXISTS "TestTajoDump";
 --
 -- Name: "TestTajoDump"."TableName3"; Type: TABLE; Storage: TEXT
 --
-CREATE TABLE "TestTajoDump"."TableName3" (col1 INT4, col2 INT4) USING TEXT WITH ('text.delimiter'='|', 'timezone'='${table.timezone}') PARTITION BY COLUMN(col3 INT4, col4 INT4);
+CREATE TABLE "TestTajoDump"."TableName3" (col1 INT4, col2 INT4) USING TEXT WITH ('text.delimiter'='|', 'text.null'='\\N', 'timezone'='${table.timezone}') PARTITION BY COLUMN(col3 INT4, col4 INT4);
 
 --
 -- Table Partitions: TableName3
@@ -25,7 +25,7 @@ CREATE TABLE "TestTajoDump"."TableName3" (col1 INT4, col2 INT4) USING TEXT WITH
 --
 -- Name: "TestTajoDump"."TableName4"; Type: TABLE; Storage: TEXT
 --
-CREATE TABLE "TestTajoDump"."TableName4" (col1 INT4, col2 INT4) USING TEXT WITH ('text.delimiter'='|', 'timezone'='${table.timezone}') PARTITION BY COLUMN(col3 TEXT, col4 DATE);
+CREATE TABLE "TestTajoDump"."TableName4" (col1 INT4, col2 INT4) USING TEXT WITH ('text.delimiter'='|', 'text.null'='\\N', 'timezone'='${table.timezone}') PARTITION BY COLUMN(col3 TEXT, col4 DATE);
 
 --
 -- Table Partitions: TableName4

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestUnionQuery/testTajo1368Case2.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestUnionQuery/testTajo1368Case2.result b/tajo-core-tests/src/test/resources/results/TestUnionQuery/testTajo1368Case2.result
index 17f8c54..75b53c6 100644
--- a/tajo-core-tests/src/test/resources/results/TestUnionQuery/testTajo1368Case2.result
+++ b/tajo-core-tests/src/test/resources/results/TestUnionQuery/testTajo1368Case2.result
@@ -5,8 +5,14 @@ c_custkey,c_nationkey
 3,1
 4,4
 5,3
+null,null
+null,null
+null,null
 1,15
 2,13
 3,1
 4,4
 5,3
+null,null
+null,null
+null,null

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestUnionQuery/testThreeJoinInUnion.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestUnionQuery/testThreeJoinInUnion.result b/tajo-core-tests/src/test/resources/results/TestUnionQuery/testThreeJoinInUnion.result
index 28fe466..a23ac9f 100644
--- a/tajo-core-tests/src/test/resources/results/TestUnionQuery/testThreeJoinInUnion.result
+++ b/tajo-core-tests/src/test/resources/results/TestUnionQuery/testThreeJoinInUnion.result
@@ -30,3 +30,6 @@ o_orderkey
 22
 23
 24
+null
+null
+null

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnion1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnion1.result b/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnion1.result
index e748798..64d76c1 100644
--- a/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnion1.result
+++ b/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnion1.result
@@ -5,3 +5,4 @@ num
 3
 4
 5
+null

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnion13.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnion13.result b/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnion13.result
index 4a4a2ad..a1d8c7b 100644
--- a/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnion13.result
+++ b/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnion13.result
@@ -5,3 +5,4 @@ PROMO BURNISHED COPPER,90100.0,1993goldenrod lavender spring chocolate lace
 LARGE BRUSHED BRASS,90200.0,1993blush thistle blue yellow saddle
 STANDARD POLISHED BRASS,90300.0,1993spring green yellow purple cornsilk
 SMALL PLATED BRASS,90400.0,1993cornflower chocolate smoke green pink
+null,null,1993

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnion14.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnion14.result b/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnion14.result
index bde5eb1..c399c64 100644
--- a/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnion14.result
+++ b/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnion14.result
@@ -7,3 +7,4 @@ col1,cnt
 4,5
 N,3
 R,2
+null,3

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnion2.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnion2.result b/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnion2.result
index 80d5d1c..898ac16 100644
--- a/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnion2.result
+++ b/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnion2.result
@@ -3,3 +3,4 @@ l_orderkey
 1
 2
 3
+null

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnion3.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnion3.result b/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnion3.result
index 9df1273..0dfa9f7 100644
--- a/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnion3.result
+++ b/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnion3.result
@@ -1,4 +1,4 @@
 total
 -------------------------------
-3
-5
+6
+8

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnion6.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnion6.result b/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnion6.result
index 7044801..5822701 100644
--- a/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnion6.result
+++ b/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnion6.result
@@ -1,3 +1,3 @@
 ?count
 -------------------------------
-5
+8

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnion7.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnion7.result b/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnion7.result
index d2c94c7..717c258 100644
--- a/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnion7.result
+++ b/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnion7.result
@@ -3,3 +3,4 @@ orderkey
 1
 2
 3
+null

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAll1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAll1.result b/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAll1.result
index a8ca9a8..38e13a7 100644
--- a/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAll1.result
+++ b/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAll1.result
@@ -8,3 +8,9 @@ num
 4
 4
 5
+null
+null
+null
+null
+null
+null

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAll13.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAll13.result b/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAll13.result
index 4a4a2ad..d711a1e 100644
--- a/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAll13.result
+++ b/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAll13.result
@@ -5,3 +5,6 @@ PROMO BURNISHED COPPER,90100.0,1993goldenrod lavender spring chocolate lace
 LARGE BRUSHED BRASS,90200.0,1993blush thistle blue yellow saddle
 STANDARD POLISHED BRASS,90300.0,1993spring green yellow purple cornsilk
 SMALL PLATED BRASS,90400.0,1993cornflower chocolate smoke green pink
+null,null,1993
+null,null,1993
+null,null,1993

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAll14.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAll14.result b/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAll14.result
index bde5eb1..21bd9c7 100644
--- a/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAll14.result
+++ b/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAll14.result
@@ -7,3 +7,5 @@ col1,cnt
 4,5
 N,3
 R,2
+null,3
+null,3

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAll2.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAll2.result b/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAll2.result
index 966974a..d2ae8fa 100644
--- a/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAll2.result
+++ b/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAll2.result
@@ -10,3 +10,9 @@ l_orderkey
 3
 3
 3
+null
+null
+null
+null
+null
+null

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAll3.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAll3.result b/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAll3.result
index 9df1273..0dfa9f7 100644
--- a/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAll3.result
+++ b/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAll3.result
@@ -1,4 +1,4 @@
 total
 -------------------------------
-3
-5
+6
+8

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAll6.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAll6.result b/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAll6.result
index b6b8744..4438bbc 100644
--- a/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAll6.result
+++ b/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAll6.result
@@ -1,3 +1,3 @@
 ?count
 -------------------------------
-10
+16

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAll7.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAll7.result b/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAll7.result
index 1566a65..c0025b9 100644
--- a/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAll7.result
+++ b/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAll7.result
@@ -10,3 +10,9 @@ orderkey
 3
 3
 3
+null
+null
+null
+null
+null
+null

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAllWithSameAliasNames.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAllWithSameAliasNames.result b/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAllWithSameAliasNames.result
index 966974a..d2ae8fa 100644
--- a/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAllWithSameAliasNames.result
+++ b/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAllWithSameAliasNames.result
@@ -10,3 +10,9 @@ l_orderkey
 3
 3
 3
+null
+null
+null
+null
+null
+null

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionWithCrossJoin.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionWithCrossJoin.result b/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionWithCrossJoin.result
index 551dcb4..c383131 100644
--- a/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionWithCrossJoin.result
+++ b/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionWithCrossJoin.result
@@ -10,21 +10,36 @@ id,c_name,code
 1,Customer#000000004,lineitem
 1,Customer#000000005,lineitem
 1,Customer#000000005,lineitem
+1,null,lineitem
+1,null,lineitem
+1,null,lineitem
+1,null,lineitem
+1,null,lineitem
+1,null,lineitem
 1,Customer#000000001,order
 1,Customer#000000002,order
 1,Customer#000000003,order
 1,Customer#000000004,order
 1,Customer#000000005,order
+1,null,order
+1,null,order
+1,null,order
 2,Customer#000000001,lineitem
 2,Customer#000000002,lineitem
 2,Customer#000000003,lineitem
 2,Customer#000000004,lineitem
 2,Customer#000000005,lineitem
+2,null,lineitem
+2,null,lineitem
+2,null,lineitem
 2,Customer#000000001,order
 2,Customer#000000002,order
 2,Customer#000000003,order
 2,Customer#000000004,order
 2,Customer#000000005,order
+2,null,order
+2,null,order
+2,null,order
 3,Customer#000000001,lineitem
 3,Customer#000000001,lineitem
 3,Customer#000000002,lineitem
@@ -35,8 +50,65 @@ id,c_name,code
 3,Customer#000000004,lineitem
 3,Customer#000000005,lineitem
 3,Customer#000000005,lineitem
+3,null,lineitem
+3,null,lineitem
+3,null,lineitem
+3,null,lineitem
+3,null,lineitem
+3,null,lineitem
 3,Customer#000000001,order
 3,Customer#000000002,order
 3,Customer#000000003,order
 3,Customer#000000004,order
 3,Customer#000000005,order
+3,null,order
+3,null,order
+3,null,order
+null,Customer#000000001,lineitem
+null,Customer#000000001,lineitem
+null,Customer#000000001,lineitem
+null,Customer#000000002,lineitem
+null,Customer#000000002,lineitem
+null,Customer#000000002,lineitem
+null,Customer#000000003,lineitem
+null,Customer#000000003,lineitem
+null,Customer#000000003,lineitem
+null,Customer#000000004,lineitem
+null,Customer#000000004,lineitem
+null,Customer#000000004,lineitem
+null,Customer#000000005,lineitem
+null,Customer#000000005,lineitem
+null,Customer#000000005,lineitem
+null,null,lineitem
+null,null,lineitem
+null,null,lineitem
+null,null,lineitem
+null,null,lineitem
+null,null,lineitem
+null,null,lineitem
+null,null,lineitem
+null,null,lineitem
+null,Customer#000000001,order
+null,Customer#000000001,order
+null,Customer#000000001,order
+null,Customer#000000002,order
+null,Customer#000000002,order
+null,Customer#000000002,order
+null,Customer#000000003,order
+null,Customer#000000003,order
+null,Customer#000000003,order
+null,Customer#000000004,order
+null,Customer#000000004,order
+null,Customer#000000004,order
+null,Customer#000000005,order
+null,Customer#000000005,order
+null,Customer#000000005,order
+null,null,order
+null,null,order
+null,null,order
+null,null,order
+null,null,order
+null,null,order
+null,null,order
+null,null,order
+null,null,order

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionWithSameAliasNames.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionWithSameAliasNames.result b/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionWithSameAliasNames.result
index 80d5d1c..898ac16 100644
--- a/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionWithSameAliasNames.result
+++ b/tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionWithSameAliasNames.result
@@ -3,3 +3,4 @@ l_orderkey
 1
 2
 3
+null

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestWindowQuery/testComplexOrderBy1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestWindowQuery/testComplexOrderBy1.result b/tajo-core-tests/src/test/resources/results/TestWindowQuery/testComplexOrderBy1.result
index 5fc49ee..2c0f6e6 100644
--- a/tajo-core-tests/src/test/resources/results/TestWindowQuery/testComplexOrderBy1.result
+++ b/tajo-core-tests/src/test/resources/results/TestWindowQuery/testComplexOrderBy1.result
@@ -4,4 +4,7 @@ l_orderkey,row_num
 1,2
 2,3
 3,4
-3,5
\ No newline at end of file
+3,5
+null,6
+null,7
+null,8
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestWindowQuery/testFirstValue1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestWindowQuery/testFirstValue1.result b/tajo-core-tests/src/test/resources/results/TestWindowQuery/testFirstValue1.result
index 8ca4ea9..3e1bb51 100644
--- a/tajo-core-tests/src/test/resources/results/TestWindowQuery/testFirstValue1.result
+++ b/tajo-core-tests/src/test/resources/results/TestWindowQuery/testFirstValue1.result
@@ -4,4 +4,7 @@ l_orderkey,shipmode_first,linenumber_first,suppkey_first,shipdate_first,commitda
 1,MAIL,1,7311,1996-03-13,1996-02-12 00:00:00,21168.23,0.04
 2,RAIL,1,1191,1997-01-28,1997-01-14 00:00:00,44694.46,0.0
 3,AIR,1,1798,1993-11-09,1993-12-20 00:00:00,46796.47,0.06
-3,AIR,1,1798,1993-11-09,1993-12-20 00:00:00,46796.47,0.06
\ No newline at end of file
+3,AIR,1,1798,1993-11-09,1993-12-20 00:00:00,46796.47,0.06
+null,null,null,null,null,null,null,null
+null,null,null,null,null,null,null,null
+null,null,null,null,null,null,null,null
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestWindowQuery/testLag1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestWindowQuery/testLag1.result b/tajo-core-tests/src/test/resources/results/TestWindowQuery/testLag1.result
index d64725d..fdba8d2 100644
--- a/tajo-core-tests/src/test/resources/results/TestWindowQuery/testLag1.result
+++ b/tajo-core-tests/src/test/resources/results/TestWindowQuery/testLag1.result
@@ -4,4 +4,7 @@ null,null,null,null,null,null,null,1
 MAIL,2,7311,1996-04-12,1996-02-28 00:00:00,45983.16,0.09,1
 null,null,null,null,null,null,null,2
 null,null,null,null,null,null,null,3
-AIR,1,1798,1994-02-02,1994-01-04 00:00:00,54058.05,0.06,3
\ No newline at end of file
+AIR,1,1798,1994-02-02,1994-01-04 00:00:00,54058.05,0.06,3
+null,null,null,null,null,null,null,null
+null,null,null,null,null,null,null,null
+null,null,null,null,null,null,null,null
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestWindowQuery/testLagWithDefault.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestWindowQuery/testLagWithDefault.result b/tajo-core-tests/src/test/resources/results/TestWindowQuery/testLagWithDefault.result
index 2b10477..da86780 100644
--- a/tajo-core-tests/src/test/resources/results/TestWindowQuery/testLagWithDefault.result
+++ b/tajo-core-tests/src/test/resources/results/TestWindowQuery/testLagWithDefault.result
@@ -4,4 +4,7 @@ default,100,1000,2015-01-01,2015-01-01 12:00:00,1.234,0.11,1
 MAIL,2,7311,1996-04-12,1996-02-28 00:00:00,45983.16,0.09,1
 default,100,1000,2015-01-01,2015-01-01 12:00:00,1.234,0.11,2
 default,100,1000,2015-01-01,2015-01-01 12:00:00,1.234,0.11,3
-AIR,1,1798,1994-02-02,1994-01-04 00:00:00,54058.05,0.06,3
\ No newline at end of file
+AIR,1,1798,1994-02-02,1994-01-04 00:00:00,54058.05,0.06,3
+default,100,1000,2015-01-01,2015-01-01 12:00:00,1.234,0.11,null
+null,null,null,null,null,null,null,null
+null,null,null,null,null,null,null,null
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestWindowQuery/testLagWithNoArgs.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestWindowQuery/testLagWithNoArgs.result b/tajo-core-tests/src/test/resources/results/TestWindowQuery/testLagWithNoArgs.result
index d64725d..fdba8d2 100644
--- a/tajo-core-tests/src/test/resources/results/TestWindowQuery/testLagWithNoArgs.result
+++ b/tajo-core-tests/src/test/resources/results/TestWindowQuery/testLagWithNoArgs.result
@@ -4,4 +4,7 @@ null,null,null,null,null,null,null,1
 MAIL,2,7311,1996-04-12,1996-02-28 00:00:00,45983.16,0.09,1
 null,null,null,null,null,null,null,2
 null,null,null,null,null,null,null,3
-AIR,1,1798,1994-02-02,1994-01-04 00:00:00,54058.05,0.06,3
\ No newline at end of file
+AIR,1,1798,1994-02-02,1994-01-04 00:00:00,54058.05,0.06,3
+null,null,null,null,null,null,null,null
+null,null,null,null,null,null,null,null
+null,null,null,null,null,null,null,null
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestWindowQuery/testLastValue1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestWindowQuery/testLastValue1.result b/tajo-core-tests/src/test/resources/results/TestWindowQuery/testLastValue1.result
index 825f982..b3cdd27 100644
--- a/tajo-core-tests/src/test/resources/results/TestWindowQuery/testLastValue1.result
+++ b/tajo-core-tests/src/test/resources/results/TestWindowQuery/testLastValue1.result
@@ -4,4 +4,7 @@ l_orderkey,shipmode_last,linenumber_last,suppkey_last,shipdate_last,commitdate_l
 1,TRUCK,2,7706,1996-04-12,1996-02-28 00:00:00,45983.16,0.09
 2,RAIL,1,1191,1997-01-28,1997-01-14 00:00:00,44694.46,0.0
 3,RAIL,2,6540,1994-02-02,1994-01-04 00:00:00,54058.05,0.1
-3,RAIL,2,6540,1994-02-02,1994-01-04 00:00:00,54058.05,0.1
\ No newline at end of file
+3,RAIL,2,6540,1994-02-02,1994-01-04 00:00:00,54058.05,0.1
+null,null,null,null,null,null,null,null
+null,null,null,null,null,null,null,null
+null,null,null,null,null,null,null,null
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestWindowQuery/testLead1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestWindowQuery/testLead1.result b/tajo-core-tests/src/test/resources/results/TestWindowQuery/testLead1.result
index a85ead5..267b992 100644
--- a/tajo-core-tests/src/test/resources/results/TestWindowQuery/testLead1.result
+++ b/tajo-core-tests/src/test/resources/results/TestWindowQuery/testLead1.result
@@ -4,4 +4,7 @@ TRUCK,1,7706,1996-03-13,1996-02-12 00:00:00,21168.23,0.04,1
 null,null,null,null,null,null,null,1
 null,null,null,null,null,null,null,2
 RAIL,2,6540,1993-11-09,1993-12-20 00:00:00,46796.47,0.1,3
-null,null,null,null,null,null,null,3
\ No newline at end of file
+null,null,null,null,null,null,null,3
+null,null,null,null,null,null,null,null
+null,null,null,null,null,null,null,null
+null,null,null,null,null,null,null,null
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/14affa59/tajo-core-tests/src/test/resources/results/TestWindowQuery/testLeadWithDefault.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestWindowQuery/testLeadWithDefault.result b/tajo-core-tests/src/test/resources/results/TestWindowQuery/testLeadWithDefault.result
index 8298e44..3f3ccb8 100644
--- a/tajo-core-tests/src/test/resources/results/TestWindowQuery/testLeadWithDefault.result
+++ b/tajo-core-tests/src/test/resources/results/TestWindowQuery/testLeadWithDefault.result
@@ -4,4 +4,7 @@ TRUCK,1,7706,1996-03-13,1996-02-12 00:00:00,21168.23,0.04,1
 default,100,1000,2015-01-01,2015-01-01 12:00:00,1.234,0.11,1
 default,100,1000,2015-01-01,2015-01-01 12:00:00,1.234,0.11,2
 RAIL,2,6540,1993-11-09,1993-12-20 00:00:00,46796.47,0.1,3
-default,100,1000,2015-01-01,2015-01-01 12:00:00,1.234,0.11,3
\ No newline at end of file
+default,100,1000,2015-01-01,2015-01-01 12:00:00,1.234,0.11,3
+null,null,null,null,null,null,null,null
+null,null,null,null,null,null,null,null
+default,100,1000,2015-01-01,2015-01-01 12:00:00,1.234,0.11,null
\ No newline at end of file


Mime
View raw message