Uploaded image for project: 'VXQuery'
  1. VXQuery
  2. VXQUERY-93

New Rewrite Rule for Set of Collections

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      Found that a new query that collection rule will need to support. Collections in this form are not being found by the rewrite rules to alter the query for parallel processing. The rewriter needs to find all collections and union the result from the new data source scan operators.

      Example Query:
      for $x in (collection("folder1"), collection("folder2"))
      return $x

      Search Operators (example section):
      unnest $$6 <- function-call: vxquery:

      {urn}iterate, Args:[%0->$$5] – |UNPARTITIONED|
      assign [$$5] <- [function-call: vxquery:{urn}

      concatenate, Args:[%0->$$2, %0->$$4]] – |UNPARTITIONED|
      assign [$$4] <- [function-call: vxquery:

      {xpath-functions}collection, Args:[function-call: vxquery:{operators-ext}promote, Args:[function-call: vxquery:{xpath-functions}

      data, Args:[%0->$$3],

      {XMLSchema}int QUANT_ONE(bytes[5] = [1d00000007])]]] – |UNPARTITIONED|
      assign [$$3] <- [{XMLSchema}

      string QUANT_ONE(bytes[68] = [...])] – |UNPARTITIONED|
      assign [$$2] <- [function-call: vxquery:

      {xpath-functions}collection, Args:[function-call: vxquery:{urn}promote, Args:[function-call: vxquery:{xpath-functions}

      data, Args:[%0->$$1],

      {XMLSchema}int QUANT_ONE(bytes[5] = [1d00000007])]]] – |UNPARTITIONED|
      assign [$$1] <- [{XMLSchema}

      string QUANT_ONE(bytes[66] = [...])] – |UNPARTITIONED|

      Suggested new Plan
      union all
      data source scan (folder1)
      data source scan (folder2)

        Attachments

          Activity

            People

            • Assignee:
              prestonc Preston Carman
              Reporter:
              prestonc Preston Carman
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: