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/05/25 16:36:13 UTC
[20/57] [abbrv] tajo git commit: TAJO-1577: Add test cases to verify
join plans. (jihoon)
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinOnPartitionedTables/testPartialFilterPushDown.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinOnPartitionedTables/testPartialFilterPushDown.result b/tajo-core/src/test/resources/results/TestJoinOnPartitionedTables/testPartialFilterPushDown.result
index cc7419e..e510ac8 100644
--- a/tajo-core/src/test/resources/results/TestJoinOnPartitionedTables/testPartialFilterPushDown.result
+++ b/tajo-core/src/test/resources/results/TestJoinOnPartitionedTables/testPartialFilterPushDown.result
@@ -1,3 +1,3 @@
c_name,?count
-------------------------------
-CUSTOMER#000000003,1
\ No newline at end of file
+CUSTOMER#000000003,1
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinOnPartitionedTables/testPartialFilterPushDownOuterJoin.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinOnPartitionedTables/testPartialFilterPushDownOuterJoin.result b/tajo-core/src/test/resources/results/TestJoinOnPartitionedTables/testPartialFilterPushDownOuterJoin.result
index 73150a0..4c58290 100644
--- a/tajo-core/src/test/resources/results/TestJoinOnPartitionedTables/testPartialFilterPushDownOuterJoin.result
+++ b/tajo-core/src/test/resources/results/TestJoinOnPartitionedTables/testPartialFilterPushDownOuterJoin.result
@@ -24,4 +24,4 @@ n_nationkey,n_name,c_custkey,c_nationkey,c_name
21,VIETNAM,null,null,null
22,RUSSIA,null,null,null
23,UNITED KINGDOM,null,null,null
-24,UNITED STATES,null,null,null
\ No newline at end of file
+24,UNITED STATES,null,null,null
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinOnPartitionedTables/testPartialFilterPushDownOuterJoin2.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinOnPartitionedTables/testPartialFilterPushDownOuterJoin2.result b/tajo-core/src/test/resources/results/TestJoinOnPartitionedTables/testPartialFilterPushDownOuterJoin2.result
index 442ac75..d81e058 100644
--- a/tajo-core/src/test/resources/results/TestJoinOnPartitionedTables/testPartialFilterPushDownOuterJoin2.result
+++ b/tajo-core/src/test/resources/results/TestJoinOnPartitionedTables/testPartialFilterPushDownOuterJoin2.result
@@ -24,4 +24,4 @@ n_nationkey,n_name,c_custkey,c_nationkey,c_name
21,VIETNAM,null,null,null
22,RUSSIA,null,null,null
23,UNITED KINGDOM,null,null,null
-24,UNITED STATES,null,null,null
\ No newline at end of file
+24,UNITED STATES,null,null,null
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinOnPartitionedTables/testPartitionMultiplePartitionFilter.1.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinOnPartitionedTables/testPartitionMultiplePartitionFilter.1.result b/tajo-core/src/test/resources/results/TestJoinOnPartitionedTables/testPartitionMultiplePartitionFilter.1.result
new file mode 100644
index 0000000..9f0b5be
--- /dev/null
+++ b/tajo-core/src/test/resources/results/TestJoinOnPartitionedTables/testPartitionMultiplePartitionFilter.1.result
@@ -0,0 +1,2 @@
+c_custkey,c_custkey
+-------------------------------
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinOnPartitionedTables/testPartitionTableJoinSmallTable.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinOnPartitionedTables/testPartitionTableJoinSmallTable.result b/tajo-core/src/test/resources/results/TestJoinOnPartitionedTables/testPartitionTableJoinSmallTable.result
index f28f634..49d7757 100644
--- a/tajo-core/src/test/resources/results/TestJoinOnPartitionedTables/testPartitionTableJoinSmallTable.result
+++ b/tajo-core/src/test/resources/results/TestJoinOnPartitionedTables/testPartitionTableJoinSmallTable.result
@@ -4,4 +4,4 @@ c_custkey,c_name,c_nationkey,n_nationkey
2,Customer#000000002,13,13
3,Customer#000000003,1,1
4,Customer#000000004,4,4
-5,Customer#000000005,3,3
\ No newline at end of file
+5,Customer#000000005,3,3
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinCondition1.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinCondition1.result b/tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinCondition1.result
deleted file mode 100644
index e0691a7..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinCondition1.result
+++ /dev/null
@@ -1,27 +0,0 @@
-n_nationkey,n_name,n_name
--------------------------------
-0,ALGERIA,ALGERIA
-1,ARGENTINA,ARGENTINA
-2,BRAZIL,BRAZIL
-3,CANADA,CANADA
-4,EGYPT,EGYPT
-5,ETHIOPIA,ETHIOPIA
-6,FRANCE,FRANCE
-7,GERMANY,GERMANY
-8,INDIA,INDIA
-9,INDONESIA,INDONESIA
-10,IRAN,IRAN
-11,IRAQ,IRAQ
-12,JAPAN,JAPAN
-13,JORDAN,JORDAN
-14,KENYA,KENYA
-15,MOROCCO,MOROCCO
-16,MOZAMBIQUE,MOZAMBIQUE
-17,PERU,PERU
-18,CHINA,CHINA
-19,ROMANIA,ROMANIA
-20,SAUDI ARABIA,SAUDI ARABIA
-21,VIETNAM,VIETNAM
-22,RUSSIA,RUSSIA
-23,UNITED KINGDOM,UNITED KINGDOM
-24,UNITED STATES,UNITED STATES
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinCondition2.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinCondition2.result b/tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinCondition2.result
deleted file mode 100644
index 63289e1..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinCondition2.result
+++ /dev/null
@@ -1,27 +0,0 @@
-n_nationkey,n_name,name
--------------------------------
-0,ALGERIA,ALGERIA
-1,ARGENTINA,ARGENTINA
-2,BRAZIL,BRAZIL
-3,CANADA,CANADA
-4,EGYPT,EGYPT
-5,ETHIOPIA,ETHIOPIA
-6,FRANCE,FRANCE
-7,GERMANY,GERMANY
-8,INDIA,INDIA
-9,INDONESIA,INDONESIA
-10,IRAN,IRAN
-11,IRAQ,IRAQ
-12,JAPAN,JAPAN
-13,JORDAN,JORDAN
-14,KENYA,KENYA
-15,MOROCCO,MOROCCO
-16,MOZAMBIQUE,MOZAMBIQUE
-17,PERU,PERU
-18,CHINA,CHINA
-19,ROMANIA,ROMANIA
-20,SAUDI ARABIA,SAUDI ARABIA
-21,VIETNAM,VIETNAM
-22,RUSSIA,RUSSIA
-23,UNITED KINGDOM,UNITED KINGDOM
-24,UNITED STATES,UNITED STATES
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinCondition3.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinCondition3.result b/tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinCondition3.result
deleted file mode 100644
index e0691a7..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinCondition3.result
+++ /dev/null
@@ -1,27 +0,0 @@
-n_nationkey,n_name,n_name
--------------------------------
-0,ALGERIA,ALGERIA
-1,ARGENTINA,ARGENTINA
-2,BRAZIL,BRAZIL
-3,CANADA,CANADA
-4,EGYPT,EGYPT
-5,ETHIOPIA,ETHIOPIA
-6,FRANCE,FRANCE
-7,GERMANY,GERMANY
-8,INDIA,INDIA
-9,INDONESIA,INDONESIA
-10,IRAN,IRAN
-11,IRAQ,IRAQ
-12,JAPAN,JAPAN
-13,JORDAN,JORDAN
-14,KENYA,KENYA
-15,MOROCCO,MOROCCO
-16,MOZAMBIQUE,MOZAMBIQUE
-17,PERU,PERU
-18,CHINA,CHINA
-19,ROMANIA,ROMANIA
-20,SAUDI ARABIA,SAUDI ARABIA
-21,VIETNAM,VIETNAM
-22,RUSSIA,RUSSIA
-23,UNITED KINGDOM,UNITED KINGDOM
-24,UNITED STATES,UNITED STATES
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinCondition4.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinCondition4.result b/tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinCondition4.result
deleted file mode 100644
index 325375d..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinCondition4.result
+++ /dev/null
@@ -1,29 +0,0 @@
-n_nationkey,name1,name2
--------------------------------
-0,ALGE,ALGE
-1,ARGE,ARGE
-2,BRAZ,BRAZ
-3,CANA,CANA
-4,EGYP,EGYP
-5,ETHI,ETHI
-6,FRAN,FRAN
-7,GERM,GERM
-8,INDI,INDI
-9,INDO,INDO
-10,IRAN,IRAN
-11,IRAQ,IRAQ
-12,JAPA,JAPA
-13,JORD,JORD
-14,KENY,KENY
-15,MORO,MORO
-16,MOZA,MOZA
-17,PERU,PERU
-18,CHIN,CHIN
-19,ROMA,ROMA
-20,SAUD,SAUD
-21,VIET,VIET
-22,RUSS,RUSS
-23,UNIT,UNIT
-23,UNIT,UNIT
-24,UNIT,UNIT
-24,UNIT,UNIT
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinCondition5.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinCondition5.result b/tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinCondition5.result
deleted file mode 100644
index 325375d..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinCondition5.result
+++ /dev/null
@@ -1,29 +0,0 @@
-n_nationkey,name1,name2
--------------------------------
-0,ALGE,ALGE
-1,ARGE,ARGE
-2,BRAZ,BRAZ
-3,CANA,CANA
-4,EGYP,EGYP
-5,ETHI,ETHI
-6,FRAN,FRAN
-7,GERM,GERM
-8,INDI,INDI
-9,INDO,INDO
-10,IRAN,IRAN
-11,IRAQ,IRAQ
-12,JAPA,JAPA
-13,JORD,JORD
-14,KENY,KENY
-15,MORO,MORO
-16,MOZA,MOZA
-17,PERU,PERU
-18,CHIN,CHIN
-19,ROMA,ROMA
-20,SAUD,SAUD
-21,VIET,VIET
-22,RUSS,RUSS
-23,UNIT,UNIT
-23,UNIT,UNIT
-24,UNIT,UNIT
-24,UNIT,UNIT
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinCondition6.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinCondition6.result b/tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinCondition6.result
deleted file mode 100644
index 82158bc..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinCondition6.result
+++ /dev/null
@@ -1,56 +0,0 @@
-n_nationkey,name1,name2
--------------------------------
-0,ALGE,ALGE
-0,ALGE,ALGE
-1,ARGE,ARGE
-1,ARGE,ARGE
-2,BRAZ,BRAZ
-2,BRAZ,BRAZ
-3,CANA,CANA
-3,CANA,CANA
-4,EGYP,EGYP
-4,EGYP,EGYP
-5,ETHI,ETHI
-5,ETHI,ETHI
-6,FRAN,FRAN
-6,FRAN,FRAN
-7,GERM,GERM
-7,GERM,GERM
-8,INDI,INDI
-8,INDI,INDI
-9,INDO,INDO
-9,INDO,INDO
-10,IRAN,IRAN
-10,IRAN,IRAN
-11,IRAQ,IRAQ
-11,IRAQ,IRAQ
-12,JAPA,JAPA
-12,JAPA,JAPA
-13,JORD,JORD
-13,JORD,JORD
-14,KENY,KENY
-14,KENY,KENY
-15,MORO,MORO
-15,MORO,MORO
-16,MOZA,MOZA
-16,MOZA,MOZA
-17,PERU,PERU
-17,PERU,PERU
-18,CHIN,CHIN
-18,CHIN,CHIN
-19,ROMA,ROMA
-19,ROMA,ROMA
-20,SAUD,SAUD
-20,SAUD,SAUD
-21,VIET,VIET
-21,VIET,VIET
-22,RUSS,RUSS
-22,RUSS,RUSS
-23,UNIT,UNIT
-23,UNIT,UNIT
-23,UNIT,UNIT
-23,UNIT,UNIT
-24,UNIT,UNIT
-24,UNIT,UNIT
-24,UNIT,UNIT
-24,UNIT,UNIT
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinCondition7.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinCondition7.result b/tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinCondition7.result
deleted file mode 100644
index bed2968..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinCondition7.result
+++ /dev/null
@@ -1,56 +0,0 @@
-n_nationkey,n_name,n_name
--------------------------------
-0,ALGERIA,ALGERIA
-0,ALGERIA,ALGERIA
-1,ARGENTINA,ARGENTINA
-1,ARGENTINA,ARGENTINA
-2,BRAZIL,BRAZIL
-2,BRAZIL,BRAZIL
-3,CANADA,CANADA
-3,CANADA,CANADA
-4,EGYPT,EGYPT
-4,EGYPT,EGYPT
-5,ETHIOPIA,ETHIOPIA
-5,ETHIOPIA,ETHIOPIA
-6,FRANCE,FRANCE
-6,FRANCE,FRANCE
-7,GERMANY,GERMANY
-7,GERMANY,GERMANY
-8,INDIA,INDIA
-8,INDIA,INDIA
-9,INDONESIA,INDONESIA
-9,INDONESIA,INDONESIA
-10,IRAN,IRAN
-10,IRAN,IRAN
-11,IRAQ,IRAQ
-11,IRAQ,IRAQ
-12,JAPAN,JAPAN
-12,JAPAN,JAPAN
-13,JORDAN,JORDAN
-13,JORDAN,JORDAN
-14,KENYA,KENYA
-14,KENYA,KENYA
-15,MOROCCO,MOROCCO
-15,MOROCCO,MOROCCO
-16,MOZAMBIQUE,MOZAMBIQUE
-16,MOZAMBIQUE,MOZAMBIQUE
-17,PERU,PERU
-17,PERU,PERU
-18,CHINA,CHINA
-18,CHINA,CHINA
-19,ROMANIA,ROMANIA
-19,ROMANIA,ROMANIA
-20,SAUDI ARABIA,SAUDI ARABIA
-20,SAUDI ARABIA,SAUDI ARABIA
-21,VIETNAM,VIETNAM
-21,VIETNAM,VIETNAM
-22,RUSSIA,RUSSIA
-22,RUSSIA,RUSSIA
-23,UNITED KINGDOM,UNITED KINGDOM
-23,UNITED KINGDOM,UNITED KINGDOM
-23,UNITED KINGDOM,UNITED STATES
-23,UNITED KINGDOM,UNITED STATES
-24,UNITED STATES,UNITED KINGDOM
-24,UNITED STATES,UNITED KINGDOM
-24,UNITED STATES,UNITED STATES
-24,UNITED STATES,UNITED STATES
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinsWithCaseWhen.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinsWithCaseWhen.result b/tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinsWithCaseWhen.result
deleted file mode 100644
index 046a7c1..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinsWithCaseWhen.result
+++ /dev/null
@@ -1,27 +0,0 @@
-r_name,s1
--------------------------------
-AFRICA,N/O
-AFRICA,N/O
-AFRICA,N/O
-AFRICA,Supplier#000000002
-AFRICA,Supplier#000000004
-AMERICA,N/O
-AMERICA,N/O
-AMERICA,N/O
-AMERICA,N/O
-AMERICA,Supplier#000000003
-ASIA,N/O
-ASIA,N/O
-ASIA,N/O
-ASIA,N/O
-ASIA,N/O
-EUROPE,N/O
-EUROPE,N/O
-EUROPE,N/O
-EUROPE,N/O
-EUROPE,N/O
-MIDDLE EAST,N/O
-MIDDLE EAST,N/O
-MIDDLE EAST,N/O
-MIDDLE EAST,N/O
-MIDDLE EAST,N/O
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinsWithCaseWhen2.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinsWithCaseWhen2.result b/tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinsWithCaseWhen2.result
deleted file mode 100644
index 046a7c1..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinsWithCaseWhen2.result
+++ /dev/null
@@ -1,27 +0,0 @@
-r_name,s1
--------------------------------
-AFRICA,N/O
-AFRICA,N/O
-AFRICA,N/O
-AFRICA,Supplier#000000002
-AFRICA,Supplier#000000004
-AMERICA,N/O
-AMERICA,N/O
-AMERICA,N/O
-AMERICA,N/O
-AMERICA,Supplier#000000003
-ASIA,N/O
-ASIA,N/O
-ASIA,N/O
-ASIA,N/O
-ASIA,N/O
-EUROPE,N/O
-EUROPE,N/O
-EUROPE,N/O
-EUROPE,N/O
-EUROPE,N/O
-MIDDLE EAST,N/O
-MIDDLE EAST,N/O
-MIDDLE EAST,N/O
-MIDDLE EAST,N/O
-MIDDLE EAST,N/O
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testCrossJoin.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testCrossJoin.result b/tajo-core/src/test/resources/results/TestJoinQuery/testCrossJoin.result
deleted file mode 100644
index 607adc4..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testCrossJoin.result
+++ /dev/null
@@ -1,127 +0,0 @@
-n_name,r_name,n_regionkey,r_regionkey
--------------------------------
-ALGERIA,AFRICA,0,0
-ALGERIA,AMERICA,0,1
-ALGERIA,ASIA,0,2
-ALGERIA,EUROPE,0,3
-ALGERIA,MIDDLE EAST,0,4
-ARGENTINA,AFRICA,1,0
-ARGENTINA,AMERICA,1,1
-ARGENTINA,ASIA,1,2
-ARGENTINA,EUROPE,1,3
-ARGENTINA,MIDDLE EAST,1,4
-BRAZIL,AFRICA,1,0
-BRAZIL,AMERICA,1,1
-BRAZIL,ASIA,1,2
-BRAZIL,EUROPE,1,3
-BRAZIL,MIDDLE EAST,1,4
-CANADA,AFRICA,1,0
-CANADA,AMERICA,1,1
-CANADA,ASIA,1,2
-CANADA,EUROPE,1,3
-CANADA,MIDDLE EAST,1,4
-CHINA,AFRICA,2,0
-CHINA,AMERICA,2,1
-CHINA,ASIA,2,2
-CHINA,EUROPE,2,3
-CHINA,MIDDLE EAST,2,4
-EGYPT,AFRICA,4,0
-EGYPT,AMERICA,4,1
-EGYPT,ASIA,4,2
-EGYPT,EUROPE,4,3
-EGYPT,MIDDLE EAST,4,4
-ETHIOPIA,AFRICA,0,0
-ETHIOPIA,AMERICA,0,1
-ETHIOPIA,ASIA,0,2
-ETHIOPIA,EUROPE,0,3
-ETHIOPIA,MIDDLE EAST,0,4
-FRANCE,AFRICA,3,0
-FRANCE,AMERICA,3,1
-FRANCE,ASIA,3,2
-FRANCE,EUROPE,3,3
-FRANCE,MIDDLE EAST,3,4
-GERMANY,AFRICA,3,0
-GERMANY,AMERICA,3,1
-GERMANY,ASIA,3,2
-GERMANY,EUROPE,3,3
-GERMANY,MIDDLE EAST,3,4
-INDIA,AFRICA,2,0
-INDIA,AMERICA,2,1
-INDIA,ASIA,2,2
-INDIA,EUROPE,2,3
-INDIA,MIDDLE EAST,2,4
-INDONESIA,AFRICA,2,0
-INDONESIA,AMERICA,2,1
-INDONESIA,ASIA,2,2
-INDONESIA,EUROPE,2,3
-INDONESIA,MIDDLE EAST,2,4
-IRAN,AFRICA,4,0
-IRAN,AMERICA,4,1
-IRAN,ASIA,4,2
-IRAN,EUROPE,4,3
-IRAN,MIDDLE EAST,4,4
-IRAQ,AFRICA,4,0
-IRAQ,AMERICA,4,1
-IRAQ,ASIA,4,2
-IRAQ,EUROPE,4,3
-IRAQ,MIDDLE EAST,4,4
-JAPAN,AFRICA,2,0
-JAPAN,AMERICA,2,1
-JAPAN,ASIA,2,2
-JAPAN,EUROPE,2,3
-JAPAN,MIDDLE EAST,2,4
-JORDAN,AFRICA,4,0
-JORDAN,AMERICA,4,1
-JORDAN,ASIA,4,2
-JORDAN,EUROPE,4,3
-JORDAN,MIDDLE EAST,4,4
-KENYA,AFRICA,0,0
-KENYA,AMERICA,0,1
-KENYA,ASIA,0,2
-KENYA,EUROPE,0,3
-KENYA,MIDDLE EAST,0,4
-MOROCCO,AFRICA,0,0
-MOROCCO,AMERICA,0,1
-MOROCCO,ASIA,0,2
-MOROCCO,EUROPE,0,3
-MOROCCO,MIDDLE EAST,0,4
-MOZAMBIQUE,AFRICA,0,0
-MOZAMBIQUE,AMERICA,0,1
-MOZAMBIQUE,ASIA,0,2
-MOZAMBIQUE,EUROPE,0,3
-MOZAMBIQUE,MIDDLE EAST,0,4
-PERU,AFRICA,1,0
-PERU,AMERICA,1,1
-PERU,ASIA,1,2
-PERU,EUROPE,1,3
-PERU,MIDDLE EAST,1,4
-ROMANIA,AFRICA,3,0
-ROMANIA,AMERICA,3,1
-ROMANIA,ASIA,3,2
-ROMANIA,EUROPE,3,3
-ROMANIA,MIDDLE EAST,3,4
-RUSSIA,AFRICA,3,0
-RUSSIA,AMERICA,3,1
-RUSSIA,ASIA,3,2
-RUSSIA,EUROPE,3,3
-RUSSIA,MIDDLE EAST,3,4
-SAUDI ARABIA,AFRICA,4,0
-SAUDI ARABIA,AMERICA,4,1
-SAUDI ARABIA,ASIA,4,2
-SAUDI ARABIA,EUROPE,4,3
-SAUDI ARABIA,MIDDLE EAST,4,4
-UNITED KINGDOM,AFRICA,3,0
-UNITED KINGDOM,AMERICA,3,1
-UNITED KINGDOM,ASIA,3,2
-UNITED KINGDOM,EUROPE,3,3
-UNITED KINGDOM,MIDDLE EAST,3,4
-UNITED STATES,AFRICA,1,0
-UNITED STATES,AMERICA,1,1
-UNITED STATES,ASIA,1,2
-UNITED STATES,EUROPE,1,3
-UNITED STATES,MIDDLE EAST,1,4
-VIETNAM,AFRICA,2,0
-VIETNAM,AMERICA,2,1
-VIETNAM,ASIA,2,2
-VIETNAM,EUROPE,2,3
-VIETNAM,MIDDLE EAST,2,4
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testCrossJoinWithAsterisk1.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testCrossJoinWithAsterisk1.result b/tajo-core/src/test/resources/results/TestJoinQuery/testCrossJoinWithAsterisk1.result
deleted file mode 100644
index f4e8c88..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testCrossJoinWithAsterisk1.result
+++ /dev/null
@@ -1,27 +0,0 @@
-r_regionkey,r_name,r_comment,c_custkey,c_name,c_address,c_nationkey,c_phone,c_acctbal,c_mktsegment,c_comment
--------------------------------
-0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e
-0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref
-0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov
-0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou
-0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor
-1,AMERICA,hs use ironic, even requests. s,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e
-1,AMERICA,hs use ironic, even requests. s,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref
-1,AMERICA,hs use ironic, even requests. s,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov
-1,AMERICA,hs use ironic, even requests. s,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou
-1,AMERICA,hs use ironic, even requests. s,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor
-2,ASIA,ges. thinly even pinto beans ca,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e
-2,ASIA,ges. thinly even pinto beans ca,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref
-2,ASIA,ges. thinly even pinto beans ca,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov
-2,ASIA,ges. thinly even pinto beans ca,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou
-2,ASIA,ges. thinly even pinto beans ca,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor
-3,EUROPE,ly final courts cajole furiously final excuse,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e
-3,EUROPE,ly final courts cajole furiously final excuse,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref
-3,EUROPE,ly final courts cajole furiously final excuse,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov
-3,EUROPE,ly final courts cajole furiously final excuse,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou
-3,EUROPE,ly final courts cajole furiously final excuse,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor
-4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e
-4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref
-4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov
-4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou
-4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testCrossJoinWithAsterisk2.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testCrossJoinWithAsterisk2.result b/tajo-core/src/test/resources/results/TestJoinQuery/testCrossJoinWithAsterisk2.result
deleted file mode 100644
index f4e8c88..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testCrossJoinWithAsterisk2.result
+++ /dev/null
@@ -1,27 +0,0 @@
-r_regionkey,r_name,r_comment,c_custkey,c_name,c_address,c_nationkey,c_phone,c_acctbal,c_mktsegment,c_comment
--------------------------------
-0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e
-0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref
-0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov
-0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou
-0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor
-1,AMERICA,hs use ironic, even requests. s,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e
-1,AMERICA,hs use ironic, even requests. s,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref
-1,AMERICA,hs use ironic, even requests. s,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov
-1,AMERICA,hs use ironic, even requests. s,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou
-1,AMERICA,hs use ironic, even requests. s,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor
-2,ASIA,ges. thinly even pinto beans ca,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e
-2,ASIA,ges. thinly even pinto beans ca,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref
-2,ASIA,ges. thinly even pinto beans ca,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov
-2,ASIA,ges. thinly even pinto beans ca,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou
-2,ASIA,ges. thinly even pinto beans ca,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor
-3,EUROPE,ly final courts cajole furiously final excuse,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e
-3,EUROPE,ly final courts cajole furiously final excuse,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref
-3,EUROPE,ly final courts cajole furiously final excuse,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov
-3,EUROPE,ly final courts cajole furiously final excuse,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou
-3,EUROPE,ly final courts cajole furiously final excuse,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor
-4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e
-4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref
-4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov
-4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou
-4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testCrossJoinWithAsterisk3.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testCrossJoinWithAsterisk3.result b/tajo-core/src/test/resources/results/TestJoinQuery/testCrossJoinWithAsterisk3.result
deleted file mode 100644
index 9db83f0..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testCrossJoinWithAsterisk3.result
+++ /dev/null
@@ -1,27 +0,0 @@
-c_custkey,c_name,c_address,c_nationkey,c_phone,c_acctbal,c_mktsegment,c_comment,r_regionkey,r_name,r_comment
--------------------------------
-1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
-1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e,1,AMERICA,hs use ironic, even requests. s
-1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e,2,ASIA,ges. thinly even pinto beans ca
-1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e,3,EUROPE,ly final courts cajole furiously final excuse
-1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
-2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
-2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref,1,AMERICA,hs use ironic, even requests. s
-2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref,2,ASIA,ges. thinly even pinto beans ca
-2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref,3,EUROPE,ly final courts cajole furiously final excuse
-2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
-3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
-3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov,1,AMERICA,hs use ironic, even requests. s
-3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov,2,ASIA,ges. thinly even pinto beans ca
-3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov,3,EUROPE,ly final courts cajole furiously final excuse
-3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
-4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
-4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou,1,AMERICA,hs use ironic, even requests. s
-4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou,2,ASIA,ges. thinly even pinto beans ca
-4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou,3,EUROPE,ly final courts cajole furiously final excuse
-4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
-5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
-5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor,1,AMERICA,hs use ironic, even requests. s
-5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor,2,ASIA,ges. thinly even pinto beans ca
-5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor,3,EUROPE,ly final courts cajole furiously final excuse
-5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testCrossJoinWithAsterisk4.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testCrossJoinWithAsterisk4.result b/tajo-core/src/test/resources/results/TestJoinQuery/testCrossJoinWithAsterisk4.result
deleted file mode 100644
index 23d985e..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testCrossJoinWithAsterisk4.result
+++ /dev/null
@@ -1,27 +0,0 @@
-len,c_custkey,c_name,c_address,c_nationkey,c_phone,c_acctbal,c_mktsegment,c_comment,r_regionkey,r_name,r_comment,?multiply
--------------------------------
-31,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e,1,AMERICA,hs use ironic, even requests. s,10
-31,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref,1,AMERICA,hs use ironic, even requests. s,20
-31,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov,1,AMERICA,hs use ironic, even requests. s,30
-31,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou,1,AMERICA,hs use ironic, even requests. s,40
-31,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor,1,AMERICA,hs use ironic, even requests. s,50
-31,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e,2,ASIA,ges. thinly even pinto beans ca,10
-31,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref,2,ASIA,ges. thinly even pinto beans ca,20
-31,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov,2,ASIA,ges. thinly even pinto beans ca,30
-31,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou,2,ASIA,ges. thinly even pinto beans ca,40
-31,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor,2,ASIA,ges. thinly even pinto beans ca,50
-45,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e,3,EUROPE,ly final courts cajole furiously final excuse,10
-45,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref,3,EUROPE,ly final courts cajole furiously final excuse,20
-45,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov,3,EUROPE,ly final courts cajole furiously final excuse,30
-45,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou,3,EUROPE,ly final courts cajole furiously final excuse,40
-45,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor,3,EUROPE,ly final courts cajole furiously final excuse,50
-108,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,10
-108,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,20
-108,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,30
-108,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,40
-108,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,50
-115,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,10
-115,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,20
-115,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,30
-115,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,40
-115,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,50
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testCrossJoinWithEmptyTable1.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testCrossJoinWithEmptyTable1.result b/tajo-core/src/test/resources/results/TestJoinQuery/testCrossJoinWithEmptyTable1.result
deleted file mode 100644
index 6f07515..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testCrossJoinWithEmptyTable1.result
+++ /dev/null
@@ -1,2 +0,0 @@
-c_custkey,o_orderkey
--------------------------------
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testCrossJoinWithThetaJoinConditionInWhere.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testCrossJoinWithThetaJoinConditionInWhere.result b/tajo-core/src/test/resources/results/TestJoinQuery/testCrossJoinWithThetaJoinConditionInWhere.result
deleted file mode 100644
index 82b2757..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testCrossJoinWithThetaJoinConditionInWhere.result
+++ /dev/null
@@ -1,12 +0,0 @@
-a_name,b_name
--------------------------------
-AFRICA,AMERICA
-AFRICA,ASIA
-AFRICA,EUROPE
-AFRICA,MIDDLE EAST
-AMERICA,ASIA
-AMERICA,EUROPE
-AMERICA,MIDDLE EAST
-ASIA,EUROPE
-ASIA,MIDDLE EAST
-EUROPE,MIDDLE EAST
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testDifferentTypesJoinCondition.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testDifferentTypesJoinCondition.result b/tajo-core/src/test/resources/results/TestJoinQuery/testDifferentTypesJoinCondition.result
deleted file mode 100644
index d5b7510..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testDifferentTypesJoinCondition.result
+++ /dev/null
@@ -1,7 +0,0 @@
-id,name,score,type,id,name,score,type
--------------------------------
-1,ooo,1.1,a,1,ooo,1.1,a
-2,ppp,2.3,b,2,ppp,2.3,b
-3,qqq,3.4,c,3,qqq,3.4,c
-4,rrr,4.5,d,4,rrr,4.5,d
-5,xxx,5.6,e,5,xxx,5.6,e
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testFullOuterJoin1.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testFullOuterJoin1.result b/tajo-core/src/test/resources/results/TestJoinQuery/testFullOuterJoin1.result
deleted file mode 100644
index 695a414..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testFullOuterJoin1.result
+++ /dev/null
@@ -1,7 +0,0 @@
-c_custkey,o_orderkey
--------------------------------
-1,1
-2,2
-3,3
-4,null
-5,null
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testFullOuterJoinWithEmptyTable1.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testFullOuterJoinWithEmptyTable1.result b/tajo-core/src/test/resources/results/TestJoinQuery/testFullOuterJoinWithEmptyTable1.result
deleted file mode 100644
index 5b849fc..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testFullOuterJoinWithEmptyTable1.result
+++ /dev/null
@@ -1,7 +0,0 @@
-c_custkey,o_orderkey
--------------------------------
-1,null
-2,null
-3,null
-4,null
-5,null
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testInnerJoinAndCaseWhen.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testInnerJoinAndCaseWhen.result b/tajo-core/src/test/resources/results/TestJoinQuery/testInnerJoinAndCaseWhen.result
deleted file mode 100644
index a4c33f8..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testInnerJoinAndCaseWhen.result
+++ /dev/null
@@ -1,27 +0,0 @@
-r_regionkey,n_regionkey,cond
--------------------------------
-0,0,zero
-0,0,zero
-0,0,zero
-0,0,zero
-0,0,zero
-1,1,one
-1,1,one
-1,1,one
-1,1,one
-1,1,one
-2,2,two
-2,2,two
-2,2,two
-2,2,two
-2,2,two
-3,3,three
-3,3,three
-3,3,three
-3,3,three
-3,3,three
-4,4,four
-4,4,four
-4,4,four
-4,4,four
-4,4,four
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testInnerJoinWithEmptyTable.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testInnerJoinWithEmptyTable.result b/tajo-core/src/test/resources/results/TestJoinQuery/testInnerJoinWithEmptyTable.result
deleted file mode 100644
index 6f07515..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testInnerJoinWithEmptyTable.result
+++ /dev/null
@@ -1,2 +0,0 @@
-c_custkey,o_orderkey
--------------------------------
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testInnerJoinWithThetaJoinConditionInWhere.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testInnerJoinWithThetaJoinConditionInWhere.result b/tajo-core/src/test/resources/results/TestJoinQuery/testInnerJoinWithThetaJoinConditionInWhere.result
deleted file mode 100644
index b388d0b..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testInnerJoinWithThetaJoinConditionInWhere.result
+++ /dev/null
@@ -1,7 +0,0 @@
-r_regionkey,r_name,r_name
--------------------------------
-0,AFRICA,AFRICA
-1,AMERICA,AMERICA
-2,ASIA,ASIA
-3,EUROPE,EUROPE
-4,MIDDLE EAST,MIDDLE EAST
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testJoinAsterisk.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testJoinAsterisk.result b/tajo-core/src/test/resources/results/TestJoinQuery/testJoinAsterisk.result
deleted file mode 100644
index d01fa21..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testJoinAsterisk.result
+++ /dev/null
@@ -1,7 +0,0 @@
-n_nationkey,n_name,n_regionkey,n_comment,c_custkey,c_name,c_address,c_nationkey,c_phone,c_acctbal,c_mktsegment,c_comment
--------------------------------
-1,ARGENTINA,1,al foxes promise slyly according to the regular accounts. bold requests alon,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov
-3,CANADA,1,eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor
-4,EGYPT,4,y above the carefully unusual theodolites. final dugouts are quickly across the furiously regular d,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou
-13,JORDAN,4,ic deposits are blithely about the carefully regular pa,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref
-15,MOROCCO,0,rns. blithely bold courts among the closely regular packages use furiously bold platelets?,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testJoinCoReferredEvals1.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testJoinCoReferredEvals1.result b/tajo-core/src/test/resources/results/TestJoinQuery/testJoinCoReferredEvals1.result
deleted file mode 100644
index b24e47e..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testJoinCoReferredEvals1.result
+++ /dev/null
@@ -1,27 +0,0 @@
-r_regionkey,n_regionkey,plus
--------------------------------
-0,0,0
-0,0,0
-0,0,0
-0,0,0
-0,0,0
-1,1,2
-1,1,2
-1,1,2
-1,1,2
-1,1,2
-2,2,4
-2,2,4
-2,2,4
-2,2,4
-2,2,4
-3,3,6
-3,3,6
-3,3,6
-3,3,6
-3,3,6
-4,4,8
-4,4,8
-4,4,8
-4,4,8
-4,4,8
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testJoinCoReferredEvalsWithSameExprs1.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testJoinCoReferredEvalsWithSameExprs1.result b/tajo-core/src/test/resources/results/TestJoinQuery/testJoinCoReferredEvalsWithSameExprs1.result
deleted file mode 100644
index 23776b6..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testJoinCoReferredEvalsWithSameExprs1.result
+++ /dev/null
@@ -1,22 +0,0 @@
-v1,n_regionkey,r_regionkey,plus1,plus2,result
--------------------------------
-2,1,1,2,2,1
-3,1,1,2,2,1
-4,1,1,2,2,1
-8,4,4,8,8,4
-9,3,3,6,6,3
-10,2,2,4,4,2
-10,3,3,6,6,3
-11,2,2,4,4,2
-14,2,2,4,4,2
-14,4,4,8,8,4
-15,4,4,8,8,4
-17,4,4,8,8,4
-18,1,1,2,2,1
-20,2,2,4,4,2
-22,3,3,6,6,3
-23,2,2,4,4,2
-24,4,4,8,8,4
-25,1,1,2,2,1
-25,3,3,6,6,3
-26,3,3,6,6,3
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testJoinCoReferredEvalsWithSameExprs2.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testJoinCoReferredEvalsWithSameExprs2.result b/tajo-core/src/test/resources/results/TestJoinQuery/testJoinCoReferredEvalsWithSameExprs2.result
deleted file mode 100644
index 0e31362..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testJoinCoReferredEvalsWithSameExprs2.result
+++ /dev/null
@@ -1,22 +0,0 @@
-v1,n_regionkey,r_regionkey,plus1,plus2,result,total
--------------------------------
-2,1,1,2,2,1,2
-3,1,1,2,2,1,2
-4,1,1,2,2,1,2
-8,4,4,8,8,4,8
-9,3,3,6,6,3,6
-10,2,2,4,4,2,4
-10,3,3,6,6,3,6
-11,2,2,4,4,2,4
-14,2,2,4,4,2,4
-14,4,4,8,8,4,8
-15,4,4,8,8,4,8
-17,4,4,8,8,4,8
-18,1,1,2,2,1,2
-20,2,2,4,4,2,4
-22,3,3,6,6,3,6
-23,2,2,4,4,2,4
-24,4,4,8,8,4,8
-25,1,1,2,2,1,2
-25,3,3,6,6,3,6
-26,3,3,6,6,3,6
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testJoinFilterOfRowPreservedTable1.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testJoinFilterOfRowPreservedTable1.result b/tajo-core/src/test/resources/results/TestJoinQuery/testJoinFilterOfRowPreservedTable1.result
deleted file mode 100644
index d489e3e..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testJoinFilterOfRowPreservedTable1.result
+++ /dev/null
@@ -1,15 +0,0 @@
-r_name,r_regionkey,n_name,n_regionkey
--------------------------------
-AFRICA,0,null,null
-AMERICA,1,ARGENTINA,1
-AMERICA,1,BRAZIL,1
-AMERICA,1,CANADA,1
-AMERICA,1,PERU,1
-AMERICA,1,UNITED STATES,1
-ASIA,2,CHINA,2
-ASIA,2,INDIA,2
-ASIA,2,INDONESIA,2
-ASIA,2,JAPAN,2
-ASIA,2,VIETNAM,2
-EUROPE,3,null,null
-MIDDLE EAST,4,null,null
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testJoinOnMultipleDatabases.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testJoinOnMultipleDatabases.result b/tajo-core/src/test/resources/results/TestJoinQuery/testJoinOnMultipleDatabases.result
deleted file mode 100644
index dc0968f..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testJoinOnMultipleDatabases.result
+++ /dev/null
@@ -1,5 +0,0 @@
-s_acctbal,s_name,n_name,p_partkey,p_mfgr,s_address,s_phone,s_comment
--------------------------------
-4032.68,Supplier#000000002,ETHIOPIA,1,Manufacturer#1,89eJ5ksX3ImxJQBvxObC,,15-679-861-2259, slyly bold instructions. idle dependen
-4192.4,Supplier#000000003,ARGENTINA,2,Manufacturer#1,q1,G3Pj6OjIuUYfUoH18BFTKP5aU9bEV3,11-383-516-1199,blithely silent requests after the express dependencies are sl
-4641.08,Supplier#000000004,MOROCCO,3,Manufacturer#4,Bk7ah4CK8SYQTepEmvMkkgMwg,25-843-787-7479,riously even requests above the exp
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testJoinOnMultipleDatabasesWithJson.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testJoinOnMultipleDatabasesWithJson.result b/tajo-core/src/test/resources/results/TestJoinQuery/testJoinOnMultipleDatabasesWithJson.result
deleted file mode 100644
index dc0968f..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testJoinOnMultipleDatabasesWithJson.result
+++ /dev/null
@@ -1,5 +0,0 @@
-s_acctbal,s_name,n_name,p_partkey,p_mfgr,s_address,s_phone,s_comment
--------------------------------
-4032.68,Supplier#000000002,ETHIOPIA,1,Manufacturer#1,89eJ5ksX3ImxJQBvxObC,,15-679-861-2259, slyly bold instructions. idle dependen
-4192.4,Supplier#000000003,ARGENTINA,2,Manufacturer#1,q1,G3Pj6OjIuUYfUoH18BFTKP5aU9bEV3,11-383-516-1199,blithely silent requests after the express dependencies are sl
-4641.08,Supplier#000000004,MOROCCO,3,Manufacturer#4,Bk7ah4CK8SYQTepEmvMkkgMwg,25-843-787-7479,riously even requests above the exp
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testJoinWithJson.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testJoinWithJson.result b/tajo-core/src/test/resources/results/TestJoinQuery/testJoinWithJson.result
deleted file mode 100644
index 23d985e..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testJoinWithJson.result
+++ /dev/null
@@ -1,27 +0,0 @@
-len,c_custkey,c_name,c_address,c_nationkey,c_phone,c_acctbal,c_mktsegment,c_comment,r_regionkey,r_name,r_comment,?multiply
--------------------------------
-31,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e,1,AMERICA,hs use ironic, even requests. s,10
-31,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref,1,AMERICA,hs use ironic, even requests. s,20
-31,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov,1,AMERICA,hs use ironic, even requests. s,30
-31,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou,1,AMERICA,hs use ironic, even requests. s,40
-31,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor,1,AMERICA,hs use ironic, even requests. s,50
-31,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e,2,ASIA,ges. thinly even pinto beans ca,10
-31,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref,2,ASIA,ges. thinly even pinto beans ca,20
-31,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov,2,ASIA,ges. thinly even pinto beans ca,30
-31,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou,2,ASIA,ges. thinly even pinto beans ca,40
-31,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor,2,ASIA,ges. thinly even pinto beans ca,50
-45,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e,3,EUROPE,ly final courts cajole furiously final excuse,10
-45,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref,3,EUROPE,ly final courts cajole furiously final excuse,20
-45,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov,3,EUROPE,ly final courts cajole furiously final excuse,30
-45,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou,3,EUROPE,ly final courts cajole furiously final excuse,40
-45,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor,3,EUROPE,ly final courts cajole furiously final excuse,50
-108,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,10
-108,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,20
-108,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,30
-108,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,40
-108,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,50
-115,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,10
-115,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,20
-115,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,30
-115,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,40
-115,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,50
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testJoinWithJson2.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testJoinWithJson2.result b/tajo-core/src/test/resources/results/TestJoinQuery/testJoinWithJson2.result
deleted file mode 100644
index 155ba42..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testJoinWithJson2.result
+++ /dev/null
@@ -1,5 +0,0 @@
-n_nationkey,n_name,n_regionkey,n_comment,ps_availqty,s_suppkey
--------------------------------
-1,ARGENTINA,1,al foxes promise slyly according to the regular accounts. bold requests alon,8895,3
-5,ETHIOPIA,0,ven packages wake quickly. regu,3325,2
-15,MOROCCO,0,rns. blithely bold courts among the closely regular packages use furiously bold platelets?,4651,4
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testJoinWithMultipleJoinQual1.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testJoinWithMultipleJoinQual1.result b/tajo-core/src/test/resources/results/TestJoinQuery/testJoinWithMultipleJoinQual1.result
deleted file mode 100644
index 79e96cc..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testJoinWithMultipleJoinQual1.result
+++ /dev/null
@@ -1,2 +0,0 @@
-s_acctbal,s_name,n_name,p_partkey,p_mfgr,s_address,s_phone,s_comment
--------------------------------
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testJoinWithMultipleJoinQual2.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testJoinWithMultipleJoinQual2.result b/tajo-core/src/test/resources/results/TestJoinQuery/testJoinWithMultipleJoinQual2.result
deleted file mode 100644
index 7c53027..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testJoinWithMultipleJoinQual2.result
+++ /dev/null
@@ -1,3 +0,0 @@
-n_nationkey,name,n_regionkey,n_comment
--------------------------------
-15,MOROCCO,0,rns. blithely bold courts among the closely regular packages use furiously bold platelets?
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testJoinWithMultipleJoinQual3.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testJoinWithMultipleJoinQual3.result b/tajo-core/src/test/resources/results/TestJoinQuery/testJoinWithMultipleJoinQual3.result
deleted file mode 100644
index 155ba42..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testJoinWithMultipleJoinQual3.result
+++ /dev/null
@@ -1,5 +0,0 @@
-n_nationkey,n_name,n_regionkey,n_comment,ps_availqty,s_suppkey
--------------------------------
-1,ARGENTINA,1,al foxes promise slyly according to the regular accounts. bold requests alon,8895,3
-5,ETHIOPIA,0,ven packages wake quickly. regu,3325,2
-15,MOROCCO,0,rns. blithely bold courts among the closely regular packages use furiously bold platelets?,4651,4
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testJoinWithMultipleJoinQual4.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testJoinWithMultipleJoinQual4.result b/tajo-core/src/test/resources/results/TestJoinQuery/testJoinWithMultipleJoinQual4.result
deleted file mode 100644
index a72f35e..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testJoinWithMultipleJoinQual4.result
+++ /dev/null
@@ -1,4 +0,0 @@
-n_nationkey,n_name,n_regionkey,n_comment,ps_availqty,s_suppkey
--------------------------------
-5,ETHIOPIA,0,ven packages wake quickly. regu,3325,2
-15,MOROCCO,0,rns. blithely bold courts among the closely regular packages use furiously bold platelets?,4651,4
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testJoinWithMultipleJoinTypes.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testJoinWithMultipleJoinTypes.result b/tajo-core/src/test/resources/results/TestJoinQuery/testJoinWithMultipleJoinTypes.result
deleted file mode 100644
index 7748513..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testJoinWithMultipleJoinTypes.result
+++ /dev/null
@@ -1,6 +0,0 @@
-c_custkey,c_name,c_address,c_nationkey,c_phone,c_acctbal,c_mktsegment,c_comment,n_nationkey,r_regionkey,r_name,r_comment
--------------------------------
-1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e,1,1,AMERICA,hs use ironic, even requests. s
-2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref,2,2,ASIA,ges. thinly even pinto beans ca
-3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov,3,3,EUROPE,ly final courts cajole furiously final excuse
-4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou,4,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testJoinWithOrPredicates.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testJoinWithOrPredicates.result b/tajo-core/src/test/resources/results/TestJoinQuery/testJoinWithOrPredicates.result
deleted file mode 100644
index ede3464..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testJoinWithOrPredicates.result
+++ /dev/null
@@ -1,4 +0,0 @@
-n_nationkey,n_name,n_name
--------------------------------
-1,ARGENTINA,ARGENTINA
-2,BRAZIL,BRAZIL
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoin1.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoin1.result b/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoin1.result
deleted file mode 100644
index 9e2a53a..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoin1.result
+++ /dev/null
@@ -1,7 +0,0 @@
-c_custkey,o_orderkey,o_orderstatus,o_orderdate
--------------------------------
-1,1,O,1996-01-02
-2,2,O,1996-12-01
-3,3,F,1993-10-14
-4,null,null,null
-5,null,null,null
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithConstantExpr1.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithConstantExpr1.result b/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithConstantExpr1.result
deleted file mode 100644
index 670a069..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithConstantExpr1.result
+++ /dev/null
@@ -1,7 +0,0 @@
-c_custkey,o_orderkey,val
--------------------------------
-1,1,val
-2,2,val
-3,3,val
-4,null,val
-5,null,val
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithConstantExpr2.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithConstantExpr2.result b/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithConstantExpr2.result
deleted file mode 100644
index 670a069..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithConstantExpr2.result
+++ /dev/null
@@ -1,7 +0,0 @@
-c_custkey,o_orderkey,val
--------------------------------
-1,1,val
-2,2,val
-3,3,val
-4,null,val
-5,null,val
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithConstantExpr3.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithConstantExpr3.result b/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithConstantExpr3.result
deleted file mode 100644
index 955cf44..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithConstantExpr3.result
+++ /dev/null
@@ -1,7 +0,0 @@
-c_custkey,const_val,min_name
--------------------------------
-1,123,Customer#000000001
-2,123,Customer#000000002
-3,123,Customer#000000003
-4,123,Customer#000000004
-5,123,Customer#000000005
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithConstantExpr4.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithConstantExpr4.result b/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithConstantExpr4.result
deleted file mode 100644
index cb1c3fc..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithConstantExpr4.result
+++ /dev/null
@@ -1,7 +0,0 @@
-l_orderkey,o_orderkey,key1,key2
--------------------------------
-1,1,201405,5-LOW
-1,1,201405,5-LOW
-2,null,201405,5-LOW
-3,3,201405,5-LOW
-3,3,201405,5-LOW
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithConstantExpr5.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithConstantExpr5.result b/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithConstantExpr5.result
deleted file mode 100644
index 8ba8bba..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithConstantExpr5.result
+++ /dev/null
@@ -1,6 +0,0 @@
-l_orderkey,o_orderkey,key1,key2
--------------------------------
-1,1,201405,5-LOW
-1,1,201405,5-LOW
-3,3,201405,5-LOW
-3,3,201405,5-LOW
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithEmptyTable1.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithEmptyTable1.result b/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithEmptyTable1.result
deleted file mode 100644
index e2f94f4..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithEmptyTable1.result
+++ /dev/null
@@ -1,7 +0,0 @@
-c_custkey,o_orderkey,o_orderstatus,o_orderdate
--------------------------------
-1,null,null,null
-2,null,null,null
-3,null,null,null
-4,null,null,null
-5,null,null,null
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithEmptyTable2.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithEmptyTable2.result b/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithEmptyTable2.result
deleted file mode 100644
index 0830847..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithEmptyTable2.result
+++ /dev/null
@@ -1,7 +0,0 @@
-c_custkey,?sum,?max_1,?max_2
--------------------------------
-1,null,null,null
-2,null,null,null
-3,null,null,null
-4,null,null,null
-5,null,null,null
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithEmptyTable3.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithEmptyTable3.result b/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithEmptyTable3.result
deleted file mode 100644
index f3e11cb..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithEmptyTable3.result
+++ /dev/null
@@ -1,7 +0,0 @@
-?count
--------------------------------
-1
-1
-1
-1
-1
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithEmptyTable4.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithEmptyTable4.result b/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithEmptyTable4.result
deleted file mode 100644
index d4d0b53..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithEmptyTable4.result
+++ /dev/null
@@ -1,4 +0,0 @@
-?max,?sum_1,?max_2,?max_3
--------------------------------
-5,6,O,1996-12-01
-5,null,null,null
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithEmptyTable5.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithEmptyTable5.result b/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithEmptyTable5.result
deleted file mode 100644
index 61c58b9..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithEmptyTable5.result
+++ /dev/null
@@ -1,4 +0,0 @@
-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
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithNull1.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithNull1.result b/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithNull1.result
deleted file mode 100644
index 81b907d..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithNull1.result
+++ /dev/null
@@ -1,4 +0,0 @@
-c_custkey,o_orderkey,?coalesce,o_orderdate
--------------------------------
-4,null,N/A,null
-5,null,N/A,null
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithNull2.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithNull2.result b/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithNull2.result
deleted file mode 100644
index 08f745c..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithNull2.result
+++ /dev/null
@@ -1,4 +0,0 @@
-c_custkey,o_orderkey,?coalesce,o_orderdate
--------------------------------
-1,1,O,1996-01-02
-2,2,O,1996-12-01
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithNull3.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithNull3.result b/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithNull3.result
deleted file mode 100644
index efd2e74..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithNull3.result
+++ /dev/null
@@ -1,2 +0,0 @@
-c_custkey,o_orderkey,?coalesce,o_orderdate
--------------------------------
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithThetaJoinConditionInWhere.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithThetaJoinConditionInWhere.result b/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithThetaJoinConditionInWhere.result
deleted file mode 100644
index c727791..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithThetaJoinConditionInWhere.result
+++ /dev/null
@@ -1,4 +0,0 @@
-r_regionkey,r_name,r_comment,c_custkey,c_name,c_address,c_nationkey,c_phone,c_acctbal,c_mktsegment,c_comment
--------------------------------
-1,AMERICA,hs use ironic, even requests. s,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e
-2,ASIA,ges. thinly even pinto beans ca,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testNaturalJoin.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testNaturalJoin.result b/tajo-core/src/test/resources/results/TestJoinQuery/testNaturalJoin.result
deleted file mode 100644
index fa5a71e..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testNaturalJoin.result
+++ /dev/null
@@ -1,27 +0,0 @@
-n_name,n_name
--------------------------------
-ALGERIA,ALGERIA
-ARGENTINA,ARGENTINA
-BRAZIL,BRAZIL
-CANADA,CANADA
-CHINA,CHINA
-EGYPT,EGYPT
-ETHIOPIA,ETHIOPIA
-FRANCE,FRANCE
-GERMANY,GERMANY
-INDIA,INDIA
-INDONESIA,INDONESIA
-IRAN,IRAN
-IRAQ,IRAQ
-JAPAN,JAPAN
-JORDAN,JORDAN
-KENYA,KENYA
-MOROCCO,MOROCCO
-MOZAMBIQUE,MOZAMBIQUE
-PERU,PERU
-ROMANIA,ROMANIA
-RUSSIA,RUSSIA
-SAUDI ARABIA,SAUDI ARABIA
-UNITED KINGDOM,UNITED KINGDOM
-UNITED STATES,UNITED STATES
-VIETNAM,VIETNAM
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testOuterJoinAndCaseWhen1.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testOuterJoinAndCaseWhen1.result b/tajo-core/src/test/resources/results/TestJoinQuery/testOuterJoinAndCaseWhen1.result
deleted file mode 100644
index 8f204fb..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testOuterJoinAndCaseWhen1.result
+++ /dev/null
@@ -1,7 +0,0 @@
-id,name,id2,name2,c1,c2
--------------------------------
-1,ooo,1,null,9991231,ooo
-2,ppp,2,null,9991231,ppp
-3,qqq,null,null,9991231,9991231
-4,rrr,null,null,9991231,9991231
-5,xxx,null,null,9991231,9991231
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testRightOuterJoin1.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testRightOuterJoin1.result b/tajo-core/src/test/resources/results/TestJoinQuery/testRightOuterJoin1.result
deleted file mode 100644
index 695a414..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testRightOuterJoin1.result
+++ /dev/null
@@ -1,7 +0,0 @@
-c_custkey,o_orderkey
--------------------------------
-1,1
-2,2
-3,3
-4,null
-5,null
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testRightOuterJoinWithEmptyTable1.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testRightOuterJoinWithEmptyTable1.result b/tajo-core/src/test/resources/results/TestJoinQuery/testRightOuterJoinWithEmptyTable1.result
deleted file mode 100644
index 5b849fc..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testRightOuterJoinWithEmptyTable1.result
+++ /dev/null
@@ -1,7 +0,0 @@
-c_custkey,o_orderkey
--------------------------------
-1,null
-2,null
-3,null
-4,null
-5,null
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testRightOuterJoinWithThetaJoinConditionInWhere.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testRightOuterJoinWithThetaJoinConditionInWhere.result b/tajo-core/src/test/resources/results/TestJoinQuery/testRightOuterJoinWithThetaJoinConditionInWhere.result
deleted file mode 100644
index c727791..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testRightOuterJoinWithThetaJoinConditionInWhere.result
+++ /dev/null
@@ -1,4 +0,0 @@
-r_regionkey,r_name,r_comment,c_custkey,c_name,c_address,c_nationkey,c_phone,c_acctbal,c_mktsegment,c_comment
--------------------------------
-1,AMERICA,hs use ironic, even requests. s,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e
-2,ASIA,ges. thinly even pinto beans ca,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testTPCHQ2Join.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testTPCHQ2Join.result b/tajo-core/src/test/resources/results/TestJoinQuery/testTPCHQ2Join.result
deleted file mode 100644
index dc0968f..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testTPCHQ2Join.result
+++ /dev/null
@@ -1,5 +0,0 @@
-s_acctbal,s_name,n_name,p_partkey,p_mfgr,s_address,s_phone,s_comment
--------------------------------
-4032.68,Supplier#000000002,ETHIOPIA,1,Manufacturer#1,89eJ5ksX3ImxJQBvxObC,,15-679-861-2259, slyly bold instructions. idle dependen
-4192.4,Supplier#000000003,ARGENTINA,2,Manufacturer#1,q1,G3Pj6OjIuUYfUoH18BFTKP5aU9bEV3,11-383-516-1199,blithely silent requests after the express dependencies are sl
-4641.08,Supplier#000000004,MOROCCO,3,Manufacturer#4,Bk7ah4CK8SYQTepEmvMkkgMwg,25-843-787-7479,riously even requests above the exp
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinQuery/testWhereClauseJoin1.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinQuery/testWhereClauseJoin1.result b/tajo-core/src/test/resources/results/TestJoinQuery/testWhereClauseJoin1.result
deleted file mode 100644
index 5691b50..0000000
--- a/tajo-core/src/test/resources/results/TestJoinQuery/testWhereClauseJoin1.result
+++ /dev/null
@@ -1,27 +0,0 @@
-n_name,r_name,n_regionkey,r_regionkey
--------------------------------
-ALGERIA,AFRICA,0,0
-ARGENTINA,AMERICA,1,1
-BRAZIL,AMERICA,1,1
-CANADA,AMERICA,1,1
-CHINA,ASIA,2,2
-EGYPT,MIDDLE EAST,4,4
-ETHIOPIA,AFRICA,0,0
-FRANCE,EUROPE,3,3
-GERMANY,EUROPE,3,3
-INDIA,ASIA,2,2
-INDONESIA,ASIA,2,2
-IRAN,MIDDLE EAST,4,4
-IRAQ,MIDDLE EAST,4,4
-JAPAN,ASIA,2,2
-JORDAN,MIDDLE EAST,4,4
-KENYA,AFRICA,0,0
-MOROCCO,AFRICA,0,0
-MOZAMBIQUE,AFRICA,0,0
-PERU,AMERICA,1,1
-ROMANIA,EUROPE,3,3
-RUSSIA,EUROPE,3,3
-SAUDI ARABIA,MIDDLE EAST,4,4
-UNITED KINGDOM,EUROPE,3,3
-UNITED STATES,AMERICA,1,1
-VIETNAM,ASIA,2,2
\ No newline at end of file