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
