See <https://builds.apache.org/job/Tajo-0.11.0-build/33/changes>
Changes: [jihoonson] TAJO-1833: Refine LogicalPlanPreprocessor to add new rules easily. ------------------------------------------ [...truncated 107858 lines...] 2015-09-10 13:10:54,932 INFO: org.apache.tajo.worker.TaskImpl (getLocalStoredFileChunk(734)) - getLocalStoredFileChunk starts 2015-09-10 13:10:54,932 INFO: org.apache.tajo.worker.TaskImpl (getLocalStoredFileChunk(769)) - PullServer request param: shuffleType=h, sid=5, partId=0, taskIds=null 2015-09-10 13:10:54,933 INFO: org.apache.tajo.worker.TaskImpl (getFetchRunners(720)) - Create a new Fetcher with storeChunk: (start=0, length=145, fromRemote=false, ebId=eb_1441890523948_0282_000005) <https://builds.apache.org/job/Tajo-0.11.0-build/ws/tajo-core-tests/target/test-data/07d35241-36f9-4472-a9e5-f5c8a9fcd452/tajo-localdir/q_1441890523948_0282/output/5/hash-shuffle/0/0> 2015-09-10 13:10:54,933 INFO: org.apache.tajo.worker.TaskImpl (getFetchRunners(692)) - Try to get local file chunk at local host 2015-09-10 13:10:54,933 INFO: org.apache.tajo.worker.TaskImpl (getLocalStoredFileChunk(734)) - getLocalStoredFileChunk starts 2015-09-10 13:10:54,933 INFO: org.apache.tajo.worker.TaskImpl (getLocalStoredFileChunk(769)) - PullServer request param: shuffleType=h, sid=6, partId=0, taskIds=null 2015-09-10 13:10:54,934 INFO: org.apache.tajo.worker.TaskImpl (getFetchRunners(720)) - Create a new Fetcher with storeChunk: (start=0, length=402, fromRemote=false, ebId=eb_1441890523948_0282_000006) <https://builds.apache.org/job/Tajo-0.11.0-build/ws/tajo-core-tests/target/test-data/07d35241-36f9-4472-a9e5-f5c8a9fcd452/tajo-localdir/q_1441890523948_0282/output/6/hash-shuffle/0/0> 2015-09-10 13:10:54,934 INFO: org.apache.tajo.worker.TaskAttemptContext (setState(142)) - Query status of ta_1441890523948_0282_000007_000000_00 is changed to TA_RUNNING 2015-09-10 13:10:54,934 INFO: org.apache.tajo.worker.Fetcher (get(128)) - Get pseudo fetch from local host 2015-09-10 13:10:54,934 INFO: org.apache.tajo.worker.Fetcher (get(128)) - Get pseudo fetch from local host 2015-09-10 13:10:54,934 INFO: org.apache.tajo.worker.TaskImpl (run(616)) - Add a new FileChunk to local chunk list 2015-09-10 13:10:54,934 INFO: org.apache.tajo.worker.TaskImpl (run(616)) - Add a new FileChunk to local chunk list 2015-09-10 13:10:54,935 INFO: org.apache.tajo.worker.TaskImpl (waitForFetch(362)) - ta_1441890523948_0282_000007_000000_00 All fetches are done! 2015-09-10 13:10:54,935 INFO: org.apache.tajo.worker.TaskImpl (localizeFetchedData(572)) - One local chunk is added to listTablets 2015-09-10 13:10:54,936 INFO: org.apache.tajo.worker.TaskImpl (localizeFetchedData(572)) - One local chunk is added to listTablets 2015-09-10 13:10:54,936 INFO: org.apache.tajo.engine.planner.PhysicalPlannerImpl (createBestLeftOuterJoinPlan(507)) - Left Outer Join (11) chooses [Merge Join]. 2015-09-10 13:10:54,936 INFO: org.apache.tajo.engine.planner.PhysicalPlannerImpl (createRightOuterMergeJoinPlan(539)) - Right Outer Join (11) chooses [Merge Join]. 2015-09-10 13:10:54,940 INFO: org.apache.tajo.engine.planner.physical.ExternalSortExec (info(70)) - [ta_1441890523948_0282_000007_000000_00] Chunks creation time: 0 msec 2015-09-10 13:10:54,940 INFO: org.apache.tajo.engine.planner.physical.ExternalSortExec (info(70)) - [ta_1441890523948_0282_000007_000000_00] Chunks creation time: 0 msec 2015-09-10 13:10:54,945 INFO: BlockStateChange (logAddStoredBlock(2624)) - BLOCK* addStoredBlock: blockMap updated: 127.0.0.1:41932 is added to blk_1073742475_1651{UCState=UNDER_CONSTRUCTION, truncateBlock=null, primaryNodeIndex=-1, replicas=[ReplicaUC[[DISK]DS-41c2524e-93d1-4cb9-bbd0-b6758436bbe0:NORMAL:127.0.0.1:41932|RBW]]} size 0 2015-09-10 13:10:54,946 INFO: org.apache.tajo.worker.TaskAttemptContext (setState(142)) - Query status of ta_1441890523948_0282_000007_000000_00 is changed to TA_SUCCEEDED 2015-09-10 13:10:54,946 INFO: org.apache.tajo.worker.TaskImpl (run(460)) - ta_1441890523948_0282_000007_000000_00 completed. Worker's task counter - total:1, succeeded: 1, killed: 0, failed: 0 2015-09-10 13:10:54,947 INFO: org.apache.tajo.querymaster.Stage (transition(1345)) - Stage - eb_1441890523948_0282_000007 finalize NONE_SHUFFLE (total=1, success=1, killed=0) 2015-09-10 13:10:54,947 INFO: org.apache.tajo.querymaster.DefaultTaskScheduler (stop(160)) - Task Scheduler stopped 2015-09-10 13:10:54,947 INFO: org.apache.tajo.querymaster.DefaultTaskScheduler (run(123)) - TaskScheduler schedulingThread stopped 2015-09-10 13:10:54,948 INFO: org.apache.tajo.querymaster.Stage (transition(1403)) - Stage completed - eb_1441890523948_0282_000007 (total=1, success=1, killed=0) 2015-09-10 13:10:54,948 INFO: org.apache.tajo.querymaster.Query (handle(855)) - Processing q_1441890523948_0282 of type STAGE_COMPLETED 2015-09-10 13:10:54,948 INFO: org.apache.tajo.engine.planner.global.ParallelExecutionQueue (next(95)) - Next executable block eb_1441890523948_0282_000008 2015-09-10 13:10:54,948 INFO: org.apache.tajo.worker.TaskManager (stopExecutionBlock(161)) - Stopped execution block:eb_1441890523948_0282_000007 2015-09-10 13:10:54,948 INFO: org.apache.tajo.querymaster.Query (transition(802)) - Complete Stage[eb_1441890523948_0282_000007], State: SUCCEEDED, 7/7. 2015-09-10 13:10:54,948 INFO: org.apache.tajo.querymaster.Query (handle(855)) - Processing q_1441890523948_0282 of type QUERY_COMPLETED 2015-09-10 13:10:54,950 INFO: org.apache.tajo.querymaster.Query (handle(873)) - q_1441890523948_0282 Query Transitioned from QUERY_RUNNING to QUERY_SUCCEEDED 2015-09-10 13:10:54,950 INFO: org.apache.tajo.querymaster.QueryMasterTask (handle(292)) - Query completion notified from q_1441890523948_0282 final state: QUERY_SUCCEEDED 2015-09-10 13:10:54,950 INFO: org.apache.tajo.master.QueryInProgress (heartbeat(253)) - Received QueryMaster heartbeat:q_1441890523948_0282,state=QUERY_SUCCEEDED,progress=1.0, queryMaster=asf907.gq1.ygridcore.net 2015-09-10 13:10:54,950 INFO: org.apache.tajo.master.QueryManager (stopQuery(279)) - Stop QueryInProgress:q_1441890523948_0282 2015-09-10 13:10:54,950 INFO: org.apache.tajo.querymaster.QueryMasterTask (serviceStop(169)) - Stopping QueryMasterTask:q_1441890523948_0282 2015-09-10 13:10:54,950 INFO: org.apache.tajo.master.QueryInProgress (stopProgress(118)) - ========================================================= 2015-09-10 13:10:54,951 INFO: org.apache.tajo.master.QueryInProgress (stopProgress(119)) - Stop query:q_1441890523948_0282 2015-09-10 13:10:54,951 INFO: org.apache.tajo.querymaster.QueryMasterTask (cleanupQuery(469)) - Cleanup resources of all workers. Query: q_1441890523948_0282, workers: 1 2015-09-10 13:10:54,951 INFO: org.apache.tajo.querymaster.QueryMasterTask (serviceStop(185)) - Stopped QueryMasterTask:q_1441890523948_0282 2015-09-10 13:10:55,024 INFO: org.apache.tajo.storage.FileTablespace (listStatus(368)) - Total input paths to process : 1 2015-09-10 13:10:55,026 INFO: org.apache.tajo.storage.FileTablespace (getSplits(569)) - Total # of splits: 1 2015-09-10 13:10:55,030 INFO: org.apache.tajo.master.TajoMasterClientService (getQueryResultData(579)) - Send result to client for aba23fba-2378-4ae6-89b9-305cad4ce629,q_1441890523948_0282, 5 rows 2015-09-10 13:10:55,030 INFO: org.apache.tajo.master.TajoMasterClientService (getQueryResultData(579)) - Send result to client for aba23fba-2378-4ae6-89b9-305cad4ce629,q_1441890523948_0282, 0 rows 2015-09-10 13:10:55,032 INFO: BlockStateChange (addToInvalidates(1106)) - BLOCK* addToInvalidates: blk_1073742475_1651 127.0.0.1:41932 2015-09-10 13:10:55,034 INFO: org.apache.tajo.master.GlobalEngine (executeQuery(176)) - Query: explain select a.c_custkey, a.c_name, a.c_nationkey, b.l_orderkey, c.o_orderdate, d.o_orderdate, e.n_name, f.p_name from customer a left outer join lineitem b on a.c_custkey = b.l_orderkey left outer join orders c on b.l_orderkey = c.o_orderkey left outer join orders d on a.c_custkey = d.o_orderkey left outer join nation e on d.o_orderkey = e.n_nationkey left outer join part f on f.p_partkey = d.o_orderkey 2015-09-10 13:10:55,097 INFO: org.apache.tajo.master.GlobalEngine (createLogicalPlan(280)) - Non Optimized Query: ----------------------------- Query Block Graph ----------------------------- |-#ROOT ----------------------------- Optimization Log: ----------------------------- PROJECTION(11) => Targets: default.a.c_custkey (INT4), default.a.c_name (TEXT), default.a.c_nationkey (INT4), default.b.l_orderkey (INT4), default.c.o_orderdate (TEXT), default.d.o_orderdate (TEXT), default.e.n_name (TEXT), default.f.p_name (TEXT) => out schema: {(8) default.a.c_custkey (INT4), default.a.c_name (TEXT), default.a.c_nationkey (INT4), default.b.l_orderkey (INT4), default.c.o_orderdate (TEXT), default.d.o_orderdate (TEXT), default.e.n_name (TEXT), default.f.p_name (TEXT)} => in schema: {(60) default.a.c_custkey (INT4), default.a.c_name (TEXT), default.a.c_address (TEXT), default.a.c_nationkey (INT4), default.a.c_phone (TEXT), default.a.c_acctbal (FLOAT8), default.a.c_mktsegment (TEXT), default.a.c_comment (TEXT), default.b.l_orderkey (INT4), default.b.l_partkey (INT4), default.b.l_suppkey (INT4), default.b.l_linenumber (INT4), default.b.l_quantity (FLOAT8), default.b.l_extendedprice (FLOAT8), default.b.l_discount (FLOAT8), default.b.l_tax (FLOAT8), default.b.l_returnflag (TEXT), default.b.l_linestatus (TEXT), default.b.l_shipdate (TEXT), default.b.l_commitdate (TEXT), default.b.l_receiptdate (TEXT), default.b.l_shipinstruct (TEXT), default.b.l_shipmode (TEXT), default.b.l_comment (TEXT), ?equals_4 (BOOLEAN), default.c.o_orderkey (INT4), default.c.o_custkey (INT4), default.c.o_orderstatus (TEXT), default.c.o_totalprice (FLOAT8), default.c.o_orderdate (TEXT), default.c.o_orderpriority (TEXT), default.c.o_clerk (TEXT), default.c.o_shippriority (INT4), default.c.o_comment (TEXT), ?equals_3 (BOOLEAN), default.d.o_orderkey (INT4), default.d.o_custkey (INT4), default.d.o_orderstatus (TEXT), default.d.o_totalprice (FLOAT8), default.d.o_orderdate (TEXT), default.d.o_orderpriority (TEXT), default.d.o_clerk (TEXT), default.d.o_shippriority (INT4), default.d.o_comment (TEXT), ?equals_2 (BOOLEAN), default.e.n_nationkey (INT4), default.e.n_name (TEXT), default.e.n_regionkey (INT4), default.e.n_comment (TEXT), ?equals_1 (BOOLEAN), default.f.p_partkey (INT4), default.f.p_name (TEXT), default.f.p_mfgr (TEXT), default.f.p_brand (TEXT), default.f.p_type (TEXT), default.f.p_size (INT4), default.f.p_container (TEXT), default.f.p_retailprice (FLOAT8), default.f.p_comment (TEXT), ?equals (BOOLEAN)} JOIN(10)(LEFT_OUTER) => Join Cond: default.f.p_partkey (INT4) = default.d.o_orderkey (INT4) => target list: default.a.c_custkey (INT4), default.a.c_name (TEXT), default.a.c_address (TEXT), default.a.c_nationkey (INT4), default.a.c_phone (TEXT), default.a.c_acctbal (FLOAT8), default.a.c_mktsegment (TEXT), default.a.c_comment (TEXT), default.b.l_orderkey (INT4), default.b.l_partkey (INT4), default.b.l_suppkey (INT4), default.b.l_linenumber (INT4), default.b.l_quantity (FLOAT8), default.b.l_extendedprice (FLOAT8), default.b.l_discount (FLOAT8), default.b.l_tax (FLOAT8), default.b.l_returnflag (TEXT), default.b.l_linestatus (TEXT), default.b.l_shipdate (TEXT), default.b.l_commitdate (TEXT), default.b.l_receiptdate (TEXT), default.b.l_shipinstruct (TEXT), default.b.l_shipmode (TEXT), default.b.l_comment (TEXT), ?equals_4 (BOOLEAN), default.c.o_orderkey (INT4), default.c.o_custkey (INT4), default.c.o_orderstatus (TEXT), default.c.o_totalprice (FLOAT8), default.c.o_orderdate (TEXT), default.c.o_orderpriority (TEXT), default.c.o_clerk (TEXT), default.c.o_shippriority (INT4), default.c.o_comment (TEXT), ?equals_3 (BOOLEAN), default.d.o_orderkey (INT4), default.d.o_custkey (INT4), default.d.o_orderstatus (TEXT), default.d.o_totalprice (FLOAT8), default.d.o_orderdate (TEXT), default.d.o_orderpriority (TEXT), default.d.o_clerk (TEXT), default.d.o_shippriority (INT4), default.d.o_comment (TEXT), ?equals_2 (BOOLEAN), default.e.n_nationkey (INT4), default.e.n_name (TEXT), default.e.n_regionkey (INT4), default.e.n_comment (TEXT), ?equals_1 (BOOLEAN), default.f.p_partkey (INT4), default.f.p_name (TEXT), default.f.p_mfgr (TEXT), default.f.p_brand (TEXT), default.f.p_type (TEXT), default.f.p_size (INT4), default.f.p_container (TEXT), default.f.p_retailprice (FLOAT8), default.f.p_comment (TEXT), default.f.p_partkey (INT4) = default.d.o_orderkey (INT4) as ?equals => out schema: {(60) default.a.c_custkey (INT4), default.a.c_name (TEXT), default.a.c_address (TEXT), default.a.c_nationkey (INT4), default.a.c_phone (TEXT), default.a.c_acctbal (FLOAT8), default.a.c_mktsegment (TEXT), default.a.c_comment (TEXT), default.b.l_orderkey (INT4), default.b.l_partkey (INT4), default.b.l_suppkey (INT4), default.b.l_linenumber (INT4), default.b.l_quantity (FLOAT8), default.b.l_extendedprice (FLOAT8), default.b.l_discount (FLOAT8), default.b.l_tax (FLOAT8), default.b.l_returnflag (TEXT), default.b.l_linestatus (TEXT), default.b.l_shipdate (TEXT), default.b.l_commitdate (TEXT), default.b.l_receiptdate (TEXT), default.b.l_shipinstruct (TEXT), default.b.l_shipmode (TEXT), default.b.l_comment (TEXT), ?equals_4 (BOOLEAN), default.c.o_orderkey (INT4), default.c.o_custkey (INT4), default.c.o_orderstatus (TEXT), default.c.o_totalprice (FLOAT8), default.c.o_orderdate (TEXT), default.c.o_orderpriority (TEXT), default.c.o_clerk (TEXT), default.c.o_shippriority (INT4), default.c.o_comment (TEXT), ?equals_3 (BOOLEAN), default.d.o_orderkey (INT4), default.d.o_custkey (INT4), default.d.o_orderstatus (TEXT), default.d.o_totalprice (FLOAT8), default.d.o_orderdate (TEXT), default.d.o_orderpriority (TEXT), default.d.o_clerk (TEXT), default.d.o_shippriority (INT4), default.d.o_comment (TEXT), ?equals_2 (BOOLEAN), default.e.n_nationkey (INT4), default.e.n_name (TEXT), default.e.n_regionkey (INT4), default.e.n_comment (TEXT), ?equals_1 (BOOLEAN), default.f.p_partkey (INT4), default.f.p_name (TEXT), default.f.p_mfgr (TEXT), default.f.p_brand (TEXT), default.f.p_type (TEXT), default.f.p_size (INT4), default.f.p_container (TEXT), default.f.p_retailprice (FLOAT8), default.f.p_comment (TEXT), ?equals (BOOLEAN)} => in schema: {(59) default.a.c_custkey (INT4), default.a.c_name (TEXT), default.a.c_address (TEXT), default.a.c_nationkey (INT4), default.a.c_phone (TEXT), default.a.c_acctbal (FLOAT8), default.a.c_mktsegment (TEXT), default.a.c_comment (TEXT), default.b.l_orderkey (INT4), default.b.l_partkey (INT4), default.b.l_suppkey (INT4), default.b.l_linenumber (INT4), default.b.l_quantity (FLOAT8), default.b.l_extendedprice (FLOAT8), default.b.l_discount (FLOAT8), default.b.l_tax (FLOAT8), default.b.l_returnflag (TEXT), default.b.l_linestatus (TEXT), default.b.l_shipdate (TEXT), default.b.l_commitdate (TEXT), default.b.l_receiptdate (TEXT), default.b.l_shipinstruct (TEXT), default.b.l_shipmode (TEXT), default.b.l_comment (TEXT), ?equals_4 (BOOLEAN), default.c.o_orderkey (INT4), default.c.o_custkey (INT4), default.c.o_orderstatus (TEXT), default.c.o_totalprice (FLOAT8), default.c.o_orderdate (TEXT), default.c.o_orderpriority (TEXT), default.c.o_clerk (TEXT), default.c.o_shippriority (INT4), default.c.o_comment (TEXT), ?equals_3 (BOOLEAN), default.d.o_orderkey (INT4), default.d.o_custkey (INT4), default.d.o_orderstatus (TEXT), default.d.o_totalprice (FLOAT8), default.d.o_orderdate (TEXT), default.d.o_orderpriority (TEXT), default.d.o_clerk (TEXT), default.d.o_shippriority (INT4), default.d.o_comment (TEXT), ?equals_2 (BOOLEAN), default.e.n_nationkey (INT4), default.e.n_name (TEXT), default.e.n_regionkey (INT4), default.e.n_comment (TEXT), ?equals_1 (BOOLEAN), default.f.p_partkey (INT4), default.f.p_name (TEXT), default.f.p_mfgr (TEXT), default.f.p_brand (TEXT), default.f.p_type (TEXT), default.f.p_size (INT4), default.f.p_container (TEXT), default.f.p_retailprice (FLOAT8), default.f.p_comment (TEXT)} SCAN(9) on default.part as f => target list: default.f.p_partkey (INT4), default.f.p_name (TEXT), default.f.p_mfgr (TEXT), default.f.p_brand (TEXT), default.f.p_type (TEXT), default.f.p_size (INT4), default.f.p_container (TEXT), default.f.p_retailprice (FLOAT8), default.f.p_comment (TEXT) => out schema: {(9) default.f.p_partkey (INT4), default.f.p_name (TEXT), default.f.p_mfgr (TEXT), default.f.p_brand (TEXT), default.f.p_type (TEXT), default.f.p_size (INT4), default.f.p_container (TEXT), default.f.p_retailprice (FLOAT8), default.f.p_comment (TEXT)} => in schema: {(9) default.f.p_partkey (INT4), default.f.p_name (TEXT), default.f.p_mfgr (TEXT), default.f.p_brand (TEXT), default.f.p_type (TEXT), default.f.p_size (INT4), default.f.p_container (TEXT), default.f.p_retailprice (FLOAT8), default.f.p_comment (TEXT)} JOIN(8)(LEFT_OUTER) => Join Cond: default.d.o_orderkey (INT4) = default.e.n_nationkey (INT4) => target list: default.a.c_custkey (INT4), default.a.c_name (TEXT), default.a.c_address (TEXT), default.a.c_nationkey (INT4), default.a.c_phone (TEXT), default.a.c_acctbal (FLOAT8), default.a.c_mktsegment (TEXT), default.a.c_comment (TEXT), default.b.l_orderkey (INT4), default.b.l_partkey (INT4), default.b.l_suppkey (INT4), default.b.l_linenumber (INT4), default.b.l_quantity (FLOAT8), default.b.l_extendedprice (FLOAT8), default.b.l_discount (FLOAT8), default.b.l_tax (FLOAT8), default.b.l_returnflag (TEXT), default.b.l_linestatus (TEXT), default.b.l_shipdate (TEXT), default.b.l_commitdate (TEXT), default.b.l_receiptdate (TEXT), default.b.l_shipinstruct (TEXT), default.b.l_shipmode (TEXT), default.b.l_comment (TEXT), ?equals_4 (BOOLEAN), default.c.o_orderkey (INT4), default.c.o_custkey (INT4), default.c.o_orderstatus (TEXT), default.c.o_totalprice (FLOAT8), default.c.o_orderdate (TEXT), default.c.o_orderpriority (TEXT), default.c.o_clerk (TEXT), default.c.o_shippriority (INT4), default.c.o_comment (TEXT), ?equals_3 (BOOLEAN), default.d.o_orderkey (INT4), default.d.o_custkey (INT4), default.d.o_orderstatus (TEXT), default.d.o_totalprice (FLOAT8), default.d.o_orderdate (TEXT), default.d.o_orderpriority (TEXT), default.d.o_clerk (TEXT), default.d.o_shippriority (INT4), default.d.o_comment (TEXT), ?equals_2 (BOOLEAN), default.e.n_nationkey (INT4), default.e.n_name (TEXT), default.e.n_regionkey (INT4), default.e.n_comment (TEXT), default.d.o_orderkey (INT4) = default.e.n_nationkey (INT4) as ?equals_1 => out schema: {(50) default.a.c_custkey (INT4), default.a.c_name (TEXT), default.a.c_address (TEXT), default.a.c_nationkey (INT4), default.a.c_phone (TEXT), default.a.c_acctbal (FLOAT8), default.a.c_mktsegment (TEXT), default.a.c_comment (TEXT), default.b.l_orderkey (INT4), default.b.l_partkey (INT4), default.b.l_suppkey (INT4), default.b.l_linenumber (INT4), default.b.l_quantity (FLOAT8), default.b.l_extendedprice (FLOAT8), default.b.l_discount (FLOAT8), default.b.l_tax (FLOAT8), default.b.l_returnflag (TEXT), default.b.l_linestatus (TEXT), default.b.l_shipdate (TEXT), default.b.l_commitdate (TEXT), default.b.l_receiptdate (TEXT), default.b.l_shipinstruct (TEXT), default.b.l_shipmode (TEXT), default.b.l_comment (TEXT), ?equals_4 (BOOLEAN), default.c.o_orderkey (INT4), default.c.o_custkey (INT4), default.c.o_orderstatus (TEXT), default.c.o_totalprice (FLOAT8), default.c.o_orderdate (TEXT), default.c.o_orderpriority (TEXT), default.c.o_clerk (TEXT), default.c.o_shippriority (INT4), default.c.o_comment (TEXT), ?equals_3 (BOOLEAN), default.d.o_orderkey (INT4), default.d.o_custkey (INT4), default.d.o_orderstatus (TEXT), default.d.o_totalprice (FLOAT8), default.d.o_orderdate (TEXT), default.d.o_orderpriority (TEXT), default.d.o_clerk (TEXT), default.d.o_shippriority (INT4), default.d.o_comment (TEXT), ?equals_2 (BOOLEAN), default.e.n_nationkey (INT4), default.e.n_name (TEXT), default.e.n_regionkey (INT4), default.e.n_comment (TEXT), ?equals_1 (BOOLEAN)} => in schema: {(49) default.a.c_custkey (INT4), default.a.c_name (TEXT), default.a.c_address (TEXT), default.a.c_nationkey (INT4), default.a.c_phone (TEXT), default.a.c_acctbal (FLOAT8), default.a.c_mktsegment (TEXT), default.a.c_comment (TEXT), default.b.l_orderkey (INT4), default.b.l_partkey (INT4), default.b.l_suppkey (INT4), default.b.l_linenumber (INT4), default.b.l_quantity (FLOAT8), default.b.l_extendedprice (FLOAT8), default.b.l_discount (FLOAT8), default.b.l_tax (FLOAT8), default.b.l_returnflag (TEXT), default.b.l_linestatus (TEXT), default.b.l_shipdate (TEXT), default.b.l_commitdate (TEXT), default.b.l_receiptdate (TEXT), default.b.l_shipinstruct (TEXT), default.b.l_shipmode (TEXT), default.b.l_comment (TEXT), ?equals_4 (BOOLEAN), default.c.o_orderkey (INT4), default.c.o_custkey (INT4), default.c.o_orderstatus (TEXT), default.c.o_totalprice (FLOAT8), default.c.o_orderdate (TEXT), default.c.o_orderpriority (TEXT), default.c.o_clerk (TEXT), default.c.o_shippriority (INT4), default.c.o_comment (TEXT), ?equals_3 (BOOLEAN), default.d.o_orderkey (INT4), default.d.o_custkey (INT4), default.d.o_orderstatus (TEXT), default.d.o_totalprice (FLOAT8), default.d.o_orderdate (TEXT), default.d.o_orderpriority (TEXT), default.d.o_clerk (TEXT), default.d.o_shippriority (INT4), default.d.o_comment (TEXT), ?equals_2 (BOOLEAN), default.e.n_nationkey (INT4), default.e.n_name (TEXT), default.e.n_regionkey (INT4), default.e.n_comment (TEXT)} SCAN(7) on default.nation as e => target list: default.e.n_nationkey (INT4), default.e.n_name (TEXT), default.e.n_regionkey (INT4), default.e.n_comment (TEXT) => out schema: {(4) default.e.n_nationkey (INT4), default.e.n_name (TEXT), default.e.n_regionkey (INT4), default.e.n_comment (TEXT)} => in schema: {(4) default.e.n_nationkey (INT4), default.e.n_name (TEXT), default.e.n_regionkey (INT4), default.e.n_comment (TEXT)} JOIN(6)(LEFT_OUTER) => Join Cond: default.a.c_custkey (INT4) = default.d.o_orderkey (INT4) => target list: default.a.c_custkey (INT4), default.a.c_name (TEXT), default.a.c_address (TEXT), default.a.c_nationkey (INT4), default.a.c_phone (TEXT), default.a.c_acctbal (FLOAT8), default.a.c_mktsegment (TEXT), default.a.c_comment (TEXT), default.b.l_orderkey (INT4), default.b.l_partkey (INT4), default.b.l_suppkey (INT4), default.b.l_linenumber (INT4), default.b.l_quantity (FLOAT8), default.b.l_extendedprice (FLOAT8), default.b.l_discount (FLOAT8), default.b.l_tax (FLOAT8), default.b.l_returnflag (TEXT), default.b.l_linestatus (TEXT), default.b.l_shipdate (TEXT), default.b.l_commitdate (TEXT), default.b.l_receiptdate (TEXT), default.b.l_shipinstruct (TEXT), default.b.l_shipmode (TEXT), default.b.l_comment (TEXT), ?equals_4 (BOOLEAN), default.c.o_orderkey (INT4), default.c.o_custkey (INT4), default.c.o_orderstatus (TEXT), default.c.o_totalprice (FLOAT8), default.c.o_orderdate (TEXT), default.c.o_orderpriority (TEXT), default.c.o_clerk (TEXT), default.c.o_shippriority (INT4), default.c.o_comment (TEXT), ?equals_3 (BOOLEAN), default.d.o_orderkey (INT4), default.d.o_custkey (INT4), default.d.o_orderstatus (TEXT), default.d.o_totalprice (FLOAT8), default.d.o_orderdate (TEXT), default.d.o_orderpriority (TEXT), default.d.o_clerk (TEXT), default.d.o_shippriority (INT4), default.d.o_comment (TEXT), default.a.c_custkey (INT4) = default.d.o_orderkey (INT4) as ?equals_2 => out schema: {(45) default.a.c_custkey (INT4), default.a.c_name (TEXT), default.a.c_address (TEXT), default.a.c_nationkey (INT4), default.a.c_phone (TEXT), default.a.c_acctbal (FLOAT8), default.a.c_mktsegment (TEXT), default.a.c_comment (TEXT), default.b.l_orderkey (INT4), default.b.l_partkey (INT4), default.b.l_suppkey (INT4), default.b.l_linenumber (INT4), default.b.l_quantity (FLOAT8), default.b.l_extendedprice (FLOAT8), default.b.l_discount (FLOAT8), default.b.l_tax (FLOAT8), default.b.l_returnflag (TEXT), default.b.l_linestatus (TEXT), default.b.l_shipdate (TEXT), default.b.l_commitdate (TEXT), default.b.l_receiptdate (TEXT), default.b.l_shipinstruct (TEXT), default.b.l_shipmode (TEXT), default.b.l_comment (TEXT), ?equals_4 (BOOLEAN), default.c.o_orderkey (INT4), default.c.o_custkey (INT4), default.c.o_orderstatus (TEXT), default.c.o_totalprice (FLOAT8), default.c.o_orderdate (TEXT), default.c.o_orderpriority (TEXT), default.c.o_clerk (TEXT), default.c.o_shippriority (INT4), default.c.o_comment (TEXT), ?equals_3 (BOOLEAN), default.d.o_orderkey (INT4), default.d.o_custkey (INT4), default.d.o_orderstatus (TEXT), default.d.o_totalprice (FLOAT8), default.d.o_orderdate (TEXT), default.d.o_orderpriority (TEXT), default.d.o_clerk (TEXT), default.d.o_shippriority (INT4), default.d.o_comment (TEXT), ?equals_2 (BOOLEAN)} => in schema: {(44) default.a.c_custkey (INT4), default.a.c_name (TEXT), default.a.c_address (TEXT), default.a.c_nationkey (INT4), default.a.c_phone (TEXT), default.a.c_acctbal (FLOAT8), default.a.c_mktsegment (TEXT), default.a.c_comment (TEXT), default.b.l_orderkey (INT4), default.b.l_partkey (INT4), default.b.l_suppkey (INT4), default.b.l_linenumber (INT4), default.b.l_quantity (FLOAT8), default.b.l_extendedprice (FLOAT8), default.b.l_discount (FLOAT8), default.b.l_tax (FLOAT8), default.b.l_returnflag (TEXT), default.b.l_linestatus (TEXT), default.b.l_shipdate (TEXT), default.b.l_commitdate (TEXT), default.b.l_receiptdate (TEXT), default.b.l_shipinstruct (TEXT), default.b.l_shipmode (TEXT), default.b.l_comment (TEXT), ?equals_4 (BOOLEAN), default.c.o_orderkey (INT4), default.c.o_custkey (INT4), default.c.o_orderstatus (TEXT), default.c.o_totalprice (FLOAT8), default.c.o_orderdate (TEXT), default.c.o_orderpriority (TEXT), default.c.o_clerk (TEXT), default.c.o_shippriority (INT4), default.c.o_comment (TEXT), ?equals_3 (BOOLEAN), default.d.o_orderkey (INT4), default.d.o_custkey (INT4), default.d.o_orderstatus (TEXT), default.d.o_totalprice (FLOAT8), default.d.o_orderdate (TEXT), default.d.o_orderpriority (TEXT), default.d.o_clerk (TEXT), default.d.o_shippriority (INT4), default.d.o_comment (TEXT)} SCAN(5) on default.orders as d => target list: default.d.o_orderkey (INT4), default.d.o_custkey (INT4), default.d.o_orderstatus (TEXT), default.d.o_totalprice (FLOAT8), default.d.o_orderdate (TEXT), default.d.o_orderpriority (TEXT), default.d.o_clerk (TEXT), default.d.o_shippriority (INT4), default.d.o_comment (TEXT) => out schema: {(9) default.d.o_orderkey (INT4), default.d.o_custkey (INT4), default.d.o_orderstatus (TEXT), default.d.o_totalprice (FLOAT8), default.d.o_orderdate (TEXT), default.d.o_orderpriority (TEXT), default.d.o_clerk (TEXT), default.d.o_shippriority (INT4), default.d.o_comment (TEXT)} => in schema: {(9) default.d.o_orderkey (INT4), default.d.o_custkey (INT4), default.d.o_orderstatus (TEXT), default.d.o_totalprice (FLOAT8), default.d.o_orderdate (TEXT), default.d.o_orderpriority (TEXT), default.d.o_clerk (TEXT), default.d.o_shippriority (INT4), default.d.o_comment (TEXT)} JOIN(4)(LEFT_OUTER) => Join Cond: default.b.l_orderkey (INT4) = default.c.o_orderkey (INT4) => target list: default.a.c_custkey (INT4), default.a.c_name (TEXT), default.a.c_address (TEXT), default.a.c_nationkey (INT4), default.a.c_phone (TEXT), default.a.c_acctbal (FLOAT8), default.a.c_mktsegment (TEXT), default.a.c_comment (TEXT), default.b.l_orderkey (INT4), default.b.l_partkey (INT4), default.b.l_suppkey (INT4), default.b.l_linenumber (INT4), default.b.l_quantity (FLOAT8), default.b.l_extendedprice (FLOAT8), default.b.l_discount (FLOAT8), default.b.l_tax (FLOAT8), default.b.l_returnflag (TEXT), default.b.l_linestatus (TEXT), default.b.l_shipdate (TEXT), default.b.l_commitdate (TEXT), default.b.l_receiptdate (TEXT), default.b.l_shipinstruct (TEXT), default.b.l_shipmode (TEXT), default.b.l_comment (TEXT), ?equals_4 (BOOLEAN), default.c.o_orderkey (INT4), default.c.o_custkey (INT4), default.c.o_orderstatus (TEXT), default.c.o_totalprice (FLOAT8), default.c.o_orderdate (TEXT), default.c.o_orderpriority (TEXT), default.c.o_clerk (TEXT), default.c.o_shippriority (INT4), default.c.o_comment (TEXT), default.b.l_orderkey (INT4) = default.c.o_orderkey (INT4) as ?equals_3 => out schema: {(35) default.a.c_custkey (INT4), default.a.c_name (TEXT), default.a.c_address (TEXT), default.a.c_nationkey (INT4), default.a.c_phone (TEXT), default.a.c_acctbal (FLOAT8), default.a.c_mktsegment (TEXT), default.a.c_comment (TEXT), default.b.l_orderkey (INT4), default.b.l_partkey (INT4), default.b.l_suppkey (INT4), default.b.l_linenumber (INT4), default.b.l_quantity (FLOAT8), default.b.l_extendedprice (FLOAT8), default.b.l_discount (FLOAT8), default.b.l_tax (FLOAT8), default.b.l_returnflag (TEXT), default.b.l_linestatus (TEXT), default.b.l_shipdate (TEXT), default.b.l_commitdate (TEXT), default.b.l_receiptdate (TEXT), default.b.l_shipinstruct (TEXT), default.b.l_shipmode (TEXT), default.b.l_comment (TEXT), ?equals_4 (BOOLEAN), default.c.o_orderkey (INT4), default.c.o_custkey (INT4), default.c.o_orderstatus (TEXT), default.c.o_totalprice (FLOAT8), default.c.o_orderdate (TEXT), default.c.o_orderpriority (TEXT), default.c.o_clerk (TEXT), default.c.o_shippriority (INT4), default.c.o_comment (TEXT), ?equals_3 (BOOLEAN)} => in schema: {(34) default.a.c_custkey (INT4), default.a.c_name (TEXT), default.a.c_address (TEXT), default.a.c_nationkey (INT4), default.a.c_phone (TEXT), default.a.c_acctbal (FLOAT8), default.a.c_mktsegment (TEXT), default.a.c_comment (TEXT), default.b.l_orderkey (INT4), default.b.l_partkey (INT4), default.b.l_suppkey (INT4), default.b.l_linenumber (INT4), default.b.l_quantity (FLOAT8), default.b.l_extendedprice (FLOAT8), default.b.l_discount (FLOAT8), default.b.l_tax (FLOAT8), default.b.l_returnflag (TEXT), default.b.l_linestatus (TEXT), default.b.l_shipdate (TEXT), default.b.l_commitdate (TEXT), default.b.l_receiptdate (TEXT), default.b.l_shipinstruct (TEXT), default.b.l_shipmode (TEXT), default.b.l_comment (TEXT), ?equals_4 (BOOLEAN), default.c.o_orderkey (INT4), default.c.o_custkey (INT4), default.c.o_orderstatus (TEXT), default.c.o_totalprice (FLOAT8), default.c.o_orderdate (TEXT), default.c.o_orderpriority (TEXT), default.c.o_clerk (TEXT), default.c.o_shippriority (INT4), default.c.o_comment (TEXT)} SCAN(3) on default.orders as c => target list: default.c.o_orderkey (INT4), default.c.o_custkey (INT4), default.c.o_orderstatus (TEXT), default.c.o_totalprice (FLOAT8), default.c.o_orderdate (TEXT), default.c.o_orderpriority (TEXT), default.c.o_clerk (TEXT), default.c.o_shippriority (INT4), default.c.o_comment (TEXT) => out schema: {(9) default.c.o_orderkey (INT4), default.c.o_custkey (INT4), default.c.o_orderstatus (TEXT), default.c.o_totalprice (FLOAT8), default.c.o_orderdate (TEXT), default.c.o_orderpriority (TEXT), default.c.o_clerk (TEXT), default.c.o_shippriority (INT4), default.c.o_comment (TEXT)} => in schema: {(9) default.c.o_orderkey (INT4), default.c.o_custkey (INT4), default.c.o_orderstatus (TEXT), default.c.o_totalprice (FLOAT8), default.c.o_orderdate (TEXT), default.c.o_orderpriority (TEXT), default.c.o_clerk (TEXT), default.c.o_shippriority (INT4), default.c.o_comment (TEXT)} JOIN(2)(LEFT_OUTER) => Join Cond: default.a.c_custkey (INT4) = default.b.l_orderkey (INT4) => target list: default.a.c_custkey (INT4), default.a.c_name (TEXT), default.a.c_address (TEXT), default.a.c_nationkey (INT4), default.a.c_phone (TEXT), default.a.c_acctbal (FLOAT8), default.a.c_mktsegment (TEXT), default.a.c_comment (TEXT), default.b.l_orderkey (INT4), default.b.l_partkey (INT4), default.b.l_suppkey (INT4), default.b.l_linenumber (INT4), default.b.l_quantity (FLOAT8), default.b.l_extendedprice (FLOAT8), default.b.l_discount (FLOAT8), default.b.l_tax (FLOAT8), default.b.l_returnflag (TEXT), default.b.l_linestatus (TEXT), default.b.l_shipdate (TEXT), default.b.l_commitdate (TEXT), default.b.l_receiptdate (TEXT), default.b.l_shipinstruct (TEXT), default.b.l_shipmode (TEXT), default.b.l_comment (TEXT), default.a.c_custkey (INT4) = default.b.l_orderkey (INT4) as ?equals_4 => out schema: {(25) default.a.c_custkey (INT4), default.a.c_name (TEXT), default.a.c_address (TEXT), default.a.c_nationkey (INT4), default.a.c_phone (TEXT), default.a.c_acctbal (FLOAT8), default.a.c_mktsegment (TEXT), default.a.c_comment (TEXT), default.b.l_orderkey (INT4), default.b.l_partkey (INT4), default.b.l_suppkey (INT4), default.b.l_linenumber (INT4), default.b.l_quantity (FLOAT8), default.b.l_extendedprice (FLOAT8), default.b.l_discount (FLOAT8), default.b.l_tax (FLOAT8), default.b.l_returnflag (TEXT), default.b.l_linestatus (TEXT), default.b.l_shipdate (TEXT), default.b.l_commitdate (TEXT), default.b.l_receiptdate (TEXT), default.b.l_shipinstruct (TEXT), default.b.l_shipmode (TEXT), default.b.l_comment (TEXT), ?equals_4 (BOOLEAN)} => in schema: {(24) default.a.c_custkey (INT4), default.a.c_name (TEXT), default.a.c_address (TEXT), default.a.c_nationkey (INT4), default.a.c_phone (TEXT), default.a.c_acctbal (FLOAT8), default.a.c_mktsegment (TEXT), default.a.c_comment (TEXT), default.b.l_orderkey (INT4), default.b.l_partkey (INT4), default.b.l_suppkey (INT4), default.b.l_linenumber (INT4), default.b.l_quantity (FLOAT8), default.b.l_extendedprice (FLOAT8), default.b.l_discount (FLOAT8), default.b.l_tax (FLOAT8), default.b.l_returnflag (TEXT), default.b.l_linestatus (TEXT), default.b.l_shipdate (TEXT), default.b.l_commitdate (TEXT), default.b.l_receiptdate (TEXT), default.b.l_shipinstruct (TEXT), default.b.l_shipmode (TEXT), default.b.l_comment (TEXT)} SCAN(1) on default.lineitem as b => target list: default.b.l_orderkey (INT4), default.b.l_partkey (INT4), default.b.l_suppkey (INT4), default.b.l_linenumber (INT4), default.b.l_quantity (FLOAT8), default.b.l_extendedprice (FLOAT8), default.b.l_discount (FLOAT8), default.b.l_tax (FLOAT8), default.b.l_returnflag (TEXT), default.b.l_linestatus (TEXT), default.b.l_shipdate (TEXT), default.b.l_commitdate (TEXT), default.b.l_receiptdate (TEXT), default.b.l_shipinstruct (TEXT), default.b.l_shipmode (TEXT), default.b.l_comment (TEXT) => out schema: {(16) default.b.l_orderkey (INT4), default.b.l_partkey (INT4), default.b.l_suppkey (INT4), default.b.l_linenumber (INT4), default.b.l_quantity (FLOAT8), default.b.l_extendedprice (FLOAT8), default.b.l_discount (FLOAT8), default.b.l_tax (FLOAT8), default.b.l_returnflag (TEXT), default.b.l_linestatus (TEXT), default.b.l_shipdate (TEXT), default.b.l_commitdate (TEXT), default.b.l_receiptdate (TEXT), default.b.l_shipinstruct (TEXT), default.b.l_shipmode (TEXT), default.b.l_comment (TEXT)} => in schema: {(16) default.b.l_orderkey (INT4), default.b.l_partkey (INT4), default.b.l_suppkey (INT4), default.b.l_linenumber (INT4), default.b.l_quantity (FLOAT8), default.b.l_extendedprice (FLOAT8), default.b.l_discount (FLOAT8), default.b.l_tax (FLOAT8), default.b.l_returnflag (TEXT), default.b.l_linestatus (TEXT), default.b.l_shipdate (TEXT), default.b.l_commitdate (TEXT), default.b.l_receiptdate (TEXT), default.b.l_shipinstruct (TEXT), default.b.l_shipmode (TEXT), default.b.l_comment (TEXT)} SCAN(0) on default.customer as a => target list: default.a.c_custkey (INT4), default.a.c_name (TEXT), default.a.c_address (TEXT), default.a.c_nationkey (INT4), default.a.c_phone (TEXT), default.a.c_acctbal (FLOAT8), default.a.c_mktsegment (TEXT), default.a.c_comment (TEXT) => out schema: {(8) default.a.c_custkey (INT4), default.a.c_name (TEXT), default.a.c_address (TEXT), default.a.c_nationkey (INT4), default.a.c_phone (TEXT), default.a.c_acctbal (FLOAT8), default.a.c_mktsegment (TEXT), default.a.c_comment (TEXT)} => in schema: {(8) default.a.c_custkey (INT4), default.a.c_name (TEXT), default.a.c_address (TEXT), default.a.c_nationkey (INT4), default.a.c_phone (TEXT), default.a.c_acctbal (FLOAT8), default.a.c_mktsegment (TEXT), default.a.c_comment (TEXT)} 2015-09-10 13:10:55,128 INFO: org.apache.tajo.master.GlobalEngine (createLogicalPlan(282)) - ============================================= 2015-09-10 13:10:55,128 INFO: org.apache.tajo.master.GlobalEngine (createLogicalPlan(283)) - Optimized Query: ----------------------------- Query Block Graph ----------------------------- |-#ROOT ----------------------------- Optimization Log: [LogicalPlan] > ProjectionNode is eliminated. [#ROOT] > Non-optimized join order: (((((default.customer â default.lineitem) â default.orders) â default.orders) â default.nation) â default.part) (cost: 5.912486643435727E12) > Optimized join order : ((((default.customer â (default.lineitem â default.orders)) â default.orders) â default.nation) â default.part) (cost: 4.238824102546756E13) ----------------------------- JOIN(17)(LEFT_OUTER) => Join Cond: default.f.p_partkey (INT4) = default.d.o_orderkey (INT4) => target list: default.a.c_custkey (INT4), default.a.c_name (TEXT), default.a.c_nationkey (INT4), default.b.l_orderkey (INT4), default.c.o_orderdate (TEXT), default.d.o_orderdate (TEXT), default.e.n_name (TEXT), default.f.p_name (TEXT) => out schema: {(8) default.a.c_custkey (INT4), default.a.c_name (TEXT), default.a.c_nationkey (INT4), default.b.l_orderkey (INT4), default.c.o_orderdate (TEXT), default.d.o_orderdate (TEXT), default.e.n_name (TEXT), default.f.p_name (TEXT)} => in schema: {(10) default.a.c_custkey (INT4), default.a.c_name (TEXT), default.a.c_nationkey (INT4), default.b.l_orderkey (INT4), default.c.o_orderdate (TEXT), default.d.o_orderdate (TEXT), default.e.n_name (TEXT), default.d.o_orderkey (INT4), default.f.p_name (TEXT), default.f.p_partkey (INT4)} SCAN(9) on default.part as f => target list: default.f.p_name (TEXT), default.f.p_partkey (INT4) => out schema: {(2) default.f.p_name (TEXT), default.f.p_partkey (INT4)} => in schema: {(9) default.f.p_partkey (INT4), default.f.p_name (TEXT), default.f.p_mfgr (TEXT), default.f.p_brand (TEXT), default.f.p_type (TEXT), default.f.p_size (INT4), default.f.p_container (TEXT), default.f.p_retailprice (FLOAT8), default.f.p_comment (TEXT)} JOIN(16)(LEFT_OUTER) => Join Cond: default.d.o_orderkey (INT4) = default.e.n_nationkey (INT4) => target list: default.a.c_custkey (INT4), default.a.c_name (TEXT), default.a.c_nationkey (INT4), default.b.l_orderkey (INT4), default.c.o_orderdate (TEXT), default.d.o_orderdate (TEXT), default.e.n_name (TEXT), default.d.o_orderkey (INT4) => out schema: {(8) default.a.c_custkey (INT4), default.a.c_name (TEXT), default.a.c_nationkey (INT4), default.b.l_orderkey (INT4), default.c.o_orderdate (TEXT), default.d.o_orderdate (TEXT), default.e.n_name (TEXT), default.d.o_orderkey (INT4)} => in schema: {(9) default.a.c_custkey (INT4), default.a.c_name (TEXT), default.a.c_nationkey (INT4), default.b.l_orderkey (INT4), default.c.o_orderdate (TEXT), default.d.o_orderdate (TEXT), default.d.o_orderkey (INT4), default.e.n_name (TEXT), default.e.n_nationkey (INT4)} SCAN(7) on default.nation as e => target list: default.e.n_name (TEXT), default.e.n_nationkey (INT4) => out schema: {(2) default.e.n_name (TEXT), default.e.n_nationkey (INT4)} => in schema: {(4) default.e.n_nationkey (INT4), default.e.n_name (TEXT), default.e.n_regionkey (INT4), default.e.n_comment (TEXT)} JOIN(15)(LEFT_OUTER) => Join Cond: default.a.c_custkey (INT4) = default.d.o_orderkey (INT4) => target list: default.a.c_custkey (INT4), default.a.c_name (TEXT), default.a.c_nationkey (INT4), default.b.l_orderkey (INT4), default.c.o_orderdate (TEXT), default.d.o_orderdate (TEXT), default.d.o_orderkey (INT4) => out schema: {(7) default.a.c_custkey (INT4), default.a.c_name (TEXT), default.a.c_nationkey (INT4), default.b.l_orderkey (INT4), default.c.o_orderdate (TEXT), default.d.o_orderdate (TEXT), default.d.o_orderkey (INT4)} => in schema: {(7) default.a.c_custkey (INT4), default.a.c_name (TEXT), default.a.c_nationkey (INT4), default.b.l_orderkey (INT4), default.c.o_orderdate (TEXT), default.d.o_orderdate (TEXT), default.d.o_orderkey (INT4)} SCAN(5) on default.orders as d => target list: default.d.o_orderdate (TEXT), default.d.o_orderkey (INT4) => out schema: {(2) default.d.o_orderdate (TEXT), default.d.o_orderkey (INT4)} => in schema: {(9) default.d.o_orderkey (INT4), default.d.o_custkey (INT4), default.d.o_orderstatus (TEXT), default.d.o_totalprice (FLOAT8), default.d.o_orderdate (TEXT), default.d.o_orderpriority (TEXT), default.d.o_clerk (TEXT), default.d.o_shippriority (INT4), default.d.o_comment (TEXT)} JOIN(14)(LEFT_OUTER) => Join Cond: default.a.c_custkey (INT4) = default.b.l_orderkey (INT4) => target list: default.a.c_custkey (INT4), default.a.c_name (TEXT), default.a.c_nationkey (INT4), default.b.l_orderkey (INT4), default.c.o_orderdate (TEXT) => out schema: {(5) default.a.c_custkey (INT4), default.a.c_name (TEXT), default.a.c_nationkey (INT4), default.b.l_orderkey (INT4), default.c.o_orderdate (TEXT)} => in schema: {(5) default.a.c_custkey (INT4), default.a.c_name (TEXT), default.a.c_nationkey (INT4), default.b.l_orderkey (INT4), default.c.o_orderdate (TEXT)} JOIN(13)(LEFT_OUTER) => Join Cond: default.b.l_orderkey (INT4) = default.c.o_orderkey (INT4) => target list: default.b.l_orderkey (INT4), default.c.o_orderdate (TEXT) => out schema: {(2) default.b.l_orderkey (INT4), default.c.o_orderdate (TEXT)} => in schema: {(3) default.b.l_orderkey (INT4), default.c.o_orderdate (TEXT), default.c.o_orderkey (INT4)} SCAN(3) on default.orders as c => target list: default.c.o_orderdate (TEXT), default.c.o_orderkey (INT4) => out schema: {(2) default.c.o_orderdate (TEXT), default.c.o_orderkey (INT4)} => in schema: {(9) default.c.o_orderkey (INT4), default.c.o_custkey (INT4), default.c.o_orderstatus (TEXT), default.c.o_totalprice (FLOAT8), default.c.o_orderdate (TEXT), default.c.o_orderpriority (TEXT), default.c.o_clerk (TEXT), default.c.o_shippriority (INT4), default.c.o_comment (TEXT)} SCAN(1) on default.lineitem as b => target list: default.b.l_orderkey (INT4) => out schema: {(1) default.b.l_orderkey (INT4)} => in schema: {(16) default.b.l_orderkey (INT4), default.b.l_partkey (INT4), default.b.l_suppkey (INT4), default.b.l_linenumber (INT4), default.b.l_quantity (FLOAT8), default.b.l_extendedprice (FLOAT8), default.b.l_discount (FLOAT8), default.b.l_tax (FLOAT8), default.b.l_returnflag (TEXT), default.b.l_linestatus (TEXT), default.b.l_shipdate (TEXT), default.b.l_commitdate (TEXT), default.b.l_receiptdate (TEXT), default.b.l_shipinstruct (TEXT), default.b.l_shipmode (TEXT), default.b.l_comment (TEXT)} SCAN(0) on default.customer as a => target list: default.a.c_custkey (INT4), default.a.c_name (TEXT), default.a.c_nationkey (INT4) => out schema: {(3) default.a.c_custkey (INT4), default.a.c_name (TEXT), default.a.c_nationkey (INT4)} => in schema: {(8) default.a.c_custkey (INT4), default.a.c_name (TEXT), default.a.c_address (TEXT), default.a.c_nationkey (INT4), default.a.c_phone (TEXT), default.a.c_acctbal (FLOAT8), default.a.c_mktsegment (TEXT), default.a.c_comment (TEXT)} 2015-09-10 13:10:55,128 INFO: org.apache.tajo.master.GlobalEngine (createLogicalPlan(284)) - ============================================= 2015-09-10 13:10:55,130 INFO: org.apache.tajo.master.QueryInProgress (stopProgress(118)) - ========================================================= 2015-09-10 13:10:55,130 INFO: org.apache.tajo.master.QueryInProgress (stopProgress(119)) - Stop query:q_1441890523948_0283 2015-09-10 13:10:55,131 INFO: org.apache.tajo.master.GlobalEngine (executeQuery(176)) - Query: explain global select a.c_custkey, a.c_name, a.c_nationkey, b.l_orderkey, c.o_orderdate, d.o_orderdate, e.n_name, f.p_name from customer a left outer join lineitem b on a.c_custkey = b.l_orderkey left outer join orders c on b.l_orderkey = c.o_orderkey left outer join orders d on a.c_custkey = d.o_orderkey left outer join nation e on d.o_orderkey = e.n_nationkey left outer join part f on f.p_partkey = d.o_orderkey Killed Results : Tests run: 220, Failures: 0, Errors: 0, Skipped: 0 [INFO] ------------------------------------------------------------------------ [INFO] Reactor Summary: [INFO] [INFO] Tajo Main ......................................... SUCCESS [ 2.200 s] [INFO] Tajo Project POM .................................. SUCCESS [ 1.795 s] [INFO] Tajo Maven Plugins ................................ SUCCESS [ 3.308 s] [INFO] Tajo Common ....................................... SUCCESS [ 42.862 s] [INFO] Tajo Algebra ...................................... SUCCESS [ 2.600 s] [INFO] Tajo Catalog Common ............................... SUCCESS [ 4.863 s] [INFO] Tajo Plan ......................................... SUCCESS [ 6.503 s] [INFO] Tajo Rpc Common ................................... SUCCESS [ 1.377 s] [INFO] Tajo Protocol Buffer Rpc .......................... SUCCESS [ 49.277 s] [INFO] Tajo Catalog Client ............................... SUCCESS [ 1.361 s] [INFO] Tajo Catalog Server ............................... SUCCESS [ 10.593 s] [INFO] Tajo Storage Common ............................... SUCCESS [ 2.807 s] [INFO] Tajo HDFS Storage ................................. SUCCESS [ 53.996 s] [INFO] Tajo PullServer ................................... SUCCESS [ 1.116 s] [INFO] Tajo Client ....................................... SUCCESS [ 2.645 s] [INFO] Tajo CLI tools .................................... SUCCESS [ 1.877 s] [INFO] Tajo SQL Parser ................................... SUCCESS [ 5.062 s] [INFO] ASM (thirdparty) .................................. SUCCESS [ 1.808 s] [INFO] Tajo RESTful Container ............................ SUCCESS [ 3.907 s] [INFO] Tajo Metrics ...................................... SUCCESS [ 1.338 s] [INFO] Tajo Core ......................................... SUCCESS [ 5.880 s] [INFO] Tajo RPC .......................................... SUCCESS [ 0.950 s] [INFO] Tajo Catalog Drivers Hive ......................... SUCCESS [ 12.251 s] [INFO] Tajo Catalog Drivers .............................. SUCCESS [ 0.343 s] [INFO] Tajo Catalog ...................................... SUCCESS [ 0.978 s] [INFO] Tajo Client Example ............................... SUCCESS [ 1.077 s] [INFO] Tajo HBase Storage ................................ SUCCESS [ 4.110 s] [INFO] Tajo Cluster Tests ................................ SUCCESS [ 2.670 s] [INFO] Tajo JDBC Driver .................................. SUCCESS [ 33.741 s] [INFO] Tajo Storage ...................................... SUCCESS [ 0.994 s] [INFO] Tajo Distribution ................................. SUCCESS [ 5.558 s] [INFO] Tajo Core Tests ................................... FAILURE [02:22 min] [INFO] ------------------------------------------------------------------------ [INFO] BUILD FAILURE [INFO] ------------------------------------------------------------------------ [INFO] Total time: 06:53 min [INFO] Finished at: 2015-09-10T13:10:55+00:00 [INFO] Final Memory: 120M/466M [INFO] ------------------------------------------------------------------------ [ERROR] Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.17:test (default-test) on project tajo-core-tests: Execution default-test of goal org.apache.maven.plugins:maven-surefire-plugin:2.17:test failed: The forked VM terminated without properly saying goodbye. VM crash or System.exit called? [ERROR] Command was /bin/sh -c cd <https://builds.apache.org/job/Tajo-0.11.0-build/ws/tajo-core-tests> && /home/jenkins/tools/java/jdk1.7.0_25-32/jre/bin/java -Xms512m -Xmx1024m -XX:MaxPermSize=152m -Dfile.encoding=UTF-8 -Dderby.storage.pageSize=1024 -Dderby.stream.error.file=/dev/null -jar <https://builds.apache.org/job/Tajo-0.11.0-build/ws/tajo-core-tests/target/surefire/surefirebooter6556931185259232731.jar> <https://builds.apache.org/job/Tajo-0.11.0-build/ws/tajo-core-tests/target/surefire/surefire824919186944862579tmp> <https://builds.apache.org/job/Tajo-0.11.0-build/ws/tajo-core-tests/target/surefire/surefire_146770114860082378360tmp> [ERROR] -> [Help 1] [ERROR] [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch. [ERROR] Re-run Maven using the -X switch to enable full debug logging. [ERROR] [ERROR] For more information about the errors and possible solutions, please read the following articles: [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/PluginExecutionException [ERROR] [ERROR] After correcting the problems, you can resume the build with the command [ERROR] mvn <goals> -rf :tajo-core-tests Build step 'Execute shell' marked build as failure Archiving artifacts Sending artifact delta relative to Tajo-0.11.0-build #32 Archived 1 artifacts Archive block size is 32768 Received 0 blocks and 59101288 bytes Compression is 0.0% Took 15 sec Updating TAJO-1833
