1 2 Previous Next 18 Replies Latest reply: May 29, 2012 9:21 PM by Steven Hawkins Go to original post RSS
  • 15. Re: Internal Materialized Views
    sateesh kumar Newbie

    Hi Steven,


      Thanks for your response.


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


      What happens if i execute a "select * from mat_view_table" during the initialization phase. Does it makes the entire contents of the table be cached in memory ?


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


        I executed the following code



                StringBuilder strQuery = new StringBuilder("SELECT * FROM "+tableName);

                Statement st = conn.createStatement();

                ResultSet rs = st.executeQuery(strQuery.toString());

                int counter =0;/*




                System.out.println(" Total No.of Rows=["+counter+"]");



        And saw the following entries in the log. It pirnted out the current row count 512 and 1024 before closing out the processor. Not sure what it means or why it selected only 512 & 1024.


        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,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


        I might be reading too much into the logs.



  • 16. Re: Internal Materialized Views
    Ramesh Reddy Master



    If you run the command once the server starts, Yes it will cache all the contents of the view table's data into cache. (Note that Cache does not always mean memory in Teiid, it could be part memory and disk depending upon the resource availability and configuration).


    The log you are looking at correspond to the query you executed, but it does *not* correspond to how many rows it cached. In Teiid all the data is processed in  batches of 1024/512 tuples, which are defined for effective processing from source and inside the engine processing. You are seeing one occurrence of those data fetching. Usally when Teiid loads the materialized table it writes log message to the console window as to how many rows it has fetched.


    One way you can check how many rows are being returned from source is with running OPTION NOCACHE like for ex:


    select count(*) from mat_view_table OPTION NOCACHE



  • 17. Re: Internal Materialized Views
    sateesh kumar Newbie

    Hi Ramesh,


      Thanks for fixing the NPE Jira Ticket you have opened.




      How can i get this fix ?? I cannot find a nighly build or 8.1 version in the download page.



  • 18. Re: Internal Materialized Views
    Steven Hawkins Master

    8.1 Alpha1 will be posted this week or you can build trunk using svn/maven:


    svn co https://anonsvn.jboss.org/repos/teiid/trunk

    cd trunk

    mvn -P release install


    the release artifacts will then be in trunk/build/target

1 2 Previous Next