You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@vxquery.apache.org by "Shivani Mall (JIRA)" <ji...@apache.org> on 2015/08/04 20:42:04 UTC
[jira] [Updated] (VXQUERY-170) Problem with the XMark Query Plans
for 6 and 7
[ https://issues.apache.org/jira/browse/VXQUERY-170?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Shivani Mall updated VXQUERY-170:
---------------------------------
Priority: Blocker (was: Critical)
> Problem with the XMark Query Plans for 6 and 7
> ----------------------------------------------
>
> Key: VXQUERY-170
> URL: https://issues.apache.org/jira/browse/VXQUERY-170
> Project: VXQuery
> Issue Type: Bug
> Reporter: Shivani Mall
> Priority: Blocker
>
> 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.
> 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|
> INFO: Optimized Plan:
> distribute result [%0->$$42]
> -- DISTRIBUTE_RESULT |UNPARTITIONED|
> exchange
> -- ONE_TO_ONE_EXCHANGE |UNPARTITIONED|
> unnest $$42 <- vxquery:{urn:org.apache.vxquery.operators-ext}child <text >, Args:[
> %0->$$36
> ]
> -- UNNEST |UNPARTITIONED|
> unnest $$36 <- vxquery:{urn:org.apache.vxquery.operators-ext}child <element(NameTest({}name, {http://www.w3.org/2001/XMLSchema}anyType, nilled) >, Args:[
> vxquery:{urn:org.apache.vxquery.operators-ext}treat <node*>, Args:[
> %0->$$31
> ]
> ]
> -- UNNEST |UNPARTITIONED|
> unnest $$31 <- function-call: vxquery:{urn:org.apache.vxquery.operators-ext}iterate, Args:[
> %0->$$18
> ]
> -- UNNEST |UNPARTITIONED|
> select (function-call: vxquery:{http://www.w3.org/2005/xpath-functions}contains, Args:[
> function-call: vxquery:{http://www.w3.org/2005/xpath-functions}string, Args:[
> function-call: vxquery:{http://www.w3.org/2005/xpath-functions}exactly-one, Args:[
> vxquery:{urn:org.apache.vxquery.operators-ext}treat <item*>, Args:[
> %0->$$23
> ]
> ]
> ]
> {http://www.w3.org/2001/XMLSchema}string : gold
> ])
> -- STREAM_SELECT |UNPARTITIONED|
> subplan {
> aggregate [$$23] <- [function-call: vxquery:{urn:org.apache.vxquery.operators-ext}sequence, Args:[
> vxquery:{urn:org.apache.vxquery.operators-ext}child <element(NameTest({}description, {http://www.w3.org/2001/XMLSchema}anyType, nilled) >, Args:[
> vxquery:{urn:org.apache.vxquery.operators-ext}treat <node*>, Args:[
> %0->$$21
> ]
> ]
> ]]
> -- AGGREGATE |UNPARTITIONED|
> unnest $$21 <- function-call: vxquery:{urn:org.apache.vxquery.operators-ext}iterate, Args:[
> %0->$$18
> ]
> -- UNNEST |UNPARTITIONED|
> nested tuple source
> -- NESTED_TUPLE_SOURCE |UNPARTITIONED|
> }
> -- SUBPLAN |UNPARTITIONED|
> unnest $$18 <- vxquery:{urn:org.apache.vxquery.operators-ext}descendant-or-self <element(NameTest({}item, {http://www.w3.org/2001/XMLSchema}anyType, nilled) >, Args:[
> %0->$$10
> ]
> -- UNNEST |UNPARTITIONED|
> unnest $$10 <- vxquery:{urn:org.apache.vxquery.operators-ext}child <element(NameTest({}site, {http://www.w3.org/2001/XMLSchema}anyType, nilled) >, Args:[
> vxquery:{urn:org.apache.vxquery.operators-ext}treat <node*>, Args:[
> %0->$$5
> ]
> ]
> -- UNNEST |UNPARTITIONED|
> unnest $$5 <- function-call: vxquery:{urn:org.apache.vxquery.operators-ext}iterate, Args:[
> %0->$$3
> ]
> -- UNNEST |UNPARTITIONED|
> assign [$$3] <- [function-call: vxquery:{http://www.w3.org/2005/xpath-functions}doc, Args:[
> {http://www.w3.org/2001/XMLSchema}string : ../auction.xml
> ]]
> -- ASSIGN |UNPARTITIONED|
> empty-tuple-source
> -- EMPTY_TUPLE_SOURCE |UNPARTITIONED|
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)