1 2 Previous Next 18 Replies Latest reply: May 29, 2012 9:21 PM by Steven Hawkins RSS

Internal Materialized Views

sateesh kumar Newbie

Hi,

 

  I have created a VDB and as of now the Tables in the VDB has one to one relationship with actual DB Tables. (No Joins etc).

 

  In the Designer i couldn't set the "Materialize" property to true for any of these tables. The value is false by default.

 

  Also if i can set this value to true does the entire table gets loaded into memory ?? ( I will be using internal materialized veiws).

 

  If the entire table is in the memory how the SQL Queries send by the client gets translated and exeucted ??

 

  (Does Teiid uses Hibernate internally and even so there has to be some SQL Processing engine). Not sure what Teiid is using if at all it supports running SQL Queries against the In memroy table.

 

 

Thanks
Sateesh

  • 1. Re: Internal Materialized Views
    sateesh kumar Newbie

    As per the documentation for Teiid Designer 7.7 one should be able to create a Materialzied by doing:

     

    Right-click on one or more view tables in the Section 10.2.1, “Model Explorer View” and select the Modeling > Create Materialized Views action.

     

    How ever when i right click on the BaseTables i have created in by VDB or right click on any of the new Siblings i have created out of those "BaseTables" i only see the option of "Creating Web Service" as shown below.

     

    Create_MView.jpg

     

    Thanks

    Sateesh

  • 2. Re: Internal Materialized Views
    Ramesh Reddy Master

    Sateesh,

     

    Please see this WIKI article for materialization.

     

    Ramesh..

  • 3. Re: Internal Materialized Views
    sateesh kumar Newbie

    Hi Ramesh,

     

      Thanks for the info.

     

      I cannot edit the property "Materialized" for any of the Tables in my Model. I can change the values of other properties (Materialized Table, System, Supports Update, Name In Source etc)  without any Problems.

     

      when i doubel click on that cell nothing happens.It seems it is read only.

     

      It is mentioned in that article that Materialization is not allowed on Dynamic VDBs. But the one i created using the Designer is not Dynamic.

     

       Not sure why i cannot edit this property !!

     

    Thanks
    Sateesh

  • 4. Re: Internal Materialized Views
    Ramesh Reddy Master

    Sateesh,

     

    Materialization is only allowed on View (tables in view model) tables, not on source tables(tables in source model). In 8.0, materialization in Dynamic VDBs also supported however you must define the metadata for for your VDB using DDL.

     

    Ramesh..

  • 5. Re: Internal Materialized Views
    sateesh kumar Newbie

    Hi Ramesh,

     

      Thanks for your help.

     

      I created a View Model and able to transform the Model Elements from Source Model to View Model and able to set the Materialize property to true for all the Tables.

     

      When i validate the Model in Designer it says no Errors.

     

      How ever when i deploy the newly created .vdb to JBoss AS then i am seeing the following Errors in the console.

     

    15:46:16,732 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 1) JBAS018565: Replaced deployment "ViewModel.vdb" with deployment "ViewModel.vdb"

    15:46:16,732 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID50030 VDB PREVIEW_6214b956-7884-4cac-a010-0cfdd2c5bd18_MyTeiidProject_schemas_ViewModel.1 model "ViewModel" metadata loaded. End Time: 5/15/12 3:46 PM

    15:46:16,732 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 1) TEIID31080 View ViewModel.SCHEMA_NAME.TABLE1 validation error: [QueryResolverException]Group does not exist: DHS2D_NEW.SCHEMA_NAME.TABLE1

    15:46:16,872 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID40073 The metadata for the VDB PREVIEW_6214b956-7884-4cac-a010-0cfdd2c5bd18_MyTeiidProject_schemas_ViewModel.1 is loaded, however it is not valid. Check models for errors. Correct the metadata and re-deploy.

    15:46:16,872 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID40006 VDB PREVIEW_6214b956-7884-4cac-a010-0cfdd2c5bd18_MyTeiidProject_schemas_ViewModel.1 is set to "inactive".

     

    When i checked the View Model and Select the Specific Table to view the Query that's beeen used to created the Table (in View Model).

     

        SELECT

            *

        FROM

            DHS2D_NEW.SCHEMA_NAME.TABLE1

     

    The Validation Erros JBoss is complaining about are because i used the same name in Source and View Model ?? I tried changing the name but got the same error..

     

    And when i clicked on "Validate Transformations" on the View Model it didn't return any errors..

     

    Thanks

    Sateesh

  • 6. Re: Internal Materialized Views
    sateesh kumar Newbie

    Hi,

     

      I am able to resolve the validation error by creating a new VDB and adding the Source and View Model to it and deploying the newly created VDB.

     

      How ever when i tried to run the Queries asgainst the View Model there seems to be some ambiguity in the group name.

     

     

    17:00:03,465 INFO  [org.teiid.RUNTIME] (MSC service thread 1-1) TEIID50029 VDB FinalVDB.1 model "DHS2D_NEW" metadata is currently being loaded. Start Time: 5/15/12 5:00 PM

    17:00:03,471 INFO  [org.teiid.RUNTIME] (MSC service thread 1-1) TEIID50029 VDB FinalVDB.1 model "ViewModel" metadata is currently being loaded. Start Time: 5/15/12 5:00 PM

    17:00:03,544 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID50030 VDB FinalVDB.1 model "DHS2D_NEW" metadata loaded. End Time: 5/15/12 5:00 PM

    17:00:03,544 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID50030 VDB FinalVDB.1 model "ViewModel" metadata loaded. End Time: 5/15/12 5:00 PM

    17:00:03,555 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018565: Replaced deployment "FinalVDB.vdb" with deployment "FinalVDB.vdb"

    17:00:03,575 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID40003 VDB FinalVDB.1 is set to "active"

    17:00:33,398 WARN  [org.teiid.PROCESSOR] (Worker6_QueryProcessorQueue31) TEIID30020 Processing exception 'Group specified is ambiguous, resubmit the query by fully qualifying the group name:SCHEMA_NAME.TABLE1' for request CXfcT+xOjEwL.0.  Exception type org.teiid.api.excep

    tion.query.QueryResolverException thrown from org.teiid.query.resolver.util.ResolverUtil.handleUnresolvedGroup(ResolverUtil.java:779). Enable more detailed logging to see the entire stacktrace.

    17:00:58,808 ERROR [org.teiid.PROCESSOR] (Worker6_QueryProcessorQueue32) TEIID30019 Unexpected exception for request 8waFyQR1nfVn.0: java.lang.NullPointerException

            at org.teiid.query.optimizer.relational.RelationalPlanner.resolveVirtualGroup(RelationalPlanner.java:1233) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

            at org.teiid.query.optimizer.relational.RelationalPlanner.buildTree(RelationalPlanner.java:836) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

            at org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:737) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

            at org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:696) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

            at org.teiid.query.optimizer.relational.RelationalPlanner.generatePlan(RelationalPlanner.java:490) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

            at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:180) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

            at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:188) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

            at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:429) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

            at org.teiid.dqp.internal.process.Request.processRequest(Request.java:449) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

            at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:534) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

            at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:278) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

            at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

            at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:217) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

            at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:241) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

            at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

            at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

            at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885) [rt.jar:1.6.0_05]

            at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907) [rt.jar:1.6.0_05]

     

    Thanks
    Sateesh

  • 7. Re: Internal Materialized Views
    Ramesh Reddy Master

    Use fully qualified names for tables like  select * from "viewname"."tablename".

  • 8. Re: Internal Materialized Views
    sateesh kumar Newbie

    Hi Ramesh,

     

      Here is the VDB and the Model names in it.

     

      VDB Name : FinalVDB.vdb

     

      FinalVDB.jpg

     

    It has the Source Model "DSH2D_New.xmi" and the View Model "ViewModel.xml"

     

    There is a table "SCHEMA_NAME.TABLE1" in Source Model "DSH2D_New.xmi"

     

    <relational:BaseTable xmi:uuid="mmuuid:b751e716-ed1e-41fc-8661-eeb948076287" name="SCHEMA_NAME.TABLE1" nameInSource="&quot;SCHEMA_NAME&quot;.&quot;TABLE1&quot;">

        <columns xmi:uuid="mmuuid:5d4ea9e9-3bdb-4700-8591-a11c6ec2a94d" name="EMP_ID" nameInSource="EMP_ID" nativeType="VARCHAR2" length="33" nullable="NO_NULLS">

          <type href="http://www.w3.org/2001/XMLSchema#string"/>

        </columns>

        <columns xmi:uuid="mmuuid:be27e861-b493-4c3a-88a1-ea55ba05c083" name="EMP_NAME" nameInSource="EMP_NAME" nativeType="VARCHAR2" length="4000">

          <type href="http://www.w3.org/2001/XMLSchema#string"/>

        </columns>

      </relational:BaseTable>

     

    The above Table is called TABLE1 in View Model which is defined using the following SQL:

     

    SELECT * FROM DHS2D_NEW.SCHEMA_NAME.TABLE1

     

    After successful deployment of FinalVDB.vdb  (This is the only vdb file i am deploying to JBoss) My Client code succeeds only if the Table Name is DHS2D_NEW.SCHEMA_NAME.TABLE1

     

    All the following are failing:

     

    SELECT * FROM ViewModel.TABLE1  (Caused by: java.lang.NullPointerException    at org.teiid.query.optimizer.relational.RelationalPlanner.resolveVirtualGroup(RelationalPlanner.java:1233))

     

    SELECT * FROM FinalVDB.TABLE1    ( Group does not exist: FinalVDB.TABLE1)

     

    SELECT * FROM TABLE1  (Succeeds)   It looks like i don't need to preced this with View Name !!.

     

    I hope the Query against Table  DHS2D_NEW.SCHEMA_NAME.TABLE1 goes to the Table in Oracle where as the one against  TABLE1 is going against the Cached Materialized View in Teiid.

     

    Thanks
    Sateesh

  • 9. Re: Internal Materialized Views
    Ramesh Reddy Master

    Sateesh,

     

    Any of these forms are correct.

     

    1. select * from <vdb-name>.<model-name>.<table-name>
    2. select * from <model-name>.<table-name>
    3. select * from <table-name>

     

    If there are same named table in multiple models, then only 1 or 2 are allowed, otherwise 1, 2 and 3 is allowed.

     

    This is wrong

     

    select * from <vdb-name>.<table-name>

     

    Given that, show us the full exception from

     

    SELECT * FROM ViewModel.TABLE1  (Caused by: java.lang.NullPointerException    at org.teiid.query.optimizer.relational.RelationalPlanner.resolveVirtualGroup(RelationalPlanner.java:1233))

     

    this should have succeeded.

     

    Ramesh..

  • 10. Re: Internal Materialized Views
    sateesh kumar Newbie

    Hi Ramesh,

     

    Here is the complete stack trace from Server Log.

     

    10:22:23,456 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@5d661c

    10:22:23,468 DEBUG [org.teiid.SECURITY] (New I/O server worker #1-1) authenticateUser user JDBC

    10:22:23,508 DEBUG [org.teiid.SECURITY] (New I/O server worker #1-1) Logon successful for " user "

    10:22:23,512 DEBUG [org.teiid.SECURITY] (New I/O server worker #1-1) Logon successful, created session: sessionid=DCZLrQHFkxwY; userName=user@teiid-security; vdbName=FinalVDB; vdbVersion=1; createdTime=Wed May 16 10:22:23 EDT 2012; applicationName=JDBC; clientHostName=2SRDBM1; clientHardwareAddress=0024D69C272A; IPAddress=127.0.0.1; securityDomain=teiid-security; lastPingTime=Wed May 16 10:22:23 EDT 2012

    10:22:23,524 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1)  message: MessageHolder: contents=org.teiid.client.security.LogonResult@1c1e97f for message:0

    10:22:23,577 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@cf601c

    10:22:23,593 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) Request Thread DCZLrQHFkxwY.0 with state NEW

    10:22:23,597 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) DCZLrQHFkxwY.0 Non-cachable command.

    10:22:23,600 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) DCZLrQHFkxwY.0 executing  SELECT COUNT(*) FROM ViewModel.TABLE1

    10:22:23,657 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) Request Thread DCZLrQHFkxwY.0 - error occurred: java.lang.NullPointerException

        at org.teiid.query.optimizer.relational.RelationalPlanner.resolveVirtualGroup(RelationalPlanner.java:1233) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.query.optimizer.relational.RelationalPlanner.buildTree(RelationalPlanner.java:836) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:737) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:696) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.query.optimizer.relational.RelationalPlanner.generatePlan(RelationalPlanner.java:490) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:180) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:188) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:429) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.dqp.internal.process.Request.processRequest(Request.java:449) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:534) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:278) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:217) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:241) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885) [rt.jar:1.6.0_05]

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907) [rt.jar:1.6.0_05]

        at java.lang.Thread.run(Thread.java:619) [rt.jar:1.6.0_05]

     

    10:22:23,733 ERROR [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) TEIID30019 Unexpected exception for request DCZLrQHFkxwY.0: java.lang.NullPointerException

        at org.teiid.query.optimizer.relational.RelationalPlanner.resolveVirtualGroup(RelationalPlanner.java:1233) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.query.optimizer.relational.RelationalPlanner.buildTree(RelationalPlanner.java:836) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:737) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:696) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.query.optimizer.relational.RelationalPlanner.generatePlan(RelationalPlanner.java:490) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:180) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:188) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:429) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.dqp.internal.process.Request.processRequest(Request.java:449) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:534) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:278) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:217) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:241) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885) [rt.jar:1.6.0_05]

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907) [rt.jar:1.6.0_05]

        at java.lang.Thread.run(Thread.java:619) [rt.jar:1.6.0_05]

     

    10:22:23,860 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) Sending error to client DCZLrQHFkxwY.0: java.lang.NullPointerException

        at org.teiid.query.optimizer.relational.RelationalPlanner.resolveVirtualGroup(RelationalPlanner.java:1233) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.query.optimizer.relational.RelationalPlanner.buildTree(RelationalPlanner.java:836) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:737) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:696) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.query.optimizer.relational.RelationalPlanner.generatePlan(RelationalPlanner.java:490) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:180) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:188) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:429) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.dqp.internal.process.Request.processRequest(Request.java:449) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:534) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:278) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:217) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:241) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885) [rt.jar:1.6.0_05]

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907) [rt.jar:1.6.0_05]

        at java.lang.Thread.run(Thread.java:619) [rt.jar:1.6.0_05]

     

     

    And here is what the Client is logging out:

     

    connection =[org.teiid.jdbc.ConnectionImpl@139b78e]

    org.teiid.jdbc.TeiidSQLException: org.teiid.core.TeiidException

        at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)

        at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)

        at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:654)

        at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:62)

        at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:565)

        at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:130)

        at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:37)

        at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:75)

        at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:222)

        at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:257)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:102)

        at $Proxy1.read(Unknown Source)

        at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:356)

        at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:574)

        at org.teiid.jdbc.StatementImpl.executeQuery(StatementImpl.java:336)

        at teiid.TeiidClient.main(TeiidClient.java:32)

    Caused by: [TeiidException]

    1 [NullPointerException]

        at org.teiid.client.ResultsMessage.setException(ResultsMessage.java:172)

        at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:763)

        at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:488)

        at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:316)

        at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)

        at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:217)

        at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:241)

        at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)

        at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288)

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)

        at java.lang.Thread.run(Thread.java:619)

    Caused by: java.lang.NullPointerException

        at org.teiid.query.optimizer.relational.RelationalPlanner.resolveVirtualGroup(RelationalPlanner.java:1233)

        at org.teiid.query.optimizer.relational.RelationalPlanner.buildTree(RelationalPlanner.java:836)

        at org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:737)

        at org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:696)

        at org.teiid.query.optimizer.relational.RelationalPlanner.generatePlan(RelationalPlanner.java:490)

        at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:180)

        at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:188)

        at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:429)

        at org.teiid.dqp.internal.process.Request.processRequest(Request.java:449)

        at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:534)

        at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:278)

        ... 8 more

     

    Thanks

    Sateesh

  • 11. Re: Internal Materialized Views
    Ramesh Reddy Master

    Sateesh,

     

    Logged https://issues.jboss.org/browse/TEIID-2049 for the NPE issue above.

     

    Thank you.


    Ramesh..

  • 12. Re: Internal Materialized Views
    sateesh kumar Newbie

    Hi Ramesh,

     

      It looks like for the Internalized Materialized Views unless a query is executed against them the Results are not cached ??

     

      The documentation talks about refreshing them / invalidating them either using the Query or Admin Console.

     

      Is there a way to configure these Internalized MViews so that they get loaded into Memory when the JBoss Server starts ??

     

      In the default standalone-teiid.xml i see the followingb settings..

     

               <cache-container name="teiid" default-cache="resultset">

                    <local-cache name="resultset">

                        <eviction strategy="LRU" max-entries="1024"/>

                        <expiration lifespan="7200000"/>

                    </local-cache>

                </cache-container>

     

      Is this the only configuration setting which dictates how the Teiid Internal Materialized View Results are cached ??

     

      Another thing i noticed after going through the Server logs is when ever a Query/call is made to Teiid i see the following exception after successful completion of the Query/client call. I have changed the logging settings to DEBUG mode.

     

    11:10:18,425 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue5533) BNm1i90DXQop.1.0.3 Closed connection

    11:10:18,443 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-2) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@166576a

    11:10:18,448 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-2) closeQuery for requestID=BNm1i90DXQop.1

    11:10:18,451 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-2)  message: MessageHolder: contents=null for message:4006

    11:10:18,451 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue5534) Request Thread BNm1i90DXQop.1 with state PROCESSING

    11:10:18,455 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-2) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@1069bef

    11:10:18,457 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue5534) Removing tuplesource for the request BNm1i90DXQop.1

    11:10:18,461 DEBUG [org.teiid.SECURITY] (New I/O server worker #1-2) closeSession BNm1i90DXQop

    11:10:18,464 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue5534) Removing TupleBuffer: 3

    11:10:18,466 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-2) cancelQuery for requestID=BNm1i90DXQop.1

    11:10:18,472 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-2) Failed to Cancel request, as request already finished processing

    11:10:18,475 DEBUG [org.teiid.TXN_LOG] (New I/O server worker #1-2) before cancelTransactions:org.teiid.dqp.internal.process.TransactionServerImpl@1193d1e(BNm1i90DXQop,false)

    11:10:18,480 DEBUG [org.teiid.TXN_LOG] (New I/O server worker #1-2) after cancelTransactions : null

    11:10:18,482 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-2)  message: MessageHolder: contents=null for message:4007

    11:10:18,493 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) Unhandled exception, closing client instance: java.io.IOException: An existing connection was forcibly closed by the remote host

        at sun.nio.ch.SocketDispatcher.read0(Native Method) [rt.jar:1.6.0_05]

        at sun.nio.ch.SocketDispatcher.read(SocketDispatcher.java:25) [rt.jar:1.6.0_05]

        at sun.nio.ch.IOUtil.readIntoNativeBuffer(IOUtil.java:233) [rt.jar:1.6.0_05]

        at sun.nio.ch.IOUtil.read(IOUtil.java:200) [rt.jar:1.6.0_05]

        at sun.nio.ch.SocketChannelImpl.read(SocketChannelImpl.java:236) [rt.jar:1.6.0_05]

        at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:323) [netty-3.2.6.Final.jar:]

        at org.jboss.netty.channel.socket.nio.NioWorker.processSelectedKeys(NioWorker.java:282) [netty-3.2.6.Final.jar:]

        at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:202) [netty-3.2.6.Final.jar:]

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885) [rt.jar:1.6.0_05]

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907) [rt.jar:1.6.0_05]

        at java.lang.Thread.run(Thread.java:619) [rt.jar:1.6.0_05]

     

    11:10:18,525 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) Channel closed

    11:10:18,495 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-2) Unhandled exception, closing client instance: java.io.IOException: An existing connection was forcibly closed by the remote host

        at sun.nio.ch.SocketDispatcher.read0(Native Method) [rt.jar:1.6.0_05]

        at sun.nio.ch.SocketDispatcher.read(SocketDispatcher.java:25) [rt.jar:1.6.0_05]

        at sun.nio.ch.IOUtil.readIntoNativeBuffer(IOUtil.java:233) [rt.jar:1.6.0_05]

        at sun.nio.ch.IOUtil.read(IOUtil.java:200) [rt.jar:1.6.0_05]

        at sun.nio.ch.SocketChannelImpl.read(SocketChannelImpl.java:236) [rt.jar:1.6.0_05]

        at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:323) [netty-3.2.6.Final.jar:]

        at org.jboss.netty.channel.socket.nio.NioWorker.processSelectedKeys(NioWorker.java:282) [netty-3.2.6.Final.jar:]

        at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:202) [netty-3.2.6.Final.jar:]

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885) [rt.jar:1.6.0_05]

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907) [rt.jar:1.6.0_05]

        at java.lang.Thread.run(Thread.java:619) [rt.jar:1.6.0_05]

     

    Thnks
    Sateesh

  • 13. Re: Internal Materialized Views
    sateesh kumar Newbie

    Hi Ramesh,

     

      I have updated the Teiid Configuration File as listed below. i.e, no expiration and no eviction.

     

                <cache-container name="teiid" default-cache="resultset">

                    <local-cache name="resultset"/>

                </cache-container>

     

     

    And when i ran the Query "SELECT * FROM TABLE1" i see the following in the Server Log... (trying to understand how the Internalized MView Internals w.r.to caching)..

     

    11:36:33,986 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #2-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@23ed31

     

    11:36:33,997 DEBUG [org.teiid.SECURITY] (New I/O server worker #2-1) authenticateUser user JDBC

     

    11:36:34,023 DEBUG [org.teiid.SECURITY] (New I/O server worker #2-1) Logon successful for " user "

     

    11:36:34,027 DEBUG [org.teiid.SECURITY] (New I/O server worker #2-1) Logon successful, created session: sessionid=JOGvPYsbxx2Q; userName=user@teiid-security; vdbName=FinalVDB; vdbVersion=1; createdTime=Wed May 16 11:36:34 EDT 2012; applicationName=JDBC; clientHostName=2SRDBM1; clientHardwareAddress=XXX; IPAddress=127.0.0.1; securityDomain=teiid-security; lastPingTime=Wed May 16 11:36:34 EDT 2012

     

    11:36:34,037 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #2-1)  message: MessageHolder: contents=org.teiid.client.security.LogonResult@1589559 for message:0

     

    11:36:34,077 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #2-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@1be6f3c

     

    11:36:34,095 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) Request Thread JOGvPYsbxx2Q.0 with state NEW

     

    11:36:34,098 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) JOGvPYsbxx2Q.0 Non-cachable command.

     

    11:36:34,100 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) JOGvPYsbxx2Q.0 executing  SELECT * FROM TABLE1

     

    11:36:34,408 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) ProcessTree for JOGvPYsbxx2Q.0 AccessNode(0) output=[DHS2D_NEW.SCHEMA_NAME.TABLE1.EMP_ID, DHS2D_NEW.SCHEMA_NAME.TABLE1.EMP_NAME FROM DHS2D_NEW.SCHEMA_NAME.TABLE1 AS g_0

     

     

     

    11:36:34,961 DEBUG [org.teiid.TXN_LOG] (Worker0_QueryProcessorQueue0) before getOrCreateTransactionContext:org.teiid.dqp.internal.process.TransactionServerImpl@8bd6e8(JOGvPYsbxx2Q)

     

    11:36:34,967 DEBUG [org.teiid.TXN_LOG] (Worker0_QueryProcessorQueue0) after getOrCreateTransactionContext : JOGvPYsbxx2Q NONE ID:NONE

     

    11:36:34,979 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue0) Creating FileStore: 0_lobs

     

    11:36:34,987 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue0) Creating TupleBuffer: 0 [DHS2D_NEW.SCHEMA_NAME.TABLE1.EMP_ID, DHS2D_NEW.SCHEMA_NAME.TABLE1.EMP_NAME] [class java.lang.String, class java.lang.String] of type PROCESSOR

     

    11:36:35,584 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue0) JOGvPYsbxx2Q.0.0.0 Create State

     

    11:36:35,592 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue0) JOGvPYsbxx2Q.0.0.0 Blocking on source query

     

    11:36:35,593 DEBUG [org.teiid.PROCESSOR] (Worker1_QueryProcessorQueue1) Running task for parent thread Worker0_QueryProcessorQueue0

     

    11:36:35,598 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue0) JOGvPYsbxx2Q.0 Blocking on source request(s).

     

    11:36:35,608 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) JOGvPYsbxx2Q.0.0.0 Processing NEW request: SELECT g_0.EMP_ID, g_0.EMP_NAME FROM DHS2D_NEW.SCHEMA_NAME.TABLE1 AS g_0

     

    11:36:35,611 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) Request Thread JOGvPYsbxx2Q.0 - processor blocked

     

    11:36:35,747 DEBUG [org.jboss.jca.core.connectionmanager.pool.idle.IdleRemover] (Worker1_QueryProcessorQueue1) Register pool: SemaphoreArrayListManagedConnectionPool@1c82121[pool=test] (interval=1800000)

     

    11:36:35,752 DEBUG [org.jboss.jca.core.connectionmanager.pool.idle.IdleRemover] (Worker1_QueryProcessorQueue1) About to notify thread: old next: 1337183495752, new next: 1337183495752

     

    11:36:35,757 DEBUG [org.jboss.jca.core.connectionmanager.pool.idle.IdleRemover] (IdleRemover) Notifying pools, interval: 900000

     

    11:36:35,759 DEBUG [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (Worker1_QueryProcessorQueue1) test: getConnection(null, null) [0/20]

     

    11:36:35,767 DEBUG [org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory] (Worker1_QueryProcessorQueue1) Driver loaded and instance created:oracle.jdbc.OracleDriver@1002a9d

     

    11:36:36,207 DEBUG [org.jboss.jca.adapters.jdbc.WrapperDataSource] (Worker1_QueryProcessorQueue1) UserTransaction not found

     

    11:36:36,211 INFO  [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) OracleExecutionFactory Commit=true;DatabaseProductName=Oracle;DatabaseProductVersion=Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

     

    With the Partitioning, OLAP, Data Mining and Real Application Testing options;DriverMajorVersion=11;DriverMajorVersion=2;DriverName=Oracle JDBC driver;DriverVersion=11.2.0.1.0;IsolationLevel=2

     

    11:36:36,224 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) JOGvPYsbxx2Q.0.0.0 Obtained execution

     

    11:36:36,230 DEBUG [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue1)     START DATA SRC COMMAND:    startTime=2012-05-16 11:36:36.229    requestID=JOGvPYsbxx2Q.0    sourceCommandID=0    txID=null    modelName=DHS2D_NEW    translatorName=oracle    sessionID=JOGvPYsbxx2Q    principal=user@teiid-security    sql=SELECT g_0.EMP_ID, g_0.EMP_NAME FROM DHS2D_NEW.SCHEMA_NAME.TABLE1 AS g_0

     

    11:36:36,432 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) Source-specific command: SELECT g_0.EMP_ID, g_0.EMP_NAME FROM "SCHEMA_NAME"."TABLE1" AS g_0

     

    11:36:37,347 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) JOGvPYsbxx2Q.0.0.0 Executed command

     

    11:36:37,350 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) JOGvPYsbxx2Q.0.0.0 Getting results from connector

     

    11:36:37,432 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) JOGvPYsbxx2Q.0.0.0 Obtained results from connector, current row count: 512

     

    11:36:37,440 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2) Request Thread JOGvPYsbxx2Q.0 with state PROCESSING

     

    11:36:37,451 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2) [RequestWorkItem.sendResultsIfNeeded] requestID: JOGvPYsbxx2Q.0 resultsID: 0 done: false

     

    11:36:37,451 DEBUG [org.teiid.PROCESSOR] (Worker1_QueryProcessorQueue3) Running task for parent thread Worker0_QueryProcessorQueue2

     

    11:36:37,459 DEBUG [org.teiid.TRANSPORT] (Worker0_QueryProcessorQueue2)  message: MessageHolder: contents=ResultsMessage rowCount=128 finalRow=-1 for message:1

     

    11:36:37,461 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue3) JOGvPYsbxx2Q.0.0.0 Processing MORE request

     

    11:36:37,540 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2) JOGvPYsbxx2Q.0.0.0 Blocking on source query

     

    11:36:37,545 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2) JOGvPYsbxx2Q.0 Blocking on source request(s).

     

    11:36:37,541 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue3) JOGvPYsbxx2Q.0.0.0 Getting results from connector

     

    11:36:37,626 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2) Request Thread JOGvPYsbxx2Q.0 - processor blocked

     

    11:36:37,737 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #2-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@1f3305e

     

    11:36:37,770 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #2-1) closeQuery for requestID=JOGvPYsbxx2Q.0

     

    11:36:37,774 DEBUG [org.teiid.CONNECTOR] (New I/O server worker #2-1) JOGvPYsbxx2Q.0.0.0 Processing CANCEL request

     

    11:36:37,778 DEBUG [org.teiid.COMMAND_LOG] (New I/O server worker #2-1)     CANCEL SRC COMMAND:    endTime=2012-05-16 11:36:37.777    requestID=JOGvPYsbxx2Q.0    sourceCommandID=0    txID=null    modelName=DHS2D_NEW    translatorName=oracle    sessionID=JOGvPYsbxx2Q    principal=user@teiid-security    finalRowCount=-1

     

    11:36:37,787 DEBUG [org.teiid.CONNECTOR] (New I/O server worker #2-1) The atomic request JOGvPYsbxx2Q.0.0.0 has been canceled.

     

    11:36:37,790 DEBUG [org.teiid.TXN_LOG] (New I/O server worker #2-1) before cancelTransactions:org.teiid.dqp.internal.process.TransactionServerImpl@8bd6e8(JOGvPYsbxx2Q,true)

     

    11:36:37,765 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue3) JOGvPYsbxx2Q.0.0.0 Obtained results from connector, current row count: 1024

     

    11:36:37,799 DEBUG [org.teiid.TXN_LOG] (New I/O server worker #2-1) after cancelTransactions : null

     

    11:36:37,803 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue4) Request Thread JOGvPYsbxx2Q.0 with state PROCESSING

     

    11:36:37,817 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue4) QueryProcessor: closing processor

     

    11:36:37,821 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue4) Removing tuplesource for the request JOGvPYsbxx2Q.0

     

    11:36:37,825 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue4) Removing TupleBuffer: 0

     

    11:36:37,821 DEBUG [org.teiid.PROCESSOR] (Worker1_QueryProcessorQueue5) Running task for parent thread Worker0_QueryProcessorQueue4

     

    11:36:37,807 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #2-1)  message: MessageHolder: contents=null for message:2

     

    11:36:37,844 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue5) JOGvPYsbxx2Q.0.0.0 Remove State

     

    11:36:37,853 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue5) JOGvPYsbxx2Q.0.0.0 Processing Close : SELECT g_0.EMP_ID, g_0.EMP_NAME FROM DHS2D_NEW.SCHEMA_NAME.TABLE1 AS g_0

     

    It looks like it still is cahcing 1024 Rows from the above logs!! Is it the default settings ??

     

    Thanks

    Sateesh

  • 14. Re: Internal Materialized Views
    Steven Hawkins Master

    Here's answers to questions from the previous two posts.

     

    > It looks like for the Internalized Materialized Views unless a query is executed against them the Results are not cached ??

     

    Yes that is correct.

     

    > Is there a way to configure these Internalized MViews so that they get loaded into Memory when the JBoss Server starts ??

     

    Not currently.  An internal mat view table load happens in the context of an authenticated user.  In the initial design we did not want to require adding a system account to the configuration for view loads.  That can be requested as an enhancement.

     

    > Is this the only configuration setting which dictates how the Teiid Internal Materialized View Results are cached ??

     

    Materialization does not interact with the caching configuration.  Once a materialization table is created it should be invalidated/reloaded via system calls - https://docs.jboss.org/author/display/teiid80final/Internal+Materialization or by adding ttl metadata to the view cache hint - https://docs.jboss.org/author/display/teiid80final/Hints+and+Options

     

    > It looks like it still is cahcing 1024 Rows from the above logs!! Is it the default settings ??

     

    I don't see result set caching or materialization being utilized from that log snippet.  What is your expectation?

1 2 Previous Next