tajo-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jihoon...@apache.org
Subject [22/57] [abbrv] tajo git commit: TAJO-1577: Add test cases to verify join plans. (jihoon)
Date Mon, 25 May 2015 14:36:15 GMT
http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestInnerJoinWithSubQuery/testJoinWithMultipleJoinQual4.Sort.plan
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestInnerJoinWithSubQuery/testJoinWithMultipleJoinQual4.Sort.plan b/tajo-core/src/test/resources/results/TestInnerJoinWithSubQuery/testJoinWithMultipleJoinQual4.Sort.plan
new file mode 100644
index 0000000..15be610
--- /dev/null
+++ b/tajo-core/src/test/resources/results/TestInnerJoinWithSubQuery/testJoinWithMultipleJoinQual4.Sort.plan
@@ -0,0 +1,142 @@
+explain
+-------------------------------
+SELECTION(9)
+  => Search Cond: default.t.n_nationkey (INT4) > default.s.s_suppkey (INT4)
+   JOIN(14)(INNER)
+     => Join Cond: default.s.s_nationkey (INT4) = default.t.n_nationkey (INT4)
+     => target list: default.ps.ps_availqty (INT4), default.s.s_suppkey (INT4), default.t.n_comment (TEXT), default.t.n_name (TEXT), default.t.n_nationkey (INT4), default.t.n_regionkey (INT4)
+     => out schema: {(6) default.ps.ps_availqty (INT4), default.s.s_suppkey (INT4), default.t.n_comment (TEXT), default.t.n_name (TEXT), default.t.n_nationkey (INT4), default.t.n_regionkey (INT4)}
+     => in schema: {(7) default.ps.ps_availqty (INT4), default.s.s_nationkey (INT4), default.s.s_suppkey (INT4), default.t.n_comment (TEXT), default.t.n_name (TEXT), default.t.n_nationkey (INT4), default.t.n_regionkey (INT4)}
+      JOIN(13)(INNER)
+        => Join Cond: default.s.s_suppkey (INT4) = default.ps.ps_suppkey (INT4)
+        => target list: default.ps.ps_availqty (INT4), default.s.s_nationkey (INT4), default.s.s_suppkey (INT4)
+        => out schema: {(3) default.ps.ps_availqty (INT4), default.s.s_nationkey (INT4), default.s.s_suppkey (INT4)}
+        => in schema: {(4) default.ps.ps_availqty (INT4), default.ps.ps_suppkey (INT4), default.s.s_nationkey (INT4), default.s.s_suppkey (INT4)}
+         SCAN(7) on default.partsupp as ps
+           => target list: default.ps.ps_availqty (INT4), default.ps.ps_suppkey (INT4)
+           => out schema: {(2) default.ps.ps_availqty (INT4), default.ps.ps_suppkey (INT4)}
+           => in schema: {(5) default.ps.ps_availqty (INT4), default.ps.ps_comment (TEXT), default.ps.ps_partkey (INT4), default.ps.ps_suppkey (INT4), default.ps.ps_supplycost (FLOAT8)}
+         SCAN(5) on default.supplier as s
+           => target list: default.s.s_nationkey (INT4), default.s.s_suppkey (INT4)
+           => out schema: {(2) default.s.s_nationkey (INT4), default.s.s_suppkey (INT4)}
+           => in schema: {(7) default.s.s_acctbal (FLOAT8), default.s.s_address (TEXT), default.s.s_comment (TEXT), default.s.s_name (TEXT), default.s.s_nationkey (INT4), default.s.s_phone (TEXT), default.s.s_suppkey (INT4)}
+      TABLE_SUBQUERY(4) as default.t
+        => Targets: default.t.n_nationkey (INT4), default.t.n_name (TEXT), default.t.n_regionkey (INT4), default.t.n_comment (TEXT)
+        => out schema: {(4) default.t.n_comment (TEXT), default.t.n_name (TEXT), default.t.n_nationkey (INT4), default.t.n_regionkey (INT4)}
+        => in  schema: {(4) default.t.n_comment (TEXT), default.t.n_name (TEXT), default.t.n_nationkey (INT4), default.t.n_regionkey (INT4)}
+         JOIN(12)(INNER)
+           => Join Cond: default.n.n_regionkey (INT4) = default.r.r_regionkey (INT4)
+           => target list: default.n.n_comment (TEXT), default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4)
+           => out schema: {(4) default.n.n_comment (TEXT), default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4)}
+           => in schema: {(5) default.n.n_comment (TEXT), default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4), default.r.r_regionkey (INT4)}
+            SCAN(1) on default.region as r
+              => target list: default.r.r_regionkey (INT4)
+              => out schema: {(1) default.r.r_regionkey (INT4)}
+              => in schema: {(3) default.r.r_comment (TEXT), default.r.r_name (TEXT), default.r.r_regionkey (INT4)}
+            SCAN(0) on default.nation as n
+              => filter: default.n.n_name (TEXT) IN (ARGENTINA, ETHIOPIA, MOROCCO)
+              => target list: default.n.n_comment (TEXT), default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4)
+              => out schema: {(4) default.n.n_comment (TEXT), default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4)}
+              => in schema: {(4) default.n.n_comment (TEXT), default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4)}
+explain
+-------------------------------
+-------------------------------------------------------------------------------
+Execution Block Graph (TERMINAL - eb_0000000000000_0000_000008)
+-------------------------------------------------------------------------------
+|-eb_0000000000000_0000_000008
+   |-eb_0000000000000_0000_000007
+      |-eb_0000000000000_0000_000006
+      |-eb_0000000000000_0000_000003
+-------------------------------------------------------------------------------
+Order of Execution
+-------------------------------------------------------------------------------
+1: eb_0000000000000_0000_000003
+2: eb_0000000000000_0000_000006
+3: eb_0000000000000_0000_000007
+4: eb_0000000000000_0000_000008
+-------------------------------------------------------------------------------
+
+=======================================================
+Block Id: eb_0000000000000_0000_000003 [LEAF]
+=======================================================
+
+[Outgoing]
+[q_0000000000000_0000] 3 => 7 (type=HASH_SHUFFLE, key=default.t.n_nationkey (INT4), num=32)
+
+[Enforcers]
+ 0: type=Broadcast, tables=default.n
+ 1: type=Broadcast, tables=default.r
+
+TABLE_SUBQUERY(4) as default.t
+  => Targets: default.t.n_nationkey (INT4), default.t.n_name (TEXT), default.t.n_regionkey (INT4), default.t.n_comment (TEXT)
+  => out schema: {(4) default.t.n_nationkey (INT4), default.t.n_name (TEXT), default.t.n_regionkey (INT4), default.t.n_comment (TEXT)}
+  => in  schema: {(4) default.t.n_comment (TEXT), default.t.n_name (TEXT), default.t.n_nationkey (INT4), default.t.n_regionkey (INT4)}
+   PROJECTION(3)
+     => Targets: default.n.n_nationkey (INT4), default.n.n_name (TEXT), default.n.n_regionkey (INT4), default.n.n_comment (TEXT)
+     => out schema: {(4) default.n.n_comment (TEXT), default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4)}
+     => in  schema: {(4) default.n.n_comment (TEXT), default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4)}
+      JOIN(12)(INNER)
+        => Join Cond: default.n.n_regionkey (INT4) = default.r.r_regionkey (INT4)
+        => target list: default.n.n_comment (TEXT), default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4)
+        => out schema: {(4) default.n.n_comment (TEXT), default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4)}
+        => in schema: {(5) default.n.n_comment (TEXT), default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4), default.r.r_regionkey (INT4)}
+         SCAN(1) on default.region as r
+           => target list: default.r.r_regionkey (INT4)
+           => out schema: {(1) default.r.r_regionkey (INT4)}
+           => in schema: {(3) default.r.r_comment (TEXT), default.r.r_name (TEXT), default.r.r_regionkey (INT4)}
+         SCAN(0) on default.nation as n
+           => filter: default.n.n_name (TEXT) IN (ARGENTINA, ETHIOPIA, MOROCCO)
+           => target list: default.n.n_comment (TEXT), default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4)
+           => out schema: {(4) default.n.n_comment (TEXT), default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4)}
+           => in schema: {(4) default.n.n_comment (TEXT), default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4)}
+
+=======================================================
+Block Id: eb_0000000000000_0000_000006 [LEAF]
+=======================================================
+
+[Outgoing]
+[q_0000000000000_0000] 6 => 7 (type=HASH_SHUFFLE, key=default.s.s_nationkey (INT4), num=32)
+
+[Enforcers]
+ 0: type=Broadcast, tables=default.s
+ 1: type=Broadcast, tables=default.ps
+
+JOIN(13)(INNER)
+  => Join Cond: default.s.s_suppkey (INT4) = default.ps.ps_suppkey (INT4)
+  => target list: default.ps.ps_availqty (INT4), default.s.s_nationkey (INT4), default.s.s_suppkey (INT4)
+  => out schema: {(3) default.ps.ps_availqty (INT4), default.s.s_nationkey (INT4), default.s.s_suppkey (INT4)}
+  => in schema: {(4) default.ps.ps_availqty (INT4), default.ps.ps_suppkey (INT4), default.s.s_nationkey (INT4), default.s.s_suppkey (INT4)}
+   SCAN(7) on default.partsupp as ps
+     => target list: default.ps.ps_availqty (INT4), default.ps.ps_suppkey (INT4)
+     => out schema: {(2) default.ps.ps_availqty (INT4), default.ps.ps_suppkey (INT4)}
+     => in schema: {(5) default.ps.ps_availqty (INT4), default.ps.ps_comment (TEXT), default.ps.ps_partkey (INT4), default.ps.ps_suppkey (INT4), default.ps.ps_supplycost (FLOAT8)}
+   SCAN(5) on default.supplier as s
+     => target list: default.s.s_nationkey (INT4), default.s.s_suppkey (INT4)
+     => out schema: {(2) default.s.s_nationkey (INT4), default.s.s_suppkey (INT4)}
+     => in schema: {(7) default.s.s_acctbal (FLOAT8), default.s.s_address (TEXT), default.s.s_comment (TEXT), default.s.s_name (TEXT), default.s.s_nationkey (INT4), default.s.s_phone (TEXT), default.s.s_suppkey (INT4)}
+
+=======================================================
+Block Id: eb_0000000000000_0000_000007 [ROOT]
+=======================================================
+
+[Incoming]
+[q_0000000000000_0000] 3 => 7 (type=HASH_SHUFFLE, key=default.t.n_nationkey (INT4), num=32)
+[q_0000000000000_0000] 6 => 7 (type=HASH_SHUFFLE, key=default.s.s_nationkey (INT4), num=32)
+
+SELECTION(9)
+  => Search Cond: default.t.n_nationkey (INT4) > default.s.s_suppkey (INT4)
+   JOIN(14)(INNER)
+     => Join Cond: default.s.s_nationkey (INT4) = default.t.n_nationkey (INT4)
+     => target list: default.ps.ps_availqty (INT4), default.s.s_suppkey (INT4), default.t.n_comment (TEXT), default.t.n_name (TEXT), default.t.n_nationkey (INT4), default.t.n_regionkey (INT4)
+     => out schema: {(6) default.ps.ps_availqty (INT4), default.s.s_suppkey (INT4), default.t.n_comment (TEXT), default.t.n_name (TEXT), default.t.n_nationkey (INT4), default.t.n_regionkey (INT4)}
+     => in schema: {(7) default.ps.ps_availqty (INT4), default.s.s_nationkey (INT4), default.s.s_suppkey (INT4), default.t.n_comment (TEXT), default.t.n_name (TEXT), default.t.n_nationkey (INT4), default.t.n_regionkey (INT4)}
+      SCAN(17) on eb_0000000000000_0000_000006
+        => out schema: {(3) default.ps.ps_availqty (INT4), default.s.s_nationkey (INT4), default.s.s_suppkey (INT4)}
+        => in schema: {(3) default.ps.ps_availqty (INT4), default.s.s_nationkey (INT4), default.s.s_suppkey (INT4)}
+      SCAN(16) on eb_0000000000000_0000_000003
+        => out schema: {(4) default.t.n_nationkey (INT4), default.t.n_name (TEXT), default.t.n_regionkey (INT4), default.t.n_comment (TEXT)}
+        => in schema: {(4) default.t.n_nationkey (INT4), default.t.n_name (TEXT), default.t.n_regionkey (INT4), default.t.n_comment (TEXT)}
+
+=======================================================
+Block Id: eb_0000000000000_0000_000008 [TERMINAL]
+=======================================================

http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestInnerJoinWithSubQuery/testJoinWithMultipleJoinQual4.Sort_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestInnerJoinWithSubQuery/testJoinWithMultipleJoinQual4.Sort_NoBroadcast.plan b/tajo-core/src/test/resources/results/TestInnerJoinWithSubQuery/testJoinWithMultipleJoinQual4.Sort_NoBroadcast.plan
new file mode 100644
index 0000000..f9a09db
--- /dev/null
+++ b/tajo-core/src/test/resources/results/TestInnerJoinWithSubQuery/testJoinWithMultipleJoinQual4.Sort_NoBroadcast.plan
@@ -0,0 +1,194 @@
+explain
+-------------------------------
+SELECTION(9)
+  => Search Cond: default.t.n_nationkey (INT4) > default.s.s_suppkey (INT4)
+   JOIN(14)(INNER)
+     => Join Cond: default.s.s_nationkey (INT4) = default.t.n_nationkey (INT4)
+     => target list: default.ps.ps_availqty (INT4), default.s.s_suppkey (INT4), default.t.n_comment (TEXT), default.t.n_name (TEXT), default.t.n_nationkey (INT4), default.t.n_regionkey (INT4)
+     => out schema: {(6) default.ps.ps_availqty (INT4), default.s.s_suppkey (INT4), default.t.n_comment (TEXT), default.t.n_name (TEXT), default.t.n_nationkey (INT4), default.t.n_regionkey (INT4)}
+     => in schema: {(7) default.ps.ps_availqty (INT4), default.s.s_nationkey (INT4), default.s.s_suppkey (INT4), default.t.n_comment (TEXT), default.t.n_name (TEXT), default.t.n_nationkey (INT4), default.t.n_regionkey (INT4)}
+      JOIN(13)(INNER)
+        => Join Cond: default.s.s_suppkey (INT4) = default.ps.ps_suppkey (INT4)
+        => target list: default.ps.ps_availqty (INT4), default.s.s_nationkey (INT4), default.s.s_suppkey (INT4)
+        => out schema: {(3) default.ps.ps_availqty (INT4), default.s.s_nationkey (INT4), default.s.s_suppkey (INT4)}
+        => in schema: {(4) default.ps.ps_availqty (INT4), default.ps.ps_suppkey (INT4), default.s.s_nationkey (INT4), default.s.s_suppkey (INT4)}
+         SCAN(7) on default.partsupp as ps
+           => target list: default.ps.ps_availqty (INT4), default.ps.ps_suppkey (INT4)
+           => out schema: {(2) default.ps.ps_availqty (INT4), default.ps.ps_suppkey (INT4)}
+           => in schema: {(5) default.ps.ps_availqty (INT4), default.ps.ps_comment (TEXT), default.ps.ps_partkey (INT4), default.ps.ps_suppkey (INT4), default.ps.ps_supplycost (FLOAT8)}
+         SCAN(5) on default.supplier as s
+           => target list: default.s.s_nationkey (INT4), default.s.s_suppkey (INT4)
+           => out schema: {(2) default.s.s_nationkey (INT4), default.s.s_suppkey (INT4)}
+           => in schema: {(7) default.s.s_acctbal (FLOAT8), default.s.s_address (TEXT), default.s.s_comment (TEXT), default.s.s_name (TEXT), default.s.s_nationkey (INT4), default.s.s_phone (TEXT), default.s.s_suppkey (INT4)}
+      TABLE_SUBQUERY(4) as default.t
+        => Targets: default.t.n_nationkey (INT4), default.t.n_name (TEXT), default.t.n_regionkey (INT4), default.t.n_comment (TEXT)
+        => out schema: {(4) default.t.n_comment (TEXT), default.t.n_name (TEXT), default.t.n_nationkey (INT4), default.t.n_regionkey (INT4)}
+        => in  schema: {(4) default.t.n_comment (TEXT), default.t.n_name (TEXT), default.t.n_nationkey (INT4), default.t.n_regionkey (INT4)}
+         JOIN(12)(INNER)
+           => Join Cond: default.n.n_regionkey (INT4) = default.r.r_regionkey (INT4)
+           => target list: default.n.n_comment (TEXT), default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4)
+           => out schema: {(4) default.n.n_comment (TEXT), default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4)}
+           => in schema: {(5) default.n.n_comment (TEXT), default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4), default.r.r_regionkey (INT4)}
+            SCAN(1) on default.region as r
+              => target list: default.r.r_regionkey (INT4)
+              => out schema: {(1) default.r.r_regionkey (INT4)}
+              => in schema: {(3) default.r.r_comment (TEXT), default.r.r_name (TEXT), default.r.r_regionkey (INT4)}
+            SCAN(0) on default.nation as n
+              => filter: default.n.n_name (TEXT) IN (ARGENTINA, ETHIOPIA, MOROCCO)
+              => target list: default.n.n_comment (TEXT), default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4)
+              => out schema: {(4) default.n.n_comment (TEXT), default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4)}
+              => in schema: {(4) default.n.n_comment (TEXT), default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4)}
+explain
+-------------------------------
+-------------------------------------------------------------------------------
+Execution Block Graph (TERMINAL - eb_0000000000000_0000_000008)
+-------------------------------------------------------------------------------
+|-eb_0000000000000_0000_000008
+   |-eb_0000000000000_0000_000007
+      |-eb_0000000000000_0000_000006
+         |-eb_0000000000000_0000_000005
+         |-eb_0000000000000_0000_000004
+      |-eb_0000000000000_0000_000003
+         |-eb_0000000000000_0000_000002
+         |-eb_0000000000000_0000_000001
+-------------------------------------------------------------------------------
+Order of Execution
+-------------------------------------------------------------------------------
+1: eb_0000000000000_0000_000001
+2: eb_0000000000000_0000_000002
+3: eb_0000000000000_0000_000004
+4: eb_0000000000000_0000_000005
+5: eb_0000000000000_0000_000003
+6: eb_0000000000000_0000_000006
+7: eb_0000000000000_0000_000007
+8: eb_0000000000000_0000_000008
+-------------------------------------------------------------------------------
+
+=======================================================
+Block Id: eb_0000000000000_0000_000001 [LEAF]
+=======================================================
+
+[Outgoing]
+[q_0000000000000_0000] 1 => 3 (type=HASH_SHUFFLE, key=default.n.n_regionkey (INT4), num=32)
+
+SCAN(0) on default.nation as n
+  => filter: default.n.n_name (TEXT) IN (ARGENTINA, ETHIOPIA, MOROCCO)
+  => target list: default.n.n_comment (TEXT), default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4)
+  => out schema: {(4) default.n.n_comment (TEXT), default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4)}
+  => in schema: {(4) default.n.n_comment (TEXT), default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4)}
+
+=======================================================
+Block Id: eb_0000000000000_0000_000002 [LEAF]
+=======================================================
+
+[Outgoing]
+[q_0000000000000_0000] 2 => 3 (type=HASH_SHUFFLE, key=default.r.r_regionkey (INT4), num=32)
+
+SCAN(1) on default.region as r
+  => target list: default.r.r_regionkey (INT4)
+  => out schema: {(1) default.r.r_regionkey (INT4)}
+  => in schema: {(3) default.r.r_comment (TEXT), default.r.r_name (TEXT), default.r.r_regionkey (INT4)}
+
+=======================================================
+Block Id: eb_0000000000000_0000_000003 [INTERMEDIATE]
+=======================================================
+
+[Incoming]
+[q_0000000000000_0000] 1 => 3 (type=HASH_SHUFFLE, key=default.n.n_regionkey (INT4), num=32)
+[q_0000000000000_0000] 2 => 3 (type=HASH_SHUFFLE, key=default.r.r_regionkey (INT4), num=32)
+
+[Outgoing]
+[q_0000000000000_0000] 3 => 7 (type=HASH_SHUFFLE, key=default.t.n_nationkey (INT4), num=32)
+
+TABLE_SUBQUERY(4) as default.t
+  => Targets: default.t.n_nationkey (INT4), default.t.n_name (TEXT), default.t.n_regionkey (INT4), default.t.n_comment (TEXT)
+  => out schema: {(4) default.t.n_nationkey (INT4), default.t.n_name (TEXT), default.t.n_regionkey (INT4), default.t.n_comment (TEXT)}
+  => in  schema: {(4) default.t.n_comment (TEXT), default.t.n_name (TEXT), default.t.n_nationkey (INT4), default.t.n_regionkey (INT4)}
+   PROJECTION(3)
+     => Targets: default.n.n_nationkey (INT4), default.n.n_name (TEXT), default.n.n_regionkey (INT4), default.n.n_comment (TEXT)
+     => out schema: {(4) default.n.n_comment (TEXT), default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4)}
+     => in  schema: {(4) default.n.n_comment (TEXT), default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4)}
+      JOIN(12)(INNER)
+        => Join Cond: default.n.n_regionkey (INT4) = default.r.r_regionkey (INT4)
+        => target list: default.n.n_comment (TEXT), default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4)
+        => out schema: {(4) default.n.n_comment (TEXT), default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4)}
+        => in schema: {(5) default.n.n_comment (TEXT), default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4), default.r.r_regionkey (INT4)}
+         SCAN(17) on eb_0000000000000_0000_000002
+           => out schema: {(1) default.r.r_regionkey (INT4)}
+           => in schema: {(1) default.r.r_regionkey (INT4)}
+         SCAN(16) on eb_0000000000000_0000_000001
+           => out schema: {(4) default.n.n_comment (TEXT), default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4)}
+           => in schema: {(4) default.n.n_comment (TEXT), default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4)}
+
+=======================================================
+Block Id: eb_0000000000000_0000_000004 [LEAF]
+=======================================================
+
+[Outgoing]
+[q_0000000000000_0000] 4 => 6 (type=HASH_SHUFFLE, key=default.s.s_suppkey (INT4), num=32)
+
+SCAN(5) on default.supplier as s
+  => target list: default.s.s_nationkey (INT4), default.s.s_suppkey (INT4)
+  => out schema: {(2) default.s.s_nationkey (INT4), default.s.s_suppkey (INT4)}
+  => in schema: {(7) default.s.s_acctbal (FLOAT8), default.s.s_address (TEXT), default.s.s_comment (TEXT), default.s.s_name (TEXT), default.s.s_nationkey (INT4), default.s.s_phone (TEXT), default.s.s_suppkey (INT4)}
+
+=======================================================
+Block Id: eb_0000000000000_0000_000005 [LEAF]
+=======================================================
+
+[Outgoing]
+[q_0000000000000_0000] 5 => 6 (type=HASH_SHUFFLE, key=default.ps.ps_suppkey (INT4), num=32)
+
+SCAN(7) on default.partsupp as ps
+  => target list: default.ps.ps_availqty (INT4), default.ps.ps_suppkey (INT4)
+  => out schema: {(2) default.ps.ps_availqty (INT4), default.ps.ps_suppkey (INT4)}
+  => in schema: {(5) default.ps.ps_availqty (INT4), default.ps.ps_comment (TEXT), default.ps.ps_partkey (INT4), default.ps.ps_suppkey (INT4), default.ps.ps_supplycost (FLOAT8)}
+
+=======================================================
+Block Id: eb_0000000000000_0000_000006 [INTERMEDIATE]
+=======================================================
+
+[Incoming]
+[q_0000000000000_0000] 4 => 6 (type=HASH_SHUFFLE, key=default.s.s_suppkey (INT4), num=32)
+[q_0000000000000_0000] 5 => 6 (type=HASH_SHUFFLE, key=default.ps.ps_suppkey (INT4), num=32)
+
+[Outgoing]
+[q_0000000000000_0000] 6 => 7 (type=HASH_SHUFFLE, key=default.s.s_nationkey (INT4), num=32)
+
+JOIN(13)(INNER)
+  => Join Cond: default.s.s_suppkey (INT4) = default.ps.ps_suppkey (INT4)
+  => target list: default.ps.ps_availqty (INT4), default.s.s_nationkey (INT4), default.s.s_suppkey (INT4)
+  => out schema: {(3) default.ps.ps_availqty (INT4), default.s.s_nationkey (INT4), default.s.s_suppkey (INT4)}
+  => in schema: {(4) default.ps.ps_availqty (INT4), default.ps.ps_suppkey (INT4), default.s.s_nationkey (INT4), default.s.s_suppkey (INT4)}
+   SCAN(19) on eb_0000000000000_0000_000005
+     => out schema: {(2) default.ps.ps_availqty (INT4), default.ps.ps_suppkey (INT4)}
+     => in schema: {(2) default.ps.ps_availqty (INT4), default.ps.ps_suppkey (INT4)}
+   SCAN(18) on eb_0000000000000_0000_000004
+     => out schema: {(2) default.s.s_nationkey (INT4), default.s.s_suppkey (INT4)}
+     => in schema: {(2) default.s.s_nationkey (INT4), default.s.s_suppkey (INT4)}
+
+=======================================================
+Block Id: eb_0000000000000_0000_000007 [ROOT]
+=======================================================
+
+[Incoming]
+[q_0000000000000_0000] 3 => 7 (type=HASH_SHUFFLE, key=default.t.n_nationkey (INT4), num=32)
+[q_0000000000000_0000] 6 => 7 (type=HASH_SHUFFLE, key=default.s.s_nationkey (INT4), num=32)
+
+SELECTION(9)
+  => Search Cond: default.t.n_nationkey (INT4) > default.s.s_suppkey (INT4)
+   JOIN(14)(INNER)
+     => Join Cond: default.s.s_nationkey (INT4) = default.t.n_nationkey (INT4)
+     => target list: default.ps.ps_availqty (INT4), default.s.s_suppkey (INT4), default.t.n_comment (TEXT), default.t.n_name (TEXT), default.t.n_nationkey (INT4), default.t.n_regionkey (INT4)
+     => out schema: {(6) default.ps.ps_availqty (INT4), default.s.s_suppkey (INT4), default.t.n_comment (TEXT), default.t.n_name (TEXT), default.t.n_nationkey (INT4), default.t.n_regionkey (INT4)}
+     => in schema: {(7) default.ps.ps_availqty (INT4), default.s.s_nationkey (INT4), default.s.s_suppkey (INT4), default.t.n_comment (TEXT), default.t.n_name (TEXT), default.t.n_nationkey (INT4), default.t.n_regionkey (INT4)}
+      SCAN(21) on eb_0000000000000_0000_000006
+        => out schema: {(3) default.ps.ps_availqty (INT4), default.s.s_nationkey (INT4), default.s.s_suppkey (INT4)}
+        => in schema: {(3) default.ps.ps_availqty (INT4), default.s.s_nationkey (INT4), default.s.s_suppkey (INT4)}
+      SCAN(20) on eb_0000000000000_0000_000003
+        => out schema: {(4) default.t.n_nationkey (INT4), default.t.n_name (TEXT), default.t.n_regionkey (INT4), default.t.n_comment (TEXT)}
+        => in schema: {(4) default.t.n_nationkey (INT4), default.t.n_name (TEXT), default.t.n_regionkey (INT4), default.t.n_comment (TEXT)}
+
+=======================================================
+Block Id: eb_0000000000000_0000_000008 [TERMINAL]
+=======================================================

http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestInnerJoinWithSubQuery/testJoinWithMultipleJoinQual4.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestInnerJoinWithSubQuery/testJoinWithMultipleJoinQual4.result b/tajo-core/src/test/resources/results/TestInnerJoinWithSubQuery/testJoinWithMultipleJoinQual4.result
new file mode 100644
index 0000000..83eca9b
--- /dev/null
+++ b/tajo-core/src/test/resources/results/TestInnerJoinWithSubQuery/testJoinWithMultipleJoinQual4.result
@@ -0,0 +1,4 @@
+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

http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinBroadcast/testBroadcastBasicJoin.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinBroadcast/testBroadcastBasicJoin.result b/tajo-core/src/test/resources/results/TestJoinBroadcast/testBroadcastBasicJoin.result
deleted file mode 100644
index 174fd95..0000000
--- a/tajo-core/src/test/resources/results/TestJoinBroadcast/testBroadcastBasicJoin.result
+++ /dev/null
@@ -1,99 +0,0 @@
-l_orderkey,p_name,s_name
--------------------------------
-1,spring green yellow purple cornsilk,Supplier#000000004
-1,goldenrod lavender spring chocolate lace,Supplier#000000004
-1,spring green yellow purple cornsilk,Supplier#000000004
-1,blush thistle blue yellow saddle,Supplier#000000003
-1,goldenrod lavender spring chocolate lace,Supplier#000000004
-1,goldenrod lavender spring chocolate lace,Supplier#000000002
-2,blush thistle blue yellow saddle,Supplier#000000002
-3,goldenrod lavender spring chocolate lace,Supplier#000000003
-3,blush thistle blue yellow saddle,Supplier#000000002
-3,spring green yellow purple cornsilk,Supplier#000000002
-3,goldenrod lavender spring chocolate lace,Supplier#000000003
-3,spring green yellow purple cornsilk,Supplier#000000002
-3,spring green yellow purple cornsilk,Supplier#000000004
-4,goldenrod lavender spring chocolate lace,Supplier#000000004
-5,blush thistle blue yellow saddle,Supplier#000000002
-5,spring green yellow purple cornsilk,Supplier#000000002
-5,goldenrod lavender spring chocolate lace,Supplier#000000003
-6,goldenrod lavender spring chocolate lace,Supplier#000000004
-7,goldenrod lavender spring chocolate lace,Supplier#000000003
-7,blush thistle blue yellow saddle,Supplier#000000002
-7,spring green yellow purple cornsilk,Supplier#000000004
-7,goldenrod lavender spring chocolate lace,Supplier#000000002
-7,blush thistle blue yellow saddle,Supplier#000000003
-7,goldenrod lavender spring chocolate lace,Supplier#000000004
-7,blush thistle blue yellow saddle,Supplier#000000002
-32,spring green yellow purple cornsilk,Supplier#000000003
-32,spring green yellow purple cornsilk,Supplier#000000004
-32,spring green yellow purple cornsilk,Supplier#000000002
-32,goldenrod lavender spring chocolate lace,Supplier#000000003
-32,spring green yellow purple cornsilk,Supplier#000000003
-32,spring green yellow purple cornsilk,Supplier#000000002
-33,goldenrod lavender spring chocolate lace,Supplier#000000003
-33,spring green yellow purple cornsilk,Supplier#000000002
-33,spring green yellow purple cornsilk,Supplier#000000003
-33,blush thistle blue yellow saddle,Supplier#000000004
-34,spring green yellow purple cornsilk,Supplier#000000004
-34,goldenrod lavender spring chocolate lace,Supplier#000000004
-34,blush thistle blue yellow saddle,Supplier#000000004
-35,spring green yellow purple cornsilk,Supplier#000000002
-35,spring green yellow purple cornsilk,Supplier#000000003
-35,spring green yellow purple cornsilk,Supplier#000000002
-35,spring green yellow purple cornsilk,Supplier#000000004
-35,goldenrod lavender spring chocolate lace,Supplier#000000002
-35,spring green yellow purple cornsilk,Supplier#000000002
-36,spring green yellow purple cornsilk,Supplier#000000003
-37,goldenrod lavender spring chocolate lace,Supplier#000000004
-37,goldenrod lavender spring chocolate lace,Supplier#000000003
-37,goldenrod lavender spring chocolate lace,Supplier#000000002
-38,blush thistle blue yellow saddle,Supplier#000000003
-39,blush thistle blue yellow saddle,Supplier#000000002
-39,blush thistle blue yellow saddle,Supplier#000000003
-39,blush thistle blue yellow saddle,Supplier#000000004
-39,spring green yellow purple cornsilk,Supplier#000000004
-39,blush thistle blue yellow saddle,Supplier#000000003
-39,blush thistle blue yellow saddle,Supplier#000000004
-64,goldenrod lavender spring chocolate lace,Supplier#000000004
-65,spring green yellow purple cornsilk,Supplier#000000003
-65,blush thistle blue yellow saddle,Supplier#000000002
-65,spring green yellow purple cornsilk,Supplier#000000002
-66,spring green yellow purple cornsilk,Supplier#000000002
-66,spring green yellow purple cornsilk,Supplier#000000003
-67,goldenrod lavender spring chocolate lace,Supplier#000000003
-67,goldenrod lavender spring chocolate lace,Supplier#000000003
-67,goldenrod lavender spring chocolate lace,Supplier#000000004
-67,spring green yellow purple cornsilk,Supplier#000000002
-67,goldenrod lavender spring chocolate lace,Supplier#000000003
-67,blush thistle blue yellow saddle,Supplier#000000004
-68,blush thistle blue yellow saddle,Supplier#000000004
-68,goldenrod lavender spring chocolate lace,Supplier#000000003
-68,blush thistle blue yellow saddle,Supplier#000000003
-68,blush thistle blue yellow saddle,Supplier#000000003
-68,spring green yellow purple cornsilk,Supplier#000000004
-68,goldenrod lavender spring chocolate lace,Supplier#000000003
-68,goldenrod lavender spring chocolate lace,Supplier#000000004
-69,spring green yellow purple cornsilk,Supplier#000000002
-69,blush thistle blue yellow saddle,Supplier#000000002
-69,blush thistle blue yellow saddle,Supplier#000000002
-69,spring green yellow purple cornsilk,Supplier#000000004
-69,spring green yellow purple cornsilk,Supplier#000000004
-69,blush thistle blue yellow saddle,Supplier#000000002
-70,spring green yellow purple cornsilk,Supplier#000000004
-70,spring green yellow purple cornsilk,Supplier#000000002
-70,blush thistle blue yellow saddle,Supplier#000000002
-70,blush thistle blue yellow saddle,Supplier#000000002
-70,blush thistle blue yellow saddle,Supplier#000000002
-70,spring green yellow purple cornsilk,Supplier#000000002
-71,spring green yellow purple cornsilk,Supplier#000000002
-71,spring green yellow purple cornsilk,Supplier#000000002
-71,spring green yellow purple cornsilk,Supplier#000000003
-71,spring green yellow purple cornsilk,Supplier#000000002
-71,spring green yellow purple cornsilk,Supplier#000000002
-71,goldenrod lavender spring chocolate lace,Supplier#000000003
-96,goldenrod lavender spring chocolate lace,Supplier#000000002
-96,spring green yellow purple cornsilk,Supplier#000000004
-97,goldenrod lavender spring chocolate lace,Supplier#000000003
-97,goldenrod lavender spring chocolate lace,Supplier#000000003
-97,goldenrod lavender spring chocolate lace,Supplier#000000002
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinBroadcast/testBroadcastMultiColumnPartitionTable.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinBroadcast/testBroadcastMultiColumnPartitionTable.result b/tajo-core/src/test/resources/results/TestJoinBroadcast/testBroadcastMultiColumnPartitionTable.result
deleted file mode 100644
index 9ef26b4..0000000
--- a/tajo-core/src/test/resources/results/TestJoinBroadcast/testBroadcastMultiColumnPartitionTable.result
+++ /dev/null
@@ -1,5 +0,0 @@
-col3
--------------------------------
-01
-12
-10
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinBroadcast/testBroadcastMultiColumnPartitionTableInFilter.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinBroadcast/testBroadcastMultiColumnPartitionTableInFilter.result b/tajo-core/src/test/resources/results/TestJoinBroadcast/testBroadcastMultiColumnPartitionTableInFilter.result
deleted file mode 100644
index e69de29..0000000

http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinBroadcast/testBroadcastPartitionTable.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinBroadcast/testBroadcastPartitionTable.result b/tajo-core/src/test/resources/results/TestJoinBroadcast/testBroadcastPartitionTable.result
deleted file mode 100644
index c03a275..0000000
--- a/tajo-core/src/test/resources/results/TestJoinBroadcast/testBroadcastPartitionTable.result
+++ /dev/null
@@ -1,5 +0,0 @@
-c_custkey,c_name,c_nationkey,n_nationkey,o_orderkey
--------------------------------
-2,Customer#000000002,13,13,3
-3,Customer#000000003,1,1,1
-4,Customer#000000004,4,4,2
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinBroadcast/testBroadcastSubquery.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinBroadcast/testBroadcastSubquery.result b/tajo-core/src/test/resources/results/TestJoinBroadcast/testBroadcastSubquery.result
deleted file mode 100644
index d95e0c9..0000000
--- a/tajo-core/src/test/resources/results/TestJoinBroadcast/testBroadcastSubquery.result
+++ /dev/null
@@ -1,15 +0,0 @@
-l_orderkey,o_custkey,p_name
--------------------------------
-1,3,blush thistle blue yellow saddle
-1,3,goldenrod lavender spring chocolate lace
-1,3,goldenrod lavender spring chocolate lace
-1,3,goldenrod lavender spring chocolate lace
-1,3,spring green yellow purple cornsilk
-1,3,spring green yellow purple cornsilk
-2,4,blush thistle blue yellow saddle
-3,2,blush thistle blue yellow saddle
-3,2,goldenrod lavender spring chocolate lace
-3,2,goldenrod lavender spring chocolate lace
-3,2,spring green yellow purple cornsilk
-3,2,spring green yellow purple cornsilk
-3,2,spring green yellow purple cornsilk
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinBroadcast/testBroadcastSubquery2.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinBroadcast/testBroadcastSubquery2.result b/tajo-core/src/test/resources/results/TestJoinBroadcast/testBroadcastSubquery2.result
deleted file mode 100644
index 9368976..0000000
--- a/tajo-core/src/test/resources/results/TestJoinBroadcast/testBroadcastSubquery2.result
+++ /dev/null
@@ -1,3 +0,0 @@
-?sum
--------------------------------
-190.0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinBroadcast/testBroadcastTwoPartJoin.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinBroadcast/testBroadcastTwoPartJoin.result b/tajo-core/src/test/resources/results/TestJoinBroadcast/testBroadcastTwoPartJoin.result
deleted file mode 100644
index 1a3d68c..0000000
--- a/tajo-core/src/test/resources/results/TestJoinBroadcast/testBroadcastTwoPartJoin.result
+++ /dev/null
@@ -1,15 +0,0 @@
-l_orderkey,p_name,n_name
--------------------------------
-3,goldenrod lavender spring chocolate lace,GERMANY
-3,blush thistle blue yellow saddle,GERMANY
-3,spring green yellow purple cornsilk,GERMANY
-3,goldenrod lavender spring chocolate lace,GERMANY
-3,spring green yellow purple cornsilk,GERMANY
-3,spring green yellow purple cornsilk,GERMANY
-1,spring green yellow purple cornsilk,GERMANY
-1,goldenrod lavender spring chocolate lace,GERMANY
-1,spring green yellow purple cornsilk,GERMANY
-1,blush thistle blue yellow saddle,GERMANY
-1,goldenrod lavender spring chocolate lace,GERMANY
-1,goldenrod lavender spring chocolate lace,GERMANY
-2,blush thistle blue yellow saddle,IRAN
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/4b1b7799/tajo-core/src/test/resources/results/TestJoinBroadcast/testCrossJoin.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinBroadcast/testCrossJoin.result b/tajo-core/src/test/resources/results/TestJoinBroadcast/testCrossJoin.result
deleted file mode 100644
index 607adc4..0000000
--- a/tajo-core/src/test/resources/results/TestJoinBroadcast/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/TestJoinBroadcast/testCrossJoinAndCaseWhen.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinBroadcast/testCrossJoinAndCaseWhen.result b/tajo-core/src/test/resources/results/TestJoinBroadcast/testCrossJoinAndCaseWhen.result
deleted file mode 100644
index a4c33f8..0000000
--- a/tajo-core/src/test/resources/results/TestJoinBroadcast/testCrossJoinAndCaseWhen.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/TestJoinBroadcast/testCrossJoinWithAsterisk1.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinBroadcast/testCrossJoinWithAsterisk1.result b/tajo-core/src/test/resources/results/TestJoinBroadcast/testCrossJoinWithAsterisk1.result
deleted file mode 100644
index f4e8c88..0000000
--- a/tajo-core/src/test/resources/results/TestJoinBroadcast/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/TestJoinBroadcast/testCrossJoinWithAsterisk2.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinBroadcast/testCrossJoinWithAsterisk2.result b/tajo-core/src/test/resources/results/TestJoinBroadcast/testCrossJoinWithAsterisk2.result
deleted file mode 100644
index f4e8c88..0000000
--- a/tajo-core/src/test/resources/results/TestJoinBroadcast/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/TestJoinBroadcast/testCrossJoinWithAsterisk3.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinBroadcast/testCrossJoinWithAsterisk3.result b/tajo-core/src/test/resources/results/TestJoinBroadcast/testCrossJoinWithAsterisk3.result
deleted file mode 100644
index 9db83f0..0000000
--- a/tajo-core/src/test/resources/results/TestJoinBroadcast/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/TestJoinBroadcast/testCrossJoinWithAsterisk4.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinBroadcast/testCrossJoinWithAsterisk4.result b/tajo-core/src/test/resources/results/TestJoinBroadcast/testCrossJoinWithAsterisk4.result
deleted file mode 100644
index 23d985e..0000000
--- a/tajo-core/src/test/resources/results/TestJoinBroadcast/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/TestJoinBroadcast/testCrossJoinWithEmptyTable1.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinBroadcast/testCrossJoinWithEmptyTable1.result b/tajo-core/src/test/resources/results/TestJoinBroadcast/testCrossJoinWithEmptyTable1.result
deleted file mode 100644
index 6f07515..0000000
--- a/tajo-core/src/test/resources/results/TestJoinBroadcast/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/TestJoinBroadcast/testFullOuterJoin1.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinBroadcast/testFullOuterJoin1.result b/tajo-core/src/test/resources/results/TestJoinBroadcast/testFullOuterJoin1.result
deleted file mode 100644
index 695a414..0000000
--- a/tajo-core/src/test/resources/results/TestJoinBroadcast/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/TestJoinBroadcast/testFullOuterJoinWithEmptyTable1.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinBroadcast/testFullOuterJoinWithEmptyTable1.result b/tajo-core/src/test/resources/results/TestJoinBroadcast/testFullOuterJoinWithEmptyTable1.result
deleted file mode 100644
index 5b849fc..0000000
--- a/tajo-core/src/test/resources/results/TestJoinBroadcast/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/TestJoinBroadcast/testInnerJoinWithEmptyTable.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinBroadcast/testInnerJoinWithEmptyTable.result b/tajo-core/src/test/resources/results/TestJoinBroadcast/testInnerJoinWithEmptyTable.result
deleted file mode 100644
index 6f07515..0000000
--- a/tajo-core/src/test/resources/results/TestJoinBroadcast/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/TestJoinBroadcast/testJoinCoReferredEvals1.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinBroadcast/testJoinCoReferredEvals1.result b/tajo-core/src/test/resources/results/TestJoinBroadcast/testJoinCoReferredEvals1.result
deleted file mode 100644
index b24e47e..0000000
--- a/tajo-core/src/test/resources/results/TestJoinBroadcast/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/TestJoinBroadcast/testJoinCoReferredEvalsWithSameExprs1.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinBroadcast/testJoinCoReferredEvalsWithSameExprs1.result b/tajo-core/src/test/resources/results/TestJoinBroadcast/testJoinCoReferredEvalsWithSameExprs1.result
deleted file mode 100644
index 23776b6..0000000
--- a/tajo-core/src/test/resources/results/TestJoinBroadcast/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/TestJoinBroadcast/testJoinCoReferredEvalsWithSameExprs2.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinBroadcast/testJoinCoReferredEvalsWithSameExprs2.result b/tajo-core/src/test/resources/results/TestJoinBroadcast/testJoinCoReferredEvalsWithSameExprs2.result
deleted file mode 100644
index 0e31362..0000000
--- a/tajo-core/src/test/resources/results/TestJoinBroadcast/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/TestJoinBroadcast/testJoinOnMultipleDatabases.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinBroadcast/testJoinOnMultipleDatabases.result b/tajo-core/src/test/resources/results/TestJoinBroadcast/testJoinOnMultipleDatabases.result
deleted file mode 100644
index dc0968f..0000000
--- a/tajo-core/src/test/resources/results/TestJoinBroadcast/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/TestJoinBroadcast/testLeftOuterJoin1.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinBroadcast/testLeftOuterJoin1.result b/tajo-core/src/test/resources/results/TestJoinBroadcast/testLeftOuterJoin1.result
deleted file mode 100644
index 9e2a53a..0000000
--- a/tajo-core/src/test/resources/results/TestJoinBroadcast/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/TestJoinBroadcast/testLeftOuterJoin2.result
----------------------------------------------------------------------
diff --git a/tajo-core/src/test/resources/results/TestJoinBroadcast/testLeftOuterJoin2.result b/tajo-core/src/test/resources/results/TestJoinBroadcast/testLeftOuterJoin2.result
deleted file mode 100644
index ee73754..0000000
--- a/tajo-core/src/test/resources/results/TestJoinBroadcast/testLeftOuterJoin2.result
+++ /dev/null
@@ -1,99 +0,0 @@
-l_orderkey,c_custkey,c_name,c_nationkey,n_name
--------------------------------
-1,1,Customer#000000001,10,ARGENTINA
-1,1,Customer#000000001,10,ARGENTINA
-1,1,Customer#000000001,10,ARGENTINA
-1,1,Customer#000000001,10,ARGENTINA
-1,1,Customer#000000001,10,ARGENTINA
-1,1,Customer#000000001,10,ARGENTINA
-2,2,Customer#000000002,7,BRAZIL
-3,3,Customer#000000003,7,CANADA
-3,3,Customer#000000003,7,CANADA
-3,3,Customer#000000003,7,CANADA
-3,3,Customer#000000003,7,CANADA
-3,3,Customer#000000003,7,CANADA
-3,3,Customer#000000003,7,CANADA
-4,4,Customer#000000004,10,EGYPT
-5,5,Customer#000000005,5,ETHIOPIA
-5,5,Customer#000000005,5,ETHIOPIA
-5,5,Customer#000000005,5,ETHIOPIA
-6,6,Customer#000000006,17,FRANCE
-7,7,Customer#000000007,21,GERMANY
-7,7,Customer#000000007,21,GERMANY
-7,7,Customer#000000007,21,GERMANY
-7,7,Customer#000000007,21,GERMANY
-7,7,Customer#000000007,21,GERMANY
-7,7,Customer#000000007,21,GERMANY
-7,7,Customer#000000007,21,GERMANY
-32,32,Customer#000000032,15,null
-32,32,Customer#000000032,15,null
-32,32,Customer#000000032,15,null
-32,32,Customer#000000032,15,null
-32,32,Customer#000000032,15,null
-32,32,Customer#000000032,15,null
-33,33,Customer#000000033,4,null
-33,33,Customer#000000033,4,null
-33,33,Customer#000000033,4,null
-33,33,Customer#000000033,4,null
-34,34,Customer#000000034,11,null
-34,34,Customer#000000034,11,null
-34,34,Customer#000000034,11,null
-35,35,Customer#000000035,22,null
-35,35,Customer#000000035,22,null
-35,35,Customer#000000035,22,null
-35,35,Customer#000000035,22,null
-35,35,Customer#000000035,22,null
-35,35,Customer#000000035,22,null
-36,36,Customer#000000036,15,null
-37,37,Customer#000000037,11,null
-37,37,Customer#000000037,11,null
-37,37,Customer#000000037,11,null
-38,38,Customer#000000038,14,null
-39,39,Customer#000000039,3,null
-39,39,Customer#000000039,3,null
-39,39,Customer#000000039,3,null
-39,39,Customer#000000039,3,null
-39,39,Customer#000000039,3,null
-39,39,Customer#000000039,3,null
-64,64,Customer#000000064,15,null
-65,65,Customer#000000065,10,null
-65,65,Customer#000000065,10,null
-65,65,Customer#000000065,10,null
-66,66,Customer#000000066,1,null
-66,66,Customer#000000066,1,null
-67,67,Customer#000000067,0,null
-67,67,Customer#000000067,0,null
-67,67,Customer#000000067,0,null
-67,67,Customer#000000067,0,null
-67,67,Customer#000000067,0,null
-67,67,Customer#000000067,0,null
-68,68,Customer#000000068,3,null
-68,68,Customer#000000068,3,null
-68,68,Customer#000000068,3,null
-68,68,Customer#000000068,3,null
-68,68,Customer#000000068,3,null
-68,68,Customer#000000068,3,null
-68,68,Customer#000000068,3,null
-69,69,Customer#000000069,13,null
-69,69,Customer#000000069,13,null
-69,69,Customer#000000069,13,null
-69,69,Customer#000000069,13,null
-69,69,Customer#000000069,13,null
-69,69,Customer#000000069,13,null
-70,70,Customer#000000070,3,null
-70,70,Customer#000000070,3,null
-70,70,Customer#000000070,3,null
-70,70,Customer#000000070,3,null
-70,70,Customer#000000070,3,null
-70,70,Customer#000000070,3,null
-71,71,Customer#000000071,16,null
-71,71,Customer#000000071,16,null
-71,71,Customer#000000071,16,null
-71,71,Customer#000000071,16,null
-71,71,Customer#000000071,16,null
-71,71,Customer#000000071,16,null
-96,96,Customer#000000096,7,null
-96,96,Customer#000000096,7,null
-97,97,Customer#000000097,16,null
-97,97,Customer#000000097,16,null
-97,97,Customer#000000097,16,null
\ No newline at end of file


Mime
View raw message