Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-6057

There should be a way to set cardinalities for views containing texttable and other table functions

    XMLWordPrintable

    Details

    • Type: Enhancement
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: Backlog
    • Component/s: Query Engine
    • Labels:
      None
    • [QE] How to address?:
      ---
    • [QE] Why QE missed?:
      ---

      Description

      If you use a view to represent access to a texttable it would be great in some instances to associate the cardinality at a view layer - but that view layer will currently be removed before cardinalities are assigned. The possibilities are:

      1. require the use of no_unnest if you want to associate the cardinality with a view. This has additional book-keeping issues in that any criteria or other constructs that are pushed would need to have the cardinality set on the node that is pushed the furthest.
      2. implicitly don't unnest if there's no further optimization that can be performed on the view - for example if it contains only a single source node, and then use the view cardinality given the same logic that would be required for 1.
      3. allow for associating cardinality directly on table reference functions via a hint or syntax such that it would be generally useful.

      3 in some ways is the least amount of work given the current logic.

      The workaround in these situations is to create either a materialized view or a materialized common table.

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            rhn-engineering-shawkins Steven Hawkins
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated: