[
https://issues.apache.org/jira/browse/TAJO-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14047525#comment-14047525
]
ASF GitHub Bot commented on TAJO-896:
-------------------------------------
GitHub user babokim opened a pull request:
https://github.com/apache/tajo/pull/51
TAJO-896: Full outer join query with empty intermediate data doesn't
terminate.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/babokim/tajo TAJO-896
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/tajo/pull/51.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #51
----
commit db4a235f588976b85e2a450010d8ac3814312de3
Author: 김형준 <[email protected]>
Date: 2014-06-30T10:24:27Z
TAJO-896: Full outer join query with empty intermediate data doesn't
terminate.
----
> 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)
