[
https://issues.apache.org/jira/browse/VXQUERY-169?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Preston Carman reassigned VXQUERY-169:
--------------------------------------
Assignee: Preston Carman
> Error with the Query Plans for 6 and 7
> --------------------------------------
>
> Key: VXQUERY-169
> URL: https://issues.apache.org/jira/browse/VXQUERY-169
> Project: VXQuery
> Issue Type: Bug
> Reporter: Shivani Mall
> Assignee: Preston Carman
> Priority: Critical
>
> Here are the logical and optimized plans for Query 6. There is some issue
> with the plans. There needs to be some operator between child and count.
> Since child sends out empty sequences and the count aggregate function counts
> all the empty sequences giving a very large value.
> INFO: Optimized Plan:
> distribute result [%0->$$16]
> -- DISTRIBUTE_RESULT |UNPARTITIONED|
> exchange
> -- ONE_TO_ONE_EXCHANGE |UNPARTITIONED|
> unnest $$16 <- function-call:
> vxquery:{urn:org.apache.vxquery.operators-ext}iterate, Args:[
> %0->$$12
> ]
> -- UNNEST |UNPARTITIONED|
> subplan {
> aggregate [$$12] <- [function-call:
> [vxquery:{http://www.w3.org/2005/xpath-functions}count|vxquery:{http://www.w3.org/2005/xpath-functions}sum],
> Args:[
> %0->$$20
> ]]
> -- AGGREGATE |LOCAL|
> aggregate [$$20] <- [function-call:
> vxquery:{http://www.w3.org/2005/xpath-functions}count, Args:[
> vxquery:{urn:org.apache.vxquery.operators-ext}child
> <element(NameTest({}item, {http://www.w3.org/2001/XMLSchema}anyType, nilled)
> >, Args:[
> vxquery:{urn:org.apache.vxquery.operators-ext}treat
> <node*>, Args:[
> %0->$$10
> ]
> ]
> ]]
> -- AGGREGATE |LOCAL|
> unnest $$10 <- function-call:
> vxquery:{urn:org.apache.vxquery.operators-ext}iterate, Args:[
> %0->$$8
> ]
> -- UNNEST |UNPARTITIONED|
> nested tuple source
> -- NESTED_TUPLE_SOURCE |UNPARTITIONED|
> }
> -- SUBPLAN |UNPARTITIONED|
> subplan {
> aggregate [$$8] <- [function-call:
> vxquery:{urn:org.apache.vxquery.operators-ext}sequence, Args:[
> function-call:
> vxquery:{urn:org.apache.vxquery.operators-ext}descendant-or-self, Args:[
> vxquery:{urn:org.apache.vxquery.operators-ext}treat
> <node*>, Args:[
> %0->$$6
> ]
> ]
> ]]
> -- AGGREGATE |UNPARTITIONED|
> unnest $$6 <- function-call:
> vxquery:{urn:org.apache.vxquery.operators-ext}iterate, Args:[
> %0->$$3
> ]
> -- UNNEST |UNPARTITIONED|
> nested tuple source
> -- NESTED_TUPLE_SOURCE |UNPARTITIONED|
> }
> -- SUBPLAN |UNPARTITIONED|
> unnest $$3 <- function-call:
> vxquery:{urn:org.apache.vxquery.operators-ext}iterate, Args:[
> %0->$$2
> ]
> -- UNNEST |UNPARTITIONED|
> assign [$$2] <- [function-call:
> vxquery:{http://www.w3.org/2005/xpath-functions}doc, Args:[
> {http://www.w3.org/2001/XMLSchema}string : ../regions.xml
> ]]
> -- ASSIGN |UNPARTITIONED|
> empty-tuple-source
> -- EMPTY_TUPLE_SOURCE |UNPARTITIONED|
> FINE: Logical Plan:
> distribute result [%0->$$16] -- |UNPARTITIONED|
> unnest $$16 <- function-call:
> vxquery:{urn:org.apache.vxquery.operators-ext}iterate, Args:[
> %0->$$15
> ] -- |UNPARTITIONED|
> subplan {
> aggregate [$$15] <- [function-call:
> vxquery:{urn:org.apache.vxquery.operators-ext}sequence, Args:[
> %0->$$14
> ]] -- |UNPARTITIONED|
> assign [$$14] <- [function-call:
> vxquery:{http://www.w3.org/2005/xpath-functions}count, Args:[
> vxquery:{urn:org.apache.vxquery.operators-ext}treat
> <item*>, Args:[
> %0->$$13
> ]
> ]] -- |UNPARTITIONED|
> assign [$$13] <- [function-call:
> vxquery:{urn:org.apache.vxquery.operators-ext}sort-distinct-nodes-asc-or-atomics,
> Args:[
> %0->$$12
> ]] -- |UNPARTITIONED|
> subplan {
> aggregate [$$12] <- [function-call:
> vxquery:{urn:org.apache.vxquery.operators-ext}sequence, Args:[
>
> vxquery:{urn:org.apache.vxquery.operators-ext}child <element(NameTest({}item,
> {http://www.w3.org/2001/XMLSchema}anyType, nilled) >, Args:[
>
> vxquery:{urn:org.apache.vxquery.operators-ext}treat <node*>, Args:[
> %0->$$10
> ]
> ]
> ]] -- |UNPARTITIONED|
> unnest $$10 at $$11 <- function-call:
> vxquery:{urn:org.apache.vxquery.operators-ext}iterate, Args:[
> %0->$$8
> ] -- |UNPARTITIONED|
> assign [$$9] <- [function-call:
> vxquery:{http://www.w3.org/2005/xpath-functions}count, Args:[
> %0->$$8
> ]] -- |UNPARTITIONED|
> nested tuple source -- |UNPARTITIONED|
> } -- |UNPARTITIONED|
> subplan {
> aggregate [$$8] <- [function-call:
> vxquery:{urn:org.apache.vxquery.operators-ext}sequence, Args:[
> function-call:
> vxquery:{urn:org.apache.vxquery.operators-ext}descendant-or-self, Args:[
>
> vxquery:{urn:org.apache.vxquery.operators-ext}treat <node*>, Args:[
> %0->$$6
> ]
> ]
> ]] -- |UNPARTITIONED|
> unnest $$6 at $$7 <- function-call:
> vxquery:{urn:org.apache.vxquery.operators-ext}iterate, Args:[
> %0->$$4
> ] -- |UNPARTITIONED|
> assign [$$5] <- [function-call:
> vxquery:{http://www.w3.org/2005/xpath-functions}count, Args:[
> %0->$$4
> ]] -- |UNPARTITIONED|
> nested tuple source -- |UNPARTITIONED|
> } -- |UNPARTITIONED|
> assign [$$4] <-
> [vxquery:{urn:org.apache.vxquery.operators-ext}treat <item >, Args:[
> %0->$$3
> ]] -- |UNPARTITIONED|
> unnest $$3 <- function-call:
> vxquery:{urn:org.apache.vxquery.operators-ext}iterate, Args:[
> %0->$$2
> ] -- |UNPARTITIONED|
> assign [$$2] <- [function-call:
> vxquery:{http://www.w3.org/2005/xpath-functions}doc, Args:[
>
> vxquery:{urn:org.apache.vxquery.operators-ext}promote
> <{http://www.w3.org/2001/XMLSchema}string?>, Args:[
> function-call:
> vxquery:{http://www.w3.org/2005/xpath-functions}data, Args:[
> %0->$$1
> ]
> ]
> ]] -- |UNPARTITIONED|
> assign [$$1] <-
> [{http://www.w3.org/2001/XMLSchema}string : ../regions.xml] -- |UNPARTITIONED|
> nested tuple source -- |UNPARTITIONED|
> } -- |UNPARTITIONED|
> empty-tuple-source -- |UNPARTITIONED|
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
