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] [Created] (VXQUERY-170) Problem with the XMark Query Plans
for 6 and 7
Shivani Mall created VXQUERY-170:
------------------------------------
Summary: 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: 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.
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)