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
