tajo-core-tests/src/test/resources/results/TestTPCH/testFirstJoinInQ7.plan

explain
-------------------------------
UNION(8)
   PROJECTION(7)
     => Targets: supp_nation (TEXT), cust_nation (TEXT), s_nationkey (INT4), c_nationkey (INT4)
     => out schema: {(4) supp_nation (TEXT), cust_nation (TEXT), s_nationkey (INT4), c_nationkey (INT4)}
     => in  schema: {(4) supp_nation (TEXT), cust_nation (TEXT), s_nationkey (INT4), c_nationkey (INT4)}
      JOIN(11)(CROSS)
        => target list: c_nationkey (INT4), cust_nation (TEXT), s_nationkey (INT4), supp_nation (TEXT)
        => out schema: {(4) c_nationkey (INT4), cust_nation (TEXT), s_nationkey (INT4), supp_nation (TEXT)}
        => in schema: {(4) c_nationkey (INT4), cust_nation (TEXT), s_nationkey (INT4), supp_nation (TEXT)}
         SCAN(4) on default.nation as n1
           => filter: default.n1.n_name (TEXT) = GERMANY
           => target list: default.n1.n_nationkey (INT4) as s_nationkey, default.n1.n_name (TEXT) as supp_nation
           => out schema: {(2) s_nationkey (INT4), supp_nation (TEXT)}
           => in schema: {(4) default.n1.n_comment (TEXT), default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n1.n_regionkey (INT4)}
         SCAN(5) on default.nation as n2
           => filter: default.n2.n_name (TEXT) = FRANCE
           => target list: default.n2.n_nationkey (INT4) as c_nationkey, default.n2.n_name (TEXT) as cust_nation
           => out schema: {(2) c_nationkey (INT4), cust_nation (TEXT)}
           => in schema: {(4) default.n2.n_comment (TEXT), default.n2.n_name (TEXT), default.n2.n_nationkey (INT4), default.n2.n_regionkey (INT4)}
   PROJECTION(3)
     => Targets: supp_nation (TEXT), cust_nation (TEXT), s_nationkey (INT4), c_nationkey (INT4)
     => out schema: {(4) supp_nation (TEXT), cust_nation (TEXT), s_nationkey (INT4), c_nationkey (INT4)}
     => in  schema: {(4) supp_nation (TEXT), cust_nation (TEXT), s_nationkey (INT4), c_nationkey (INT4)}
      JOIN(10)(CROSS)
        => target list: c_nationkey (INT4), cust_nation (TEXT), s_nationkey (INT4), supp_nation (TEXT)
        => out schema: {(4) c_nationkey (INT4), cust_nation (TEXT), s_nationkey (INT4), supp_nation (TEXT)}
        => in schema: {(4) c_nationkey (INT4), cust_nation (TEXT), s_nationkey (INT4), supp_nation (TEXT)}
         SCAN(0) on default.nation as n1
           => filter: default.n1.n_name (TEXT) = FRANCE
           => target list: default.n1.n_nationkey (INT4) as s_nationkey, default.n1.n_name (TEXT) as supp_nation
           => out schema: {(2) s_nationkey (INT4), supp_nation (TEXT)}
           => in schema: {(4) default.n1.n_comment (TEXT), default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n1.n_regionkey (INT4)}
         SCAN(1) on default.nation as n2
           => filter: default.n2.n_name (TEXT) = GERMANY
           => target list: default.n2.n_nationkey (INT4) as c_nationkey, default.n2.n_name (TEXT) as cust_nation
           => out schema: {(2) c_nationkey (INT4), cust_nation (TEXT)}
           => in schema: {(4) default.n2.n_comment (TEXT), default.n2.n_name (TEXT), default.n2.n_nationkey (INT4), default.n2.n_regionkey (INT4)}
explain
-------------------------------
-------------------------------------------------------------------------------
Execution Block Graph (TERMINAL - eb_0000000000000_0000_000007)
-------------------------------------------------------------------------------
|-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
-------------------------------------------------------------------------------

=======================================================
Block Id: eb_0000000000000_0000_000001 [LEAF]
=======================================================

[Outgoing]
[q_0000000000000_0000] 1 => 3 (type=HASH_SHUFFLE)

SCAN(1) on default.nation as n2
  => filter: default.n2.n_name (TEXT) = GERMANY
  => target list: default.n2.n_nationkey (INT4) as c_nationkey, default.n2.n_name (TEXT) as cust_nation
  => out schema: {(2) c_nationkey (INT4), cust_nation (TEXT)}
  => in schema: {(4) default.n2.n_comment (TEXT), default.n2.n_name (TEXT), default.n2.n_nationkey (INT4), default.n2.n_regionkey (INT4)}

=======================================================
Block Id: eb_0000000000000_0000_000002 [LEAF]
=======================================================

[Outgoing]
[q_0000000000000_0000] 2 => 3 (type=HASH_SHUFFLE)

SCAN(0) on default.nation as n1
  => filter: default.n1.n_name (TEXT) = FRANCE
  => target list: default.n1.n_nationkey (INT4) as s_nationkey, default.n1.n_name (TEXT) as supp_nation
  => out schema: {(2) s_nationkey (INT4), supp_nation (TEXT)}
  => in schema: {(4) default.n1.n_comment (TEXT), default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n1.n_regionkey (INT4)}

=======================================================
Block Id: eb_0000000000000_0000_000004 [LEAF]
=======================================================

[Outgoing]
[q_0000000000000_0000] 4 => 6 (type=HASH_SHUFFLE)

SCAN(5) on default.nation as n2
  => filter: default.n2.n_name (TEXT) = FRANCE
  => target list: default.n2.n_nationkey (INT4) as c_nationkey, default.n2.n_name (TEXT) as cust_nation
  => out schema: {(2) c_nationkey (INT4), cust_nation (TEXT)}
  => in schema: {(4) default.n2.n_comment (TEXT), default.n2.n_name (TEXT), default.n2.n_nationkey (INT4), default.n2.n_regionkey (INT4)}

=======================================================
Block Id: eb_0000000000000_0000_000005 [LEAF]
=======================================================

[Outgoing]
[q_0000000000000_0000] 5 => 6 (type=HASH_SHUFFLE)

SCAN(4) on default.nation as n1
  => filter: default.n1.n_name (TEXT) = GERMANY
  => target list: default.n1.n_nationkey (INT4) as s_nationkey, default.n1.n_name (TEXT) as supp_nation
  => out schema: {(2) s_nationkey (INT4), supp_nation (TEXT)}
  => in schema: {(4) default.n1.n_comment (TEXT), default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n1.n_regionkey (INT4)}

=======================================================
Block Id: eb_0000000000000_0000_000003 [ROOT]
=======================================================

[Incoming]
[q_0000000000000_0000] 1 => 3 (type=HASH_SHUFFLE)
[q_0000000000000_0000] 2 => 3 (type=HASH_SHUFFLE)

JOIN(10)(CROSS)
  => target list: c_nationkey (INT4), cust_nation (TEXT), s_nationkey (INT4), supp_nation (TEXT)
  => out schema: {(4) c_nationkey (INT4), cust_nation (TEXT), s_nationkey (INT4), supp_nation (TEXT)}
  => in schema: {(4) c_nationkey (INT4), cust_nation (TEXT), s_nationkey (INT4), supp_nation (TEXT)}
   SCAN(14) on eb_0000000000000_0000_000002
     => out schema: {(2) s_nationkey (INT4), supp_nation (TEXT)}
     => in schema: {(2) s_nationkey (INT4), supp_nation (TEXT)}
   SCAN(13) on eb_0000000000000_0000_000001
     => out schema: {(2) c_nationkey (INT4), cust_nation (TEXT)}
     => in schema: {(2) c_nationkey (INT4), cust_nation (TEXT)}

=======================================================
Block Id: eb_0000000000000_0000_000006 [ROOT]
=======================================================

[Incoming]
[q_0000000000000_0000] 4 => 6 (type=HASH_SHUFFLE)
[q_0000000000000_0000] 5 => 6 (type=HASH_SHUFFLE)

JOIN(11)(CROSS)
  => target list: c_nationkey (INT4), cust_nation (TEXT), s_nationkey (INT4), supp_nation (TEXT)
  => out schema: {(4) c_nationkey (INT4), cust_nation (TEXT), s_nationkey (INT4), supp_nation (TEXT)}
  => in schema: {(4) c_nationkey (INT4), cust_nation (TEXT), s_nationkey (INT4), supp_nation (TEXT)}
   SCAN(16) on eb_0000000000000_0000_000005
     => out schema: {(2) s_nationkey (INT4), supp_nation (TEXT)}
     => in schema: {(2) s_nationkey (INT4), supp_nation (TEXT)}
   SCAN(15) on eb_0000000000000_0000_000004
     => out schema: {(2) c_nationkey (INT4), cust_nation (TEXT)}
     => in schema: {(2) c_nationkey (INT4), cust_nation (TEXT)}

=======================================================
Block Id: eb_0000000000000_0000_000007 [TERMINAL]
=======================================================