You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@tajo.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2014/07/01 07:36:24 UTC
[jira] [Commented] (TAJO-896) Full outer join query with empty
intermediate data doesn't terminate.
[ https://issues.apache.org/jira/browse/TAJO-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14048538#comment-14048538 ]
ASF GitHub Bot commented on TAJO-896:
-------------------------------------
Github user hyunsik commented on the pull request:
https://github.com/apache/tajo/pull/51#issuecomment-47618687
+1
I've renamed some variable names, and others all look good to me.
> 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)