[teiid-issues] [JBoss JIRA] (TEIID-1878) Problem with accessing custom generated materialized views
Steven Hawkins (Commented) (JIRA)
jira-events at lists.jboss.org
Wed Dec 21 15:47:09 EST 2011
[ https://issues.jboss.org/browse/TEIID-1878?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12652670#comment-12652670 ]
Steven Hawkins commented on TEIID-1878:
---------------------------------------
Given that metadata there is no reason why property should resolve and property_CHORUS_NON_MAT_VIEW should not. The next step would be to launch in debug or add debug lines to CompositeMetadataStore.findGroup for when it is called with "CHORUS_METADATA.PROPERTY_CHORUS_NON_MAT_VIEW". In particular the contents of schemas and the CHORUS_METADATA schema should be validated.
> Problem with accessing custom generated materialized views
> ----------------------------------------------------------
>
> Key: TEIID-1878
> URL: https://issues.jboss.org/browse/TEIID-1878
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 7.6
> Environment: java version "1.6.0_22"
> Java(TM) SE Runtime Environment (build 1.6.0_22-b04)
> Java HotSpot(TM) 64-Bit Server VM (build 17.1-b03, mixed mode)
> JBoss 5.1.0
> Windows 7, 8GB RAM
> Reporter: Andriy Rokhmanov
> Assignee: Steven Hawkins
> Attachments: server_bootstrap.log, server_select.log
>
>
> We have a problem with custom-generated materialized view. The way we do it works fine
> with Teiid 7.3 but fails when we try to migrate to 7.6.
> Here is the SQL which gives the problem:
> select * from chorus_metadata.property;
> Remote org.teiid.api.exception.query.QueryPlannerException: Group does not exist: chorus_metadata.property_CHORUS_NON_MAT_VIEW
> Some additional info:
> 1. System tables:
> select * from SYS.tables where Name like 'property%' and SchemaName = 'chorus_metadata';
> VDBName SchemaName Name Type NameInSource IsPhysical SupportsUpdates UID Cardinality Description IsSystem IsMaterialized OID
> ------- --------------- ---------------------------- ---- ------------ ---------- --------------- ------------------------------------------- ----------- ----------- -------- -------------- ---
> Chorus chorus_metadata property_union View NULL true false mmuuid:319d6147-6145-4f56-bc2e-42326b19368c 0 NULL false false 393
> Chorus chorus_metadata property_CHORUS_NON_MAT_VIEW View NULL true false mmuuid:bb25b63d-bded-4704-8638-e507197af6f1 0 NULL false false 398
> Chorus chorus_metadata property View NULL false false mmuuid:9070f66d-df9c-4f37-bd4f-00020ceef492 0 NULL false true 399
> select * from SYSADMIN.matviews;
> VDBName SchemaName Name TargetSchemaName TargetName Valid LoadState Updated Cardinality
> ------- --------------- -------------- ---------------- ------------------------------ ----- ------------- ------- -----------
> Chorus chorus_metadata property NULL #MAT_CHORUS_METADATA.PROPERTY false NEEDS_LOADING NULL 0
> Chorus pg_catalog pg_class NULL #MAT_PG_CATALOG.PG_CLASS false NEEDS_LOADING NULL NULL
> Chorus pg_catalog pg_attribute NULL #MAT_PG_CATALOG.PG_ATTRIBUTE false NEEDS_LOADING NULL NULL
> Chorus pg_catalog pg_index NULL #MAT_PG_CATALOG.PG_INDEX false NEEDS_LOADING NULL NULL
> Chorus pg_catalog pg_proc NULL #MAT_PG_CATALOG.PG_PROC false NEEDS_LOADING NULL NULL
> Chorus pg_catalog matpg_relatt NULL #MAT_PG_CATALOG.MATPG_RELATT false NEEDS_LOADING NULL NULL
> Chorus pg_catalog matpg_datatype NULL #MAT_PG_CATALOG.MATPG_DATATYPE false NEEDS_LOADING NULL NULL
> Note: looks like the chorus_metadata.propoerty needs loading, but attempt to load it fails with the same error:
> CALL SYSADMIN.refreshMatView(viewname=>'chorus_metadata.property', invalidate=>'true');
> Remote org.teiid.api.exception.query.QueryResolverException: Group does not exist: chorus_metadata.property_CHORUS_NON_MAT_VIEW
> 2. The view chorus_metadata.property_CHORUS_NON_MAT_VIEW is actually exist and available:
> select * from chorus_metadata.property_CHORUS_NON_MAT_VIEW;
> propertyName objectName subType propertyValue objectInstance
> ----------------- ------------------------------- ----------- ----------------------- -----------------------
> Sequence chorusdata.note Column 1 CREATED_ON
> Sequence demodata.someSeq Column 1
> ...
> 3. How the chorus_metadata.property gets defined (sample code):
> org.teiid.metadata.Table table = org.teiid.metadata.MetadataFactory.addTable("property");
> table.setMaterialized(true);
> table.setVirtual(true);
> table.setSelectTransformation(
> "/*+ cache */ SELECT propertyName, objectName, subType, propertyValue, objectInstance FROM chorus_metadata.property_CHORUS_NON_MAT_VIEW");
> table.setTableType(Type.View);
> Note: we tried today a patch for TEIID-1868, it did not help.
> Let us know please if we can help with any additional information.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the teiid-issues
mailing list