SQLState :38000 error when trying to insert values into External Materialized Views in JBEDS
Issue
- I am trying to test external materialization in JBEDS so I created physical model mv_views based on materializedviews External_CacheViews.supplierinfo. - But when i try to refresh the data as shown below, it throws an error:
INSERT INTO mv_views.supplierinfo
SELECT * FROM External_CacheViews.supplierinfo OPTION NOCACHE
Error: org.teiid.query.sql.symbol.AllSymbol cannot be cast to org.teiid.query.sql.symbol.SingleElementSymbol
SQLState: 38000
ErrorCode: 0
Environment
- JBoss Enterprise Data Services (JBEDS) 5.2.0
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.