[teiid-issues] [JBoss JIRA] (TEIID-4961) External Materialized View With State Loaded but 0 Cardinality

Ramesh Reddy (JIRA) issues at jboss.org
Wed Jun 14 14:39:00 EDT 2017


    [ https://issues.jboss.org/browse/TEIID-4961?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13421394#comment-13421394 ] 

Ramesh Reddy commented on TEIID-4961:
-------------------------------------

This is no different than TEIID-4960, when you're ON_ERROR_ACTION flag set to ignore, this will be is the result.

> External Materialized View With State Loaded but 0 Cardinality
> --------------------------------------------------------------
>
>                 Key: TEIID-4961
>                 URL: https://issues.jboss.org/browse/TEIID-4961
>             Project: Teiid
>          Issue Type: Bug
>    Affects Versions: 9.3
>         Environment: * Teiid 9.3.0
> * MySQL 5.7.18
> * Wildfly 10
>            Reporter: Pedro Inácio
>            Assignee: Steven Hawkins
>         Attachments: server.log
>
>
> *Scenario*: Having several views that depend on others (ex: V1-> V2->V3, where V3 depends on V2 and V2 depends on V1), all with external materialization.
> Although all views LoadState is *LOADED *even after failures due to the dependent ones being loaded, in the end some views have zero (0) of cardinality, when there are actually records. Running the queries by hand return records.
> Log attached.
> Example: 
> {panel}
> 2017-06-14 17:14:39,521 INFO  [org.teiid.MATVIEWS] (Worker63_QueryProcessorQueue19799) WDpoyHmXlkvS Materialization of view VodafoneNlBaseSource.vodafone_nl_base_source completed. Rows updated = 0 Load Number = 1
> {panel}
> After forcing the view update:
> {panel}
> 2017-06-14 17:23:38,042 INFO  [org.teiid.MATVIEWS] (Worker65_QueryProcessorQueue27597) +IbRaNRtrZ1K Materialization of view VodafoneNlBaseSource.vodafone_nl_base_source completed. Rows updated = 1816 Load Number = 2
> {panel}



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)



More information about the teiid-issues mailing list