You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@tajo.apache.org by Apache Jenkins Server <je...@builds.apache.org> on 2015/09/10 15:11:08 UTC
Build failed in Jenkins: Tajo-0.11.0-build #33
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
Jenkins build is back to normal : Tajo-0.11.0-build #34
Posted by Apache Jenkins Server <je...@builds.apache.org>.
See <https://builds.apache.org/job/Tajo-0.11.0-build/34/changes>