1 2 Previous Next 18 Replies Latest reply on May 29, 2012 9:21 PM by shawkins

    Internal Materialized Views

      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

          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
            rareddy

            Sateesh,

             

            Please see this WIKI article for materialization.

             

            Ramesh..

            • 3. Re: Internal Materialized Views

              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
                rareddy

                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

                  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

                    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
                      rareddy

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

                      • 8. Re: Internal Materialized Views

                        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
                          rareddy

                          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

                            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
                              rareddy

                              Sateesh,

                               

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

                               

                              Thank you.


                              Ramesh..

                              • 12. Re: Internal Materialized Views

                                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

                                  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
                                    shawkins

                                    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