Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-2930

Dynamic VDB should contain full path to the materialized table

    XMLWordPrintable

Details

      1. Import project
      2. Generate dynamic VDB

    Description

      I have a table (CustomerViewMat.Customer) and I set materialized table to another model (CustomerMatCache.Customer) (screenshot1) .I create VDB and dynamic VDB. When I want to deploy this dynamic VDB to the server, server shows me error:
      TEIID31088 The materialization table Customer defined on view CustomerViewMat.Customer, must be defined with "schema" qualifier that represents PHYSICAL model.

      I noticed that in the dynamicVDB in the CustomerViewMat model is:

      OPTIONS(MATERIALIZED 'TRUE', MATERIALIZED_TABLE 'Customer', "teiid_rel: ...
      

      I think that this happens because Customer table is in the CustomerViewMat and CustomerMatCache too. But in the properties (Screenshot1) is set correctly model. (CustomerMatCache)

      When I set full path, vdb was deployed sucessfully

      OPTIONS(MATERIALIZED 'TRUE', MATERIALIZED_TABLE 'CustomerMatCache.Customer', "teiid_rel: ...
      

      Attachments

        1. completeJDGproject.zip
          194 kB
        2. customer-cache-table-info.png
          customer-cache-table-info.png
          37 kB
        3. customer-view-info.png
          customer-view-info.png
          35 kB
        4. jdgCustomer.zip
          155 kB
        5. screenshot1.png
          screenshot1.png
          85 kB
        6. screenshotProp.png
          screenshotProp.png
          48 kB

        Issue Links

          Activity

            People

              blafond Barry LaFond
              mkralik@redhat.com Matej Kralik
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: