1:26 p.m.
[
https://issues.jboss.org/browse/TEIID-1636?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1636:
---------------------------------------
The select transformation is the view definition. Transformation was the metamatrix term
for the SQL underlying any virtual object.
Without a view definition the table record is not a view and cannot be materialized. It
sounds like you may be wanting to use alter view or another metadata loading mechanism to
bring your definition into the runtime. From there materialization will work as
expected.
Programmatically configure internal materialized views
------------------------------------------------------
Key: TEIID-1636
URL: https://issues.jboss.org/browse/TEIID-1636
Project: Teiid
Issue Type: Bug
Affects Versions: 7.3
Reporter: Mark Addleman
Assignee: Steven Hawkins
I am trying to programatically create a materialized view from the MetadataFactory
object. I have created a table object using addTable() and then I call
setMaterialized(true). I see there are a couple of other related method names in Table
(setMaterializedStagedTable and setMaterializedTable). I assume those are when
materializing to an external database. What I am doing is incorrect, however.
When I try to issue a refresh CALL
SYSADMIN.refreshMatView(viewname=>'xyz_metadata.property',
invalidate=>false), I get the following exception:
QueryMetadataException]QueryPlan could not be found for physical group
chorus_metadata.property
at
org.teiid.query.metadata.TransformationMetadata.getVirtualPlan(TransformationMetadata.java:453)
at
org.teiid.query.metadata.TempMetadataAdapter.getVirtualPlan(TempMetadataAdapter.java:253)
at
org.teiid.query.optimizer.relational.RelationalPlanner.getGlobalTempTableMetadataId(RelationalPlanner.java:1136)
at
org.teiid.query.tempdata.TempTableDataManager.handleSystemProcedures(TempTableDataManager.java:320)
at
org.teiid.query.tempdata.TempTableDataManager.registerRequest(TempTableDataManager.java:188)
at
org.teiid.query.tempdata.TempTableDataManager.registerRequest(TempTableDataManager.java:170)
at org.teiid.query.processor.relational.AccessNode.registerRequest(AccessNode.java:197)
at org.teiid.query.processor.relational.AccessNode.open(AccessNode.java:118)
at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250)
at org.teiid.query.processor.relational.RelationalPlan.open(RelationalPlan.java:152)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:134)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:115)
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:250)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:184)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
13 Jun 2011 17:05:43,663 PDT INFO [MATVIEWS] Loading materialized view table
#MAT_XYZ_METADATA.PROPERTY
Subsequent calls to the refresh stored procedure yield an NPE else in Teiid code.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira