Hyoungjun Kim created TAJO-896:
----------------------------------
Summary: Full outer join query with empty intermediate data
doesn't terminate.
Key: TAJO-896
URL: https://issues.apache.org/jira/browse/TAJO-896
Project: Tajo
Issue Type: Bug
Reporter: Hyoungjun Kim
Assignee: Hyoungjun Kim
Priority: Trivial
See title.
I ran the following query. Left and right subquery's result is empty.
{code:sql}
select a.l_orderkey
from (select * from lineitem where l_orderkey < 0) a
full outer join (select * from lineitem where l_orderkey < 0) b
on a.l_orderkey = b.l_orderkey
{code}
The next log is QueryMaster's log. QueryMaster assigned 1 task for JOIN
execution block.
{noformat}
2014-06-30 16:18:24,987 INFO: org.apache.tajo.master.querymaster.Repartitioner
(scheduleFragmentsForJoinQuery(186)) - [Distributed Join Strategy] : Symmetric
Repartition Join
2014-06-30 16:18:24,988 INFO: org.apache.tajo.master.querymaster.Repartitioner
(scheduleFragmentsForJoinQuery(258)) - Larger intermediate data is
approximately 0 MB
2014-06-30 16:18:24,988 INFO: org.apache.tajo.master.querymaster.Repartitioner
(scheduleFragmentsForJoinQuery(261)) - The calculated number of tasks is 0
2014-06-30 16:18:24,988 INFO: org.apache.tajo.master.querymaster.Repartitioner
(scheduleFragmentsForJoinQuery(262)) - The number of total shuffle keys is 1
2014-06-30 16:18:24,988 INFO: org.apache.tajo.master.querymaster.Repartitioner
(scheduleFragmentsForJoinQuery(266)) - The determined number of join tasks is 0
2014-06-30 16:18:24,989 INFO: org.apache.tajo.master.querymaster.SubQuery
(transition(647)) - 1 objects are scheduled
2014-06-30 16:18:24,989 INFO: org.apache.tajo.master.DefaultTaskScheduler
(start(87)) - Start TaskScheduler
2014-06-30 16:18:24,990 INFO: org.apache.tajo.worker.TajoResourceAllocator
(calculateNumRequestContainers(100)) - CalculateNumberRequestContainer - Number
of Tasks=0, Number of Cluster Slots=1
2014-06-30 16:18:24,990 INFO: org.apache.tajo.master.querymaster.SubQuery
(allocateContainers(888)) - Request Container for eb_1404112701831_0001_000003
containers=0
2014-06-30 16:18:24,990 INFO: org.apache.tajo.master.querymaster.Query
(executeNextBlock(609)) - Scheduling SubQuery:eb_1404112701831_0001_000003
2014-06-30 16:18:24,991 INFO: org.apache.tajo.worker.TajoResourceAllocator
(run(217)) - Start TajoWorkerAllocationThread
2014-06-30 16:18:26,480 INFO:
org.apache.tajo.master.querymaster.QueryInProgress (heartbeat(265)) - Received
QueryMaster
heartbeat:q_1404112701831_0001,state=QUERY_RUNNING,progress=0.6666667,
queryMaster=babokim-MacBook-Pro.local
2014-06-30 16:18:27,992 INFO: org.apache.tajo.worker.TajoResourceAllocator
(run(261)) - No available worker resource for eb_1404112701831_0001_000003
{noformat}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
