[jira] [Created] (TRAFODION-1067) LP Bug: 1433926 - query stats are not published to METRIC_QUERY_TABLE if the query time is greater than STATISTICSLIMIT and smaller than STATISTICSINTERVAL

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-1067:
-------------------------------------

             Summary: LP Bug: 1433926 - query stats are not published to METRIC_QUERY_TABLE if the query time is greater than STATISTICSLIMIT and smaller than STATISTICSINTERVAL
                 Key: TRAFODION-1067
                 URL: https://issues.apache.org/jira/browse/TRAFODION-1067
             Project: Apache Trafodion
          Issue Type: Bug
          Components: connectivity-mxosrvr
            Reporter: FengQiang
            Assignee: JudyZhao
            Priority: Critical
             Fix For: 2.0-incubating


Here are the parameters.
mxosrvr -ZKHOST n007.cm.cluster:2181 -RZ n007.cm.cluster:1:6 -ZKPNODE /trafodion -CNGTO 60 -ZKSTO 180 -EADSCO 0 -TCPADD 16.235.162.84 -MAXHEAPPCT 0 -STATISTICSINTERVAL 60 -STATISTICSLIMIT 1 -STATISTICSTYPE aggregated -STATISTICSENABLE true -SQLPLAN false -PORTMAPTOSECS -1 -PORTBINDTOSECS -1

This one was published
SQL>insert into VITO_TEST.tab1 select colint, 'a' from VITO_TEST.fun f where f.colint < 100000000;

--- 15625 row(s) inserted.


Start Time             2015/03/19 05:51:08.266558
End Time               2015/03/19 05:52:38.551538
Elapsed Time                      00:01:30.284980
Compile Time                      00:00:00.047735
Execution Time                    00:01:30.236976

But this one was not in the table
SQL>insert into VITO_TEST.tab1 select colint, 'a' from VITO_TEST.fun f where f.colint < 100000;

--- 3125 row(s) inserted.


Start Time             2015/03/19 05:46:21.893948
End Time               2015/03/19 05:46:27.043882
Elapsed Time                      00:00:05.149934
Compile Time                      00:00:00.011382
Execution Time                    00:00:05.138318



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)