You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by su...@apache.org on 2017/03/28 21:02:08 UTC
[2/6] incubator-trafodion git commit: [TRAFODION-2420] RMS
enhancements Introduced 2 new counters HeapWM: - "SQL Heap WM" - Tracks the
high water mark of the used memory including space buffer and bmo operator
memory. It is enough to moni
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/ae3eca8a/core/sql/regress/core/EXPECTEDRTS
----------------------------------------------------------------------
diff --git a/core/sql/regress/core/EXPECTEDRTS b/core/sql/regress/core/EXPECTEDRTS
index c75fae3..fe5637c 100755
--- a/core/sql/regress/core/EXPECTEDRTS
+++ b/core/sql/regress/core/EXPECTEDRTS
@@ -56,10 +56,10 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
--- SQL operation complete.
>>log LOGRTS;
>>get statistics for qid current ;
-Qid MXID11000027092212353966950645999000000000206U3333300_303_S1
-Compile Start Time 2017/02/16 01:02:45.193696
-Compile End Time 2017/02/16 01:02:45.225119
-Compile Elapsed Time 0:00:00.031423
+Qid MXID11000006521212357413143091999000000000206U3333300_579_S1
+Compile Start Time 2017/03/27 22:19:35.703280
+Compile End Time 2017/03/27 22:19:35.732216
+Compile Elapsed Time 0:00:00.028936
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -94,11 +94,11 @@ Stats Collection Type ACCUMULATED_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_303_S1 ;
-Qid MXID11000027092212353966950645999000000000206U3333300_303_S1
-Compile Start Time 2017/02/16 01:02:45.193696
-Compile End Time 2017/02/16 01:02:45.225119
-Compile Elapsed Time 0:00:00.031423
+>>display statistics for QID MXID11000006521212357413143091999000000000206U3333300_579_S1 ;
+Qid MXID11000006521212357413143091999000000000206U3333300_579_S1
+Compile Start Time 2017/03/27 22:19:35.703280
+Compile End Time 2017/03/27 22:19:35.732216
+Compile Elapsed Time 0:00:00.028936
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -129,11 +129,11 @@ Last Suspend Time -1
Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_303_S1 ;
-Qid MXID11000027092212353966950645999000000000206U3333300_303_S1
-Compile Start Time 2017/02/16 01:02:45.193696
-Compile End Time 2017/02/16 01:02:45.225119
-Compile Elapsed Time 0:00:00.031423
+>>get statistics for QID MXID11000006521212357413143091999000000000206U3333300_579_S1 ;
+Qid MXID11000006521212357413143091999000000000206U3333300_579_S1
+Compile Start Time 2017/03/27 22:19:35.703280
+Compile End Time 2017/03/27 22:19:35.732216
+Compile Elapsed Time 0:00:00.028936
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -166,10 +166,10 @@ Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-Qid MXID11000027092212353966950645999000000000206U3333300_303_S1
-Compile Start Time 2017/02/16 01:02:45.193696
-Compile End Time 2017/02/16 01:02:45.225119
-Compile Elapsed Time 0:00:00.031423
+Qid MXID11000006521212357413143091999000000000206U3333300_579_S1
+Compile Start Time 2017/03/27 22:19:35.703280
+Compile End Time 2017/03/27 22:19:35.732216
+Compile Elapsed Time 0:00:00.028936
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -201,10 +201,10 @@ Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
>>get statistics for qid current ;
-Qid MXID11000027092212353966950645999000000000206U3333300_303_S1
-Compile Start Time 2017/02/16 01:02:45.193696
-Compile End Time 2017/02/16 01:02:45.225119
-Compile Elapsed Time 0:00:00.031423
+Qid MXID11000006521212357413143091999000000000206U3333300_579_S1
+Compile Start Time 2017/03/27 22:19:35.703280
+Compile End Time 2017/03/27 22:19:35.732216
+Compile Elapsed Time 0:00:00.028936
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -250,14 +250,14 @@ D
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_303_S1 ;
-Qid MXID11000027092212353966950645999000000000206U3333300_303_S1
-Compile Start Time 2017/02/16 01:02:45.193696
-Compile End Time 2017/02/16 01:02:45.225119
-Compile Elapsed Time 0:00:00.031423
-Execute Start Time 2017/02/16 01:02:48.212804
-Execute End Time 2017/02/16 01:02:51.350916
-Execute Elapsed Time 0:00:03.138112
+>>display statistics for QID MXID11000006521212357413143091999000000000206U3333300_579_S1 ;
+Qid MXID11000006521212357413143091999000000000206U3333300_579_S1
+Compile Start Time 2017/03/27 22:19:35.703280
+Compile End Time 2017/03/27 22:19:35.732216
+Compile Elapsed Time 0:00:00.028936
+Execute Start Time 2017/03/27 22:19:42.133178
+Execute End Time 2017/03/27 22:19:45.435236
+Execute Elapsed Time 0:00:03.302058
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -275,7 +275,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/02/16 01:02:51.349044
+First Row Returned Time 2017/03/27 22:19:45.433580
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -287,19 +287,20 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 708,700
-SQL Process Busy Time 4,139,515
+SE IO MAX Time 629,822
+SQL Process Busy Time 4,375,392
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 135 KB
-SQL Heap Used 16 KB
+SQL Heap Allocated 10,471 KB
+SQL Heap Used 80 KB
+SQL Heap WM 67 KB
Processes Created 2
-Process Create Time 120,844
+Process Create Time 150,199
Request Message Count 26
Request Message Bytes 39,392
-Reply Message Count 14
-Reply Message Bytes 32,184
+Reply Message Count 15
+Reply Message Bytes 38,760
Scr. Overflow Mode DISK
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -309,14 +310,14 @@ Scr. Read Count 0
Scr. Write Count 0
--- SQL operation complete.
->>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_303_S1 ;
-Qid MXID11000027092212353966950645999000000000206U3333300_303_S1
-Compile Start Time 2017/02/16 01:02:45.193696
-Compile End Time 2017/02/16 01:02:45.225119
-Compile Elapsed Time 0:00:00.031423
-Execute Start Time 2017/02/16 01:02:48.212804
-Execute End Time 2017/02/16 01:02:51.350916
-Execute Elapsed Time 0:00:03.138112
+>>get statistics for QID MXID11000006521212357413143091999000000000206U3333300_579_S1 ;
+Qid MXID11000006521212357413143091999000000000206U3333300_579_S1
+Compile Start Time 2017/03/27 22:19:35.703280
+Compile End Time 2017/03/27 22:19:35.732216
+Compile Elapsed Time 0:00:00.028936
+Execute Start Time 2017/03/27 22:19:42.133178
+Execute End Time 2017/03/27 22:19:45.435236
+Execute Elapsed Time 0:00:03.302058
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -334,7 +335,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/02/16 01:02:51.349044
+First Row Returned Time 2017/03/27 22:19:45.433580
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -346,19 +347,20 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 708,700
-SQL Process Busy Time 4,139,515
+SE IO MAX Time 629,822
+SQL Process Busy Time 4,375,392
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 135 KB
-SQL Heap Used 16 KB
+SQL Heap Allocated 10,471 KB
+SQL Heap Used 80 KB
+SQL Heap WM 67 KB
Processes Created 2
-Process Create Time 120,844
+Process Create Time 150,199
Request Message Count 26
Request Message Bytes 39,392
-Reply Message Count 14
-Reply Message Bytes 32,184
+Reply Message Count 15
+Reply Message Bytes 38,760
Scr. Overflow Mode DISK
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -370,13 +372,13 @@ Scr. Write Count 0
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-Qid MXID11000027092212353966950645999000000000206U3333300_303_S1
-Compile Start Time 2017/02/16 01:02:45.193696
-Compile End Time 2017/02/16 01:02:45.225119
-Compile Elapsed Time 0:00:00.031423
-Execute Start Time 2017/02/16 01:02:48.212804
-Execute End Time 2017/02/16 01:02:51.350916
-Execute Elapsed Time 0:00:03.138112
+Qid MXID11000006521212357413143091999000000000206U3333300_579_S1
+Compile Start Time 2017/03/27 22:19:35.703280
+Compile End Time 2017/03/27 22:19:35.732216
+Compile Elapsed Time 0:00:00.028936
+Execute Start Time 2017/03/27 22:19:42.133178
+Execute End Time 2017/03/27 22:19:45.435236
+Execute Elapsed Time 0:00:03.302058
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -394,7 +396,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/02/16 01:02:51.349044
+First Row Returned Time 2017/03/27 22:19:45.433580
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -406,19 +408,20 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 708,700
-SQL Process Busy Time 4,139,515
+SE IO MAX Time 629,822
+SQL Process Busy Time 4,375,392
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 135 KB
-SQL Heap Used 16 KB
+SQL Heap Allocated 10,471 KB
+SQL Heap Used 80 KB
+SQL Heap WM 67 KB
Processes Created 2
-Process Create Time 120,844
+Process Create Time 150,199
Request Message Count 26
Request Message Bytes 39,392
-Reply Message Count 14
-Reply Message Bytes 32,184
+Reply Message Count 15
+Reply Message Bytes 38,760
Scr. Overflow Mode DISK
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -429,13 +432,13 @@ Scr. Write Count 0
--- SQL operation complete.
>>get statistics for qid current ;
-Qid MXID11000027092212353966950645999000000000206U3333300_303_S1
-Compile Start Time 2017/02/16 01:02:45.193696
-Compile End Time 2017/02/16 01:02:45.225119
-Compile Elapsed Time 0:00:00.031423
-Execute Start Time 2017/02/16 01:02:48.212804
-Execute End Time 2017/02/16 01:02:51.350916
-Execute Elapsed Time 0:00:03.138112
+Qid MXID11000006521212357413143091999000000000206U3333300_579_S1
+Compile Start Time 2017/03/27 22:19:35.703280
+Compile End Time 2017/03/27 22:19:35.732216
+Compile Elapsed Time 0:00:00.028936
+Execute Start Time 2017/03/27 22:19:42.133178
+Execute End Time 2017/03/27 22:19:45.435236
+Execute Elapsed Time 0:00:03.302058
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -453,7 +456,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/02/16 01:02:51.349044
+First Row Returned Time 2017/03/27 22:19:45.433580
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -465,19 +468,20 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 708,700
-SQL Process Busy Time 4,139,515
+SE IO MAX Time 629,822
+SQL Process Busy Time 4,375,392
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 135 KB
-SQL Heap Used 16 KB
+SQL Heap Allocated 10,471 KB
+SQL Heap Used 80 KB
+SQL Heap WM 67 KB
Processes Created 2
-Process Create Time 120,844
+Process Create Time 150,199
Request Message Count 26
Request Message Bytes 39,392
-Reply Message Count 14
-Reply Message Bytes 32,184
+Reply Message Count 15
+Reply Message Bytes 38,760
Scr. Overflow Mode DISK
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -494,25 +498,25 @@ Scr. Write Count 0
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_303_S1 ;
+>>display statistics for QID MXID11000006521212357413143091999000000000206U3333300_579_S1 ;
-*** ERROR[8923] The given Query Id MXID11000027092212353966950645999000000000206U3333300_303_S1 is not found.
+*** ERROR[8923] The given Query Id MXID11000006521212357413143091999000000000206U3333300_579_S1 is not found.
--- SQL operation failed with errors.
->>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_303_S1 ;
+>>get statistics for QID MXID11000006521212357413143091999000000000206U3333300_579_S1 ;
-*** ERROR[8923] The given Query Id MXID11000027092212353966950645999000000000206U3333300_303_S1 is not found.
+*** ERROR[8923] The given Query Id MXID11000006521212357413143091999000000000206U3333300_579_S1 is not found.
--- SQL operation failed with errors.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_312_S1 ;
-Qid MXID11000027092212353966950645999000000000206U3333300_312_S1
-Compile Start Time 2017/02/16 01:02:54.344766
-Compile End Time 2017/02/16 01:02:54.345294
-Compile Elapsed Time 0:00:00.000528
+>>display statistics for QID MXID11000006521212357413143091999000000000206U3333300_588_S1 ;
+Qid MXID11000006521212357413143091999000000000206U3333300_588_S1
+Compile Start Time 2017/03/27 22:19:51.734901
+Compile End Time 2017/03/27 22:19:51.735427
+Compile Elapsed Time 0:00:00.000526
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -543,11 +547,11 @@ Last Suspend Time -1
Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_312_S1 ;
-Qid MXID11000027092212353966950645999000000000206U3333300_312_S1
-Compile Start Time 2017/02/16 01:02:54.344766
-Compile End Time 2017/02/16 01:02:54.345294
-Compile Elapsed Time 0:00:00.000528
+>>get statistics for QID MXID11000006521212357413143091999000000000206U3333300_588_S1 ;
+Qid MXID11000006521212357413143091999000000000206U3333300_588_S1
+Compile Start Time 2017/03/27 22:19:51.734901
+Compile End Time 2017/03/27 22:19:51.735427
+Compile Elapsed Time 0:00:00.000526
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -580,10 +584,10 @@ Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-Qid MXID11000027092212353966950645999000000000206U3333300_312_S1
-Compile Start Time 2017/02/16 01:02:54.344766
-Compile End Time 2017/02/16 01:02:54.345294
-Compile Elapsed Time 0:00:00.000528
+Qid MXID11000006521212357413143091999000000000206U3333300_588_S1
+Compile Start Time 2017/03/27 22:19:51.734901
+Compile End Time 2017/03/27 22:19:51.735427
+Compile Elapsed Time 0:00:00.000526
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -615,10 +619,10 @@ Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
>>get statistics for qid current ;
-Qid MXID11000027092212353966950645999000000000206U3333300_312_S1
-Compile Start Time 2017/02/16 01:02:54.344766
-Compile End Time 2017/02/16 01:02:54.345294
-Compile Elapsed Time 0:00:00.000528
+Qid MXID11000006521212357413143091999000000000206U3333300_588_S1
+Compile Start Time 2017/03/27 22:19:51.734901
+Compile End Time 2017/03/27 22:19:51.735427
+Compile Elapsed Time 0:00:00.000526
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -662,10 +666,10 @@ Stats Collection Type ACCUMULATED_STATS
--- SQL command prepared.
>>log;
>>get statistics for qid current ;
-Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
-Compile Start Time 2017/02/16 01:03:00.271828
-Compile End Time 2017/02/16 01:03:00.308827
-Compile Elapsed Time 0:00:00.036999
+Qid MXID11000006521212357413143091999000000000206U3333300_593_S1
+Compile Start Time 2017/03/27 22:19:58.421877
+Compile End Time 2017/03/27 22:19:58.458982
+Compile Elapsed Time 0:00:00.037105
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -700,11 +704,11 @@ Stats Collection Type PERTABLE_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_317_S1 ;
-Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
-Compile Start Time 2017/02/16 01:03:00.271828
-Compile End Time 2017/02/16 01:03:00.308827
-Compile Elapsed Time 0:00:00.036999
+>>display statistics for QID MXID11000006521212357413143091999000000000206U3333300_593_S1 ;
+Qid MXID11000006521212357413143091999000000000206U3333300_593_S1
+Compile Start Time 2017/03/27 22:19:58.421877
+Compile End Time 2017/03/27 22:19:58.458982
+Compile Elapsed Time 0:00:00.037105
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -735,11 +739,11 @@ Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_317_S1 ;
-Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
-Compile Start Time 2017/02/16 01:03:00.271828
-Compile End Time 2017/02/16 01:03:00.308827
-Compile Elapsed Time 0:00:00.036999
+>>get statistics for QID MXID11000006521212357413143091999000000000206U3333300_593_S1 ;
+Qid MXID11000006521212357413143091999000000000206U3333300_593_S1
+Compile Start Time 2017/03/27 22:19:58.421877
+Compile End Time 2017/03/27 22:19:58.458982
+Compile Elapsed Time 0:00:00.037105
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -774,11 +778,11 @@ Stats Collection Type PERTABLE_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_317_S1 ACCUMULATED;
-Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
-Compile Start Time 2017/02/16 01:03:00.271828
-Compile End Time 2017/02/16 01:03:00.308827
-Compile Elapsed Time 0:00:00.036999
+>>display statistics for QID MXID11000006521212357413143091999000000000206U3333300_593_S1 ACCUMULATED;
+Qid MXID11000006521212357413143091999000000000206U3333300_593_S1
+Compile Start Time 2017/03/27 22:19:58.421877
+Compile End Time 2017/03/27 22:19:58.458982
+Compile Elapsed Time 0:00:00.037105
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -809,11 +813,11 @@ Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_317_S1 ACCUMULATED;
-Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
-Compile Start Time 2017/02/16 01:03:00.271828
-Compile End Time 2017/02/16 01:03:00.308827
-Compile Elapsed Time 0:00:00.036999
+>>get statistics for QID MXID11000006521212357413143091999000000000206U3333300_593_S1 ACCUMULATED;
+Qid MXID11000006521212357413143091999000000000206U3333300_593_S1
+Compile Start Time 2017/03/27 22:19:58.421877
+Compile End Time 2017/03/27 22:19:58.458982
+Compile Elapsed Time 0:00:00.037105
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -846,10 +850,10 @@ Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
-Compile Start Time 2017/02/16 01:03:00.271828
-Compile End Time 2017/02/16 01:03:00.308827
-Compile Elapsed Time 0:00:00.036999
+Qid MXID11000006521212357413143091999000000000206U3333300_593_S1
+Compile Start Time 2017/03/27 22:19:58.421877
+Compile End Time 2017/03/27 22:19:58.458982
+Compile Elapsed Time 0:00:00.037105
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -881,10 +885,10 @@ Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
>>get statistics for qid current ;
-Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
-Compile Start Time 2017/02/16 01:03:00.271828
-Compile End Time 2017/02/16 01:03:00.308827
-Compile Elapsed Time 0:00:00.036999
+Qid MXID11000006521212357413143091999000000000206U3333300_593_S1
+Compile Start Time 2017/03/27 22:19:58.421877
+Compile End Time 2017/03/27 22:19:58.458982
+Compile Elapsed Time 0:00:00.037105
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -916,10 +920,10 @@ Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
>>display statistics for qid current accumulated ;
-Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
-Compile Start Time 2017/02/16 01:03:00.271828
-Compile End Time 2017/02/16 01:03:00.308827
-Compile Elapsed Time 0:00:00.036999
+Qid MXID11000006521212357413143091999000000000206U3333300_593_S1
+Compile Start Time 2017/03/27 22:19:58.421877
+Compile End Time 2017/03/27 22:19:58.458982
+Compile Elapsed Time 0:00:00.037105
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -951,10 +955,10 @@ Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
>>get statistics for qid current accumulated ;
-Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
-Compile Start Time 2017/02/16 01:03:00.271828
-Compile End Time 2017/02/16 01:03:00.308827
-Compile Elapsed Time 0:00:00.036999
+Qid MXID11000006521212357413143091999000000000206U3333300_593_S1
+Compile Start Time 2017/03/27 22:19:58.421877
+Compile End Time 2017/03/27 22:19:58.458982
+Compile Elapsed Time 0:00:00.037105
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1000,14 +1004,14 @@ D
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_317_S1 ;
-Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
-Compile Start Time 2017/02/16 01:03:00.271828
-Compile End Time 2017/02/16 01:03:00.308827
-Compile Elapsed Time 0:00:00.036999
-Execute Start Time 2017/02/16 01:03:06.512541
-Execute End Time 2017/02/16 01:03:06.522982
-Execute Elapsed Time 0:00:00.010441
+>>display statistics for QID MXID11000006521212357413143091999000000000206U3333300_593_S1 ;
+Qid MXID11000006521212357413143091999000000000206U3333300_593_S1
+Compile Start Time 2017/03/27 22:19:58.421877
+Compile End Time 2017/03/27 22:19:58.458982
+Compile Elapsed Time 0:00:00.037105
+Execute Start Time 2017/03/27 22:20:08.312378
+Execute End Time 2017/03/27 22:20:08.325384
+Execute Elapsed Time 0:00:00.013006
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1025,7 +1029,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/02/16 01:03:06.521253
+First Row Returned Time 2017/03/27 22:20:08.321228
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1033,20 +1037,21 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
-SQL Process Busy Time 6,176
+SQL Process Busy Time 5,901
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 135 KB
-SQL Heap Used 14 KB
+SQL Heap Allocated 200 KB
+SQL Heap Used 78 KB
+SQL Heap WM 10,338 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
Request Message Bytes 39,552
-Reply Message Count 14
-Reply Message Bytes 32,568
+Reply Message Count 15
+Reply Message Bytes 39,144
Scr. Overflow Mode UNKNOWN
-Scr File Count 0
+Scr. File Count 0
Scr. Buffer Blk Size 0
Scr. Buffer Blks Read 0
Scr. Buffer Blks Written 0
@@ -1054,22 +1059,22 @@ Scr. Read Count 0
Scr. Write Count 0
Sort TopN -1
-Table Name
+ ID DOP Table Name
Records Accessed Records Used HBase/Hive HBase/Hive HBase/Hive IO HBase/Hive IO
Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time
-TRAFODION.SCH.TSTAT
+ 1 6 TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 4,755 2,404
+ 4 4 4 0 4,678 2,488
--- SQL operation complete.
->>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_317_S1 ;
-Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
-Compile Start Time 2017/02/16 01:03:00.271828
-Compile End Time 2017/02/16 01:03:00.308827
-Compile Elapsed Time 0:00:00.036999
-Execute Start Time 2017/02/16 01:03:06.512541
-Execute End Time 2017/02/16 01:03:06.522982
-Execute Elapsed Time 0:00:00.010441
+>>get statistics for QID MXID11000006521212357413143091999000000000206U3333300_593_S1 ;
+Qid MXID11000006521212357413143091999000000000206U3333300_593_S1
+Compile Start Time 2017/03/27 22:19:58.421877
+Compile End Time 2017/03/27 22:19:58.458982
+Compile Elapsed Time 0:00:00.037105
+Execute Start Time 2017/03/27 22:20:08.312378
+Execute End Time 2017/03/27 22:20:08.325384
+Execute Elapsed Time 0:00:00.013006
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1087,7 +1092,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/02/16 01:03:06.521253
+First Row Returned Time 2017/03/27 22:20:08.321228
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1095,20 +1100,21 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
-SQL Process Busy Time 6,176
+SQL Process Busy Time 5,901
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 135 KB
-SQL Heap Used 14 KB
+SQL Heap Allocated 200 KB
+SQL Heap Used 78 KB
+SQL Heap WM 10,338 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
Request Message Bytes 39,552
-Reply Message Count 14
-Reply Message Bytes 32,568
+Reply Message Count 15
+Reply Message Bytes 39,144
Scr. Overflow Mode UNKNOWN
-Scr File Count 0
+Scr. File Count 0
Scr. Buffer Blk Size 0
Scr. Buffer Blks Read 0
Scr. Buffer Blks Written 0
@@ -1116,26 +1122,26 @@ Scr. Read Count 0
Scr. Write Count 0
Sort TopN -1
-Table Name
+ ID DOP Table Name
Records Accessed Records Used HBase/Hive HBase/Hive HBase/Hive IO HBase/Hive IO
Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time
-TRAFODION.SCH.TSTAT
+ 1 6 TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 4,755 2,404
+ 4 4 4 0 4,678 2,488
--- SQL operation complete.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_317_S1 ACCUMULATED;
-Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
-Compile Start Time 2017/02/16 01:03:00.271828
-Compile End Time 2017/02/16 01:03:00.308827
-Compile Elapsed Time 0:00:00.036999
-Execute Start Time 2017/02/16 01:03:06.512541
-Execute End Time 2017/02/16 01:03:06.522982
-Execute Elapsed Time 0:00:00.010441
+>>display statistics for QID MXID11000006521212357413143091999000000000206U3333300_593_S1 ACCUMULATED;
+Qid MXID11000006521212357413143091999000000000206U3333300_593_S1
+Compile Start Time 2017/03/27 22:19:58.421877
+Compile End Time 2017/03/27 22:19:58.458982
+Compile Elapsed Time 0:00:00.037105
+Execute Start Time 2017/03/27 22:20:08.312378
+Execute End Time 2017/03/27 22:20:08.325384
+Execute Elapsed Time 0:00:00.013006
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1153,7 +1159,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/02/16 01:03:06.521253
+First Row Returned Time 2017/03/27 22:20:08.321228
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1165,19 +1171,20 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 2,404
-SQL Process Busy Time 6,176
+SE IO MAX Time 2,488
+SQL Process Busy Time 5,901
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 135 KB
-SQL Heap Used 14 KB
+SQL Heap Allocated 200 KB
+SQL Heap Used 78 KB
+SQL Heap WM 10,338 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
Request Message Bytes 39,552
-Reply Message Count 14
-Reply Message Bytes 32,568
+Reply Message Count 15
+Reply Message Bytes 39,144
Scr. Overflow Mode UNKNOWN
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -1187,14 +1194,14 @@ Scr. Read Count 0
Scr. Write Count 0
--- SQL operation complete.
->>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_317_S1 ACCUMULATED;
-Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
-Compile Start Time 2017/02/16 01:03:00.271828
-Compile End Time 2017/02/16 01:03:00.308827
-Compile Elapsed Time 0:00:00.036999
-Execute Start Time 2017/02/16 01:03:06.512541
-Execute End Time 2017/02/16 01:03:06.522982
-Execute Elapsed Time 0:00:00.010441
+>>get statistics for QID MXID11000006521212357413143091999000000000206U3333300_593_S1 ACCUMULATED;
+Qid MXID11000006521212357413143091999000000000206U3333300_593_S1
+Compile Start Time 2017/03/27 22:19:58.421877
+Compile End Time 2017/03/27 22:19:58.458982
+Compile Elapsed Time 0:00:00.037105
+Execute Start Time 2017/03/27 22:20:08.312378
+Execute End Time 2017/03/27 22:20:08.325384
+Execute Elapsed Time 0:00:00.013006
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1212,7 +1219,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/02/16 01:03:06.521253
+First Row Returned Time 2017/03/27 22:20:08.321228
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1224,19 +1231,20 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 2,404
-SQL Process Busy Time 6,176
+SE IO MAX Time 2,488
+SQL Process Busy Time 5,901
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 135 KB
-SQL Heap Used 14 KB
+SQL Heap Allocated 200 KB
+SQL Heap Used 78 KB
+SQL Heap WM 10,338 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
Request Message Bytes 39,552
-Reply Message Count 14
-Reply Message Bytes 32,568
+Reply Message Count 15
+Reply Message Bytes 39,144
Scr. Overflow Mode UNKNOWN
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -1248,13 +1256,13 @@ Scr. Write Count 0
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
-Compile Start Time 2017/02/16 01:03:00.271828
-Compile End Time 2017/02/16 01:03:00.308827
-Compile Elapsed Time 0:00:00.036999
-Execute Start Time 2017/02/16 01:03:06.512541
-Execute End Time 2017/02/16 01:03:06.522982
-Execute Elapsed Time 0:00:00.010441
+Qid MXID11000006521212357413143091999000000000206U3333300_593_S1
+Compile Start Time 2017/03/27 22:19:58.421877
+Compile End Time 2017/03/27 22:19:58.458982
+Compile Elapsed Time 0:00:00.037105
+Execute Start Time 2017/03/27 22:20:08.312378
+Execute End Time 2017/03/27 22:20:08.325384
+Execute Elapsed Time 0:00:00.013006
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1272,7 +1280,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/02/16 01:03:06.521253
+First Row Returned Time 2017/03/27 22:20:08.321228
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1280,20 +1288,21 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
-SQL Process Busy Time 6,176
+SQL Process Busy Time 5,901
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 135 KB
-SQL Heap Used 14 KB
+SQL Heap Allocated 200 KB
+SQL Heap Used 78 KB
+SQL Heap WM 10,338 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
Request Message Bytes 39,552
-Reply Message Count 14
-Reply Message Bytes 32,568
+Reply Message Count 15
+Reply Message Bytes 39,144
Scr. Overflow Mode UNKNOWN
-Scr File Count 0
+Scr. File Count 0
Scr. Buffer Blk Size 0
Scr. Buffer Blks Read 0
Scr. Buffer Blks Written 0
@@ -1301,22 +1310,22 @@ Scr. Read Count 0
Scr. Write Count 0
Sort TopN -1
-Table Name
+ ID DOP Table Name
Records Accessed Records Used HBase/Hive HBase/Hive HBase/Hive IO HBase/Hive IO
Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time
-TRAFODION.SCH.TSTAT
+ 1 2 TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 4,755 2,404
+ 4 4 4 0 4,678 2,488
--- SQL operation complete.
>>get statistics for qid current ;
-Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
-Compile Start Time 2017/02/16 01:03:00.271828
-Compile End Time 2017/02/16 01:03:00.308827
-Compile Elapsed Time 0:00:00.036999
-Execute Start Time 2017/02/16 01:03:06.512541
-Execute End Time 2017/02/16 01:03:06.522982
-Execute Elapsed Time 0:00:00.010441
+Qid MXID11000006521212357413143091999000000000206U3333300_593_S1
+Compile Start Time 2017/03/27 22:19:58.421877
+Compile End Time 2017/03/27 22:19:58.458982
+Compile Elapsed Time 0:00:00.037105
+Execute Start Time 2017/03/27 22:20:08.312378
+Execute End Time 2017/03/27 22:20:08.325384
+Execute Elapsed Time 0:00:00.013006
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1334,7 +1343,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/02/16 01:03:06.521253
+First Row Returned Time 2017/03/27 22:20:08.321228
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1342,20 +1351,21 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
-SQL Process Busy Time 6,176
+SQL Process Busy Time 5,901
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 135 KB
-SQL Heap Used 14 KB
+SQL Heap Allocated 200 KB
+SQL Heap Used 78 KB
+SQL Heap WM 10,338 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
Request Message Bytes 39,552
-Reply Message Count 14
-Reply Message Bytes 32,568
+Reply Message Count 15
+Reply Message Bytes 39,144
Scr. Overflow Mode UNKNOWN
-Scr File Count 0
+Scr. File Count 0
Scr. Buffer Blk Size 0
Scr. Buffer Blks Read 0
Scr. Buffer Blks Written 0
@@ -1363,22 +1373,22 @@ Scr. Read Count 0
Scr. Write Count 0
Sort TopN -1
-Table Name
+ ID DOP Table Name
Records Accessed Records Used HBase/Hive HBase/Hive HBase/Hive IO HBase/Hive IO
Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time
-TRAFODION.SCH.TSTAT
+ 1 2 TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 4,755 2,404
+ 4 4 4 0 4,678 2,488
--- SQL operation complete.
>>display statistics for qid current accumulated;
-Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
-Compile Start Time 2017/02/16 01:03:00.271828
-Compile End Time 2017/02/16 01:03:00.308827
-Compile Elapsed Time 0:00:00.036999
-Execute Start Time 2017/02/16 01:03:06.512541
-Execute End Time 2017/02/16 01:03:06.522982
-Execute Elapsed Time 0:00:00.010441
+Qid MXID11000006521212357413143091999000000000206U3333300_593_S1
+Compile Start Time 2017/03/27 22:19:58.421877
+Compile End Time 2017/03/27 22:19:58.458982
+Compile Elapsed Time 0:00:00.037105
+Execute Start Time 2017/03/27 22:20:08.312378
+Execute End Time 2017/03/27 22:20:08.325384
+Execute Elapsed Time 0:00:00.013006
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1396,7 +1406,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/02/16 01:03:06.521253
+First Row Returned Time 2017/03/27 22:20:08.321228
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1408,19 +1418,20 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 2,404
-SQL Process Busy Time 6,176
+SE IO MAX Time 2,488
+SQL Process Busy Time 5,901
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 135 KB
-SQL Heap Used 14 KB
+SQL Heap Allocated 200 KB
+SQL Heap Used 78 KB
+SQL Heap WM 10,338 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
Request Message Bytes 39,552
-Reply Message Count 14
-Reply Message Bytes 32,568
+Reply Message Count 15
+Reply Message Bytes 39,144
Scr. Overflow Mode UNKNOWN
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -1431,13 +1442,13 @@ Scr. Write Count 0
--- SQL operation complete.
>>get statistics for qid current accumulated;
-Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
-Compile Start Time 2017/02/16 01:03:00.271828
-Compile End Time 2017/02/16 01:03:00.308827
-Compile Elapsed Time 0:00:00.036999
-Execute Start Time 2017/02/16 01:03:06.512541
-Execute End Time 2017/02/16 01:03:06.522982
-Execute Elapsed Time 0:00:00.010441
+Qid MXID11000006521212357413143091999000000000206U3333300_593_S1
+Compile Start Time 2017/03/27 22:19:58.421877
+Compile End Time 2017/03/27 22:19:58.458982
+Compile Elapsed Time 0:00:00.037105
+Execute Start Time 2017/03/27 22:20:08.312378
+Execute End Time 2017/03/27 22:20:08.325384
+Execute Elapsed Time 0:00:00.013006
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1455,7 +1466,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/02/16 01:03:06.521253
+First Row Returned Time 2017/03/27 22:20:08.321228
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1467,19 +1478,20 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 2,404
-SQL Process Busy Time 6,176
+SE IO MAX Time 2,488
+SQL Process Busy Time 5,901
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 135 KB
-SQL Heap Used 14 KB
+SQL Heap Allocated 200 KB
+SQL Heap Used 78 KB
+SQL Heap WM 10,338 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
Request Message Bytes 39,552
-Reply Message Count 14
-Reply Message Bytes 32,568
+Reply Message Count 15
+Reply Message Bytes 39,144
Scr. Overflow Mode UNKNOWN
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -1491,7 +1503,7 @@ Scr. Write Count 0
--- SQL operation complete.
>>log;
>>obey PQIDOUT;
->>SET SESSION DEFAULT PARENT_QID 'MXID11000027092212353966950645999000000000206U3333300_317_S1';
+>>SET SESSION DEFAULT PARENT_QID 'MXID11000006521212357413143091999000000000206U3333300_593_S1';
--- SQL operation complete.
>>prepare s1 from select distinct d from tstat ;
@@ -1501,11 +1513,11 @@ Scr. Write Count 0
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_331_S1 ;
-Qid MXID11000027092212353966950645999000000000206U3333300_331_S1
-Compile Start Time 2017/02/16 01:03:16.005126
-Compile End Time 2017/02/16 01:03:16.005736
-Compile Elapsed Time 0:00:00.000610
+>>display statistics for QID MXID11000006521212357413143091999000000000206U3333300_607_S1 ;
+Qid MXID11000006521212357413143091999000000000206U3333300_607_S1
+Compile Start Time 2017/03/27 22:20:15.172278
+Compile End Time 2017/03/27 22:20:15.172724
+Compile Elapsed Time 0:00:00.000446
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1517,7 +1529,7 @@ Query Type SQL_SELECT_NON_UNIQUE
Sub Query Type SQL_STMT_NA
Estimated Accessed Rows 0
Estimated Used Rows 0
-Parent Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
+Parent Qid MXID11000006521212357413143091999000000000206U3333300_593_S1
Parent Query System SAME
Child Qid NONE
Number of SQL Processes 1
@@ -1536,11 +1548,11 @@ Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_331_S1 ;
-Qid MXID11000027092212353966950645999000000000206U3333300_331_S1
-Compile Start Time 2017/02/16 01:03:16.005126
-Compile End Time 2017/02/16 01:03:16.005736
-Compile Elapsed Time 0:00:00.000610
+>>get statistics for QID MXID11000006521212357413143091999000000000206U3333300_607_S1 ;
+Qid MXID11000006521212357413143091999000000000206U3333300_607_S1
+Compile Start Time 2017/03/27 22:20:15.172278
+Compile End Time 2017/03/27 22:20:15.172724
+Compile Elapsed Time 0:00:00.000446
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1552,7 +1564,7 @@ Query Type SQL_SELECT_NON_UNIQUE
Sub Query Type SQL_STMT_NA
Estimated Accessed Rows 0
Estimated Used Rows 0
-Parent Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
+Parent Qid MXID11000006521212357413143091999000000000206U3333300_593_S1
Parent Query System SAME
Child Qid NONE
Number of SQL Processes 1
@@ -1582,11 +1594,11 @@ Stats Collection Type PERTABLE_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_333_S1 ;
-Qid MXID11000027092212353966950645999000000000206U3333300_333_S1
-Compile Start Time 2017/02/16 01:03:19.022446
-Compile End Time 2017/02/16 01:03:19.022986
-Compile Elapsed Time 0:00:00.000540
+>>display statistics for QID MXID11000006521212357413143091999000000000206U3333300_609_S1 ;
+Qid MXID11000006521212357413143091999000000000206U3333300_609_S1
+Compile Start Time 2017/03/27 22:20:18.505298
+Compile End Time 2017/03/27 22:20:18.505902
+Compile Elapsed Time 0:00:00.000604
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1617,11 +1629,11 @@ Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_333_S1 ;
-Qid MXID11000027092212353966950645999000000000206U3333300_333_S1
-Compile Start Time 2017/02/16 01:03:19.022446
-Compile End Time 2017/02/16 01:03:19.022986
-Compile Elapsed Time 0:00:00.000540
+>>get statistics for QID MXID11000006521212357413143091999000000000206U3333300_609_S1 ;
+Qid MXID11000006521212357413143091999000000000206U3333300_609_S1
+Compile Start Time 2017/03/27 22:20:18.505298
+Compile End Time 2017/03/27 22:20:18.505902
+Compile Elapsed Time 0:00:00.000604
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1668,11 +1680,11 @@ Stats Collection Type PERTABLE_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_336_S1 ;
-Qid MXID11000027092212353966950645999000000000206U3333300_336_S1
-Compile Start Time 2017/02/16 01:03:25.061984
-Compile End Time 2017/02/16 01:03:25.102150
-Compile Elapsed Time 0:00:00.040166
+>>display statistics for QID MXID11000006521212357413143091999000000000206U3333300_612_S1 ;
+Qid MXID11000006521212357413143091999000000000206U3333300_612_S1
+Compile Start Time 2017/03/27 22:20:21.762150
+Compile End Time 2017/03/27 22:20:21.795421
+Compile Elapsed Time 0:00:00.033271
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1703,11 +1715,11 @@ Last Suspend Time -1
Stats Collection Type OPERATOR_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_336_S1 ;
-Qid MXID11000027092212353966950645999000000000206U3333300_336_S1
-Compile Start Time 2017/02/16 01:03:25.061984
-Compile End Time 2017/02/16 01:03:25.102150
-Compile Elapsed Time 0:00:00.040166
+>>get statistics for QID MXID11000006521212357413143091999000000000206U3333300_612_S1 ;
+Qid MXID11000006521212357413143091999000000000206U3333300_612_S1
+Compile Start Time 2017/03/27 22:20:21.762150
+Compile End Time 2017/03/27 22:20:21.795421
+Compile Elapsed Time 0:00:00.033271
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1754,14 +1766,14 @@ D
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_336_S1 ;
-Qid MXID11000027092212353966950645999000000000206U3333300_336_S1
-Compile Start Time 2017/02/16 01:03:25.061984
-Compile End Time 2017/02/16 01:03:25.102150
-Compile Elapsed Time 0:00:00.040166
-Execute Start Time 2017/02/16 01:03:28.196863
-Execute End Time 2017/02/16 01:03:28.208332
-Execute Elapsed Time 0:00:00.011469
+>>display statistics for QID MXID11000006521212357413143091999000000000206U3333300_612_S1 ;
+Qid MXID11000006521212357413143091999000000000206U3333300_612_S1
+Compile Start Time 2017/03/27 22:20:21.762150
+Compile End Time 2017/03/27 22:20:21.795421
+Compile Elapsed Time 0:00:00.033271
+Execute Start Time 2017/03/27 22:20:25.191770
+Execute End Time 2017/03/27 22:20:25.204461
+Execute Elapsed Time 0:00:00.012691
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1779,7 +1791,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/02/16 01:03:28.206366
+First Row Returned Time 2017/03/27 22:20:25.202687
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1790,27 +1802,27 @@ Stats Collection Type OPERATOR_STATS
LC RC Id PaId ExId Frag TDB Name DOP Dispatches Oper CPU Time Est. Records Used Act. Records Used Details
-10 . 11 . 5 0 EX_ROOT 1 5 17 0 4 1049
-9 . 10 11 4 0 EX_SPLIT_TOP 1 5 7 2 4
-8 . 9 10 4 0 EX_SEND_TOP 2 10 1,025 2 4
-7 . 8 9 4 2 EX_SEND_BOTTOM 2 21 77 2 4
-6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 7 2 4 3223
-5 . 6 7 3 2 EX_HASH_GRBY 2 6 2,559 1 4 0|0|0
-4 . 5 6 2 2 EX_SPLIT_TOP 2 11 8 100 4
-3 . 4 5 2 2 EX_SEND_TOP 4 18 572 100 4
-2 . 3 4 2 3 EX_SEND_BOTTOM 4 35 136 100 4
-1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 11 100 4 1377
-. . 1 2 1 3 EX_TRAF_KEY_SELECT 6 12 3,690 100 4 TRAFODION.SCH.TSTAT|4|176
-
---- SQL operation complete.
->>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_336_S1 ;
-Qid MXID11000027092212353966950645999000000000206U3333300_336_S1
-Compile Start Time 2017/02/16 01:03:25.061984
-Compile End Time 2017/02/16 01:03:25.102150
-Compile Elapsed Time 0:00:00.040166
-Execute Start Time 2017/02/16 01:03:28.196863
-Execute End Time 2017/02/16 01:03:28.208332
-Execute Elapsed Time 0:00:00.011469
+10 . 11 . 5 0 EX_ROOT 1 5 10 0 4 1211
+9 . 10 11 4 0 EX_SPLIT_TOP 1 5 8 2 4
+8 . 9 10 4 0 EX_SEND_TOP 2 10 1,193 2 4
+7 . 8 9 4 2 EX_SEND_BOTTOM 2 17 142 2 4
+6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 9 2 4 3732
+5 . 6 7 3 2 EX_HASH_GRBY 2 6 2,725 1 4 0|0|0
+4 . 5 6 2 2 EX_SPLIT_TOP 2 9 13 100 4
+3 . 4 5 2 2 EX_SEND_TOP 4 18 843 100 4
+2 . 3 4 2 3 EX_SEND_BOTTOM 4 22 286 100 4
+1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 22 100 4 2126
+. . 1 2 1 3 EX_TRAF_KEY_SELECT 6 12 5,454 100 4 TRAFODION.SCH.TSTAT|4|176
+
+--- SQL operation complete.
+>>get statistics for QID MXID11000006521212357413143091999000000000206U3333300_612_S1 ;
+Qid MXID11000006521212357413143091999000000000206U3333300_612_S1
+Compile Start Time 2017/03/27 22:20:21.762150
+Compile End Time 2017/03/27 22:20:21.795421
+Compile Elapsed Time 0:00:00.033271
+Execute Start Time 2017/03/27 22:20:25.191770
+Execute End Time 2017/03/27 22:20:25.204461
+Execute Elapsed Time 0:00:00.012691
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1828,7 +1840,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/02/16 01:03:28.206366
+First Row Returned Time 2017/03/27 22:20:25.202687
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1839,31 +1851,31 @@ Stats Collection Type OPERATOR_STATS
LC RC Id PaId ExId Frag TDB Name DOP Dispatches Oper CPU Time Est. Records Used Act. Records Used Details
-10 . 11 . 5 0 EX_ROOT 1 5 17 0 4 1049
-9 . 10 11 4 0 EX_SPLIT_TOP 1 5 7 2 4
-8 . 9 10 4 0 EX_SEND_TOP 2 10 1,025 2 4
-7 . 8 9 4 2 EX_SEND_BOTTOM 2 21 77 2 4
-6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 7 2 4 3223
-5 . 6 7 3 2 EX_HASH_GRBY 2 6 2,559 1 4 0|0|0
-4 . 5 6 2 2 EX_SPLIT_TOP 2 11 8 100 4
-3 . 4 5 2 2 EX_SEND_TOP 4 18 572 100 4
-2 . 3 4 2 3 EX_SEND_BOTTOM 4 35 136 100 4
-1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 11 100 4 1377
-. . 1 2 1 3 EX_TRAF_KEY_SELECT 6 12 3,690 100 4 TRAFODION.SCH.TSTAT|4|176
+10 . 11 . 5 0 EX_ROOT 1 5 10 0 4 1211
+9 . 10 11 4 0 EX_SPLIT_TOP 1 5 8 2 4
+8 . 9 10 4 0 EX_SEND_TOP 2 10 1,193 2 4
+7 . 8 9 4 2 EX_SEND_BOTTOM 2 17 142 2 4
+6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 9 2 4 3732
+5 . 6 7 3 2 EX_HASH_GRBY 2 6 2,725 1 4 0|0|0
+4 . 5 6 2 2 EX_SPLIT_TOP 2 9 13 100 4
+3 . 4 5 2 2 EX_SEND_TOP 4 18 843 100 4
+2 . 3 4 2 3 EX_SEND_BOTTOM 4 22 286 100 4
+1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 22 100 4 2126
+. . 1 2 1 3 EX_TRAF_KEY_SELECT 6 12 5,454 100 4 TRAFODION.SCH.TSTAT|4|176
--- SQL operation complete.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_336_S1 ACCUMULATED;
-Qid MXID11000027092212353966950645999000000000206U3333300_336_S1
-Compile Start Time 2017/02/16 01:03:25.061984
-Compile End Time 2017/02/16 01:03:25.102150
-Compile Elapsed Time 0:00:00.040166
-Execute Start Time 2017/02/16 01:03:28.196863
-Execute End Time 2017/02/16 01:03:28.208332
-Execute Elapsed Time 0:00:00.011469
+>>display statistics for QID MXID11000006521212357413143091999000000000206U3333300_612_S1 ACCUMULATED;
+Qid MXID11000006521212357413143091999000000000206U3333300_612_S1
+Compile Start Time 2017/03/27 22:20:21.762150
+Compile End Time 2017/03/27 22:20:21.795421
+Compile Elapsed Time 0:00:00.033271
+Execute Start Time 2017/03/27 22:20:25.191770
+Execute End Time 2017/03/27 22:20:25.204461
+Execute Elapsed Time 0:00:00.012691
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1881,7 +1893,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/02/16 01:03:28.206366
+First Row Returned Time 2017/03/27 22:20:25.202687
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1893,19 +1905,20 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 2,387
-SQL Process Busy Time 5,649
+SE IO MAX Time 3,310
+SQL Process Busy Time 7,069
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 135 KB
-SQL Heap Used 14 KB
+SQL Heap Allocated 200 KB
+SQL Heap Used 78 KB
+SQL Heap WM 10,341 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
Request Message Bytes 39,712
Reply Message Count 15
-Reply Message Bytes 42,256
+Reply Message Bytes 42,416
Scr. Overflow Mode DISK
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -1915,14 +1928,14 @@ Scr. Read Count 0
Scr. Write Count 0
--- SQL operation complete.
->>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_336_S1 ACCUMULATED;
-Qid MXID11000027092212353966950645999000000000206U3333300_336_S1
-Compile Start Time 2017/02/16 01:03:25.061984
-Compile End Time 2017/02/16 01:03:25.102150
-Compile Elapsed Time 0:00:00.040166
-Execute Start Time 2017/02/16 01:03:28.196863
-Execute End Time 2017/02/16 01:03:28.208332
-Execute Elapsed Time 0:00:00.011469
+>>get statistics for QID MXID11000006521212357413143091999000000000206U3333300_612_S1 ACCUMULATED;
+Qid MXID11000006521212357413143091999000000000206U3333300_612_S1
+Compile Start Time 2017/03/27 22:20:21.762150
+Compile End Time 2017/03/27 22:20:21.795421
+Compile Elapsed Time 0:00:00.033271
+Execute Start Time 2017/03/27 22:20:25.191770
+Execute End Time 2017/03/27 22:20:25.204461
+Execute Elapsed Time 0:00:00.012691
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1940,7 +1953,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/02/16 01:03:28.206366
+First Row Returned Time 2017/03/27 22:20:25.202687
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1952,19 +1965,20 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 2,387
-SQL Process Busy Time 5,649
+SE IO MAX Time 3,310
+SQL Process Busy Time 7,069
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 135 KB
-SQL Heap Used 14 KB
+SQL Heap Allocated 200 KB
+SQL Heap Used 78 KB
+SQL Heap WM 10,341 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
Request Message Bytes 39,712
Reply Message Count 15
-Reply Message Bytes 42,256
+Reply Message Bytes 42,416
Scr. Overflow Mode DISK
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -1978,14 +1992,14 @@ Scr. Write Count 0
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_336_S1 PERTABLE;
-Qid MXID11000027092212353966950645999000000000206U3333300_336_S1
-Compile Start Time 2017/02/16 01:03:25.061984
-Compile End Time 2017/02/16 01:03:25.102150
-Compile Elapsed Time 0:00:00.040166
-Execute Start Time 2017/02/16 01:03:28.196863
-Execute End Time 2017/02/16 01:03:28.208332
-Execute Elapsed Time 0:00:00.011469
+>>display statistics for QID MXID11000006521212357413143091999000000000206U3333300_612_S1 PERTABLE;
+Qid MXID11000006521212357413143091999000000000206U3333300_612_S1
+Compile Start Time 2017/03/27 22:20:21.762150
+Compile End Time 2017/03/27 22:20:21.795421
+Compile Elapsed Time 0:00:00.033271
+Execute Start Time 2017/03/27 22:20:25.191770
+Execute End Time 2017/03/27 22:20:25.204461
+Execute Elapsed Time 0:00:00.012691
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -2003,7 +2017,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/02/16 01:03:28.206366
+First Row Returned Time 2017/03/27 22:20:25.202687
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -2011,20 +2025,21 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type OPERATOR_STATS
-SQL Process Busy Time 5,649
+SQL Process Busy Time 7,069
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 135 KB
-SQL Heap Used 14 KB
+SQL Heap Allocated 200 KB
+SQL Heap Used 78 KB
+SQL Heap WM 10,341 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
Request Message Bytes 39,712
Reply Message Count 15
-Reply Message Bytes 42,256
+Reply Message Bytes 42,416
Scr. Overflow Mode DISK
-Scr File Count 0
+Scr. File Count 0
Scr. Buffer Blk Size 0
Scr. Buffer Blks Read 0
Scr. Buffer Blks Written 0
@@ -2032,22 +2047,22 @@ Scr. Read Count 0
Scr. Write Count 0
Sort TopN -1
-Table Name
+ ID DOP Table Name
Records Accessed Records Used HBase/Hive HBase/Hive HBase/Hive IO HBase/Hive IO
Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time
-TRAFODION.SCH.TSTAT
+ 1 6 TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 4,503 2,387
+ 4 4 4 0 6,523 3,310
--- SQL operation complete.
->>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_336_S1 PERTABLE;
-Qid MXID11000027092212353966950645999000000000206U3333300_336_S1
-Compile Start Time 2017/02/16 01:03:25.061984
-Compile End Time 2017/02/16 01:03:25.102150
-Compile Elapsed Time 0:00:00.040166
-Execute Start Time 2017/02/16 01:03:28.196863
-Execute End Time 2017/02/16 01:03:28.208332
-Execute Elapsed Time 0:00:00.011469
+>>get statistics for QID MXID11000006521212357413143091999000000000206U3333300_612_S1 PERTABLE;
+Qid MXID11000006521212357413143091999000000000206U3333300_612_S1
+Compile Start Time 2017/03/27 22:20:21.762150
+Compile End Time 2017/03/27 22:20:21.795421
+Compile Elapsed Time 0:00:00.033271
+Execute Start Time 2017/03/27 22:20:25.191770
+Execute End Time 2017/03/27 22:20:25.204461
+Execute Elapsed Time 0:00:00.012691
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -2065,7 +2080,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/02/16 01:03:28.206366
+First Row Returned Time 2017/03/27 22:20:25.202687
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -2073,20 +2088,21 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type OPERATOR_STATS
-SQL Process Busy Time 5,649
+SQL Process Busy Time 7,069
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 135 KB
-SQL Heap Used 14 KB
+SQL Heap Allocated 200 KB
+SQL Heap Used 78 KB
+SQL Heap WM 10,341 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
Request Message Bytes 39,712
Reply Message Count 15
-Reply Message Bytes 42,256
+Reply Message Bytes 42,416
Scr. Overflow Mode DISK
-Scr File Count 0
+Scr. File Count 0
Scr. Buffer Blk Size 0
Scr. Buffer Blks Read 0
Scr. Buffer Blks Written 0
@@ -2094,26 +2110,26 @@ Scr. Read Count 0
Scr. Write Count 0
Sort TopN -1
-Table Name
+ ID DOP Table Name
Records Accessed Records Used HBase/Hive HBase/Hive HBase/Hive IO HBase/Hive IO
Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time
-TRAFODION.SCH.TSTAT
+ 1 6 TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 4,503 2,387
+ 4 4 4 0 6,523 3,310
--- SQL operation complete.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_336_S1 PROGRESS;
-Qid MXID11000027092212353966950645999000000000206U3333300_336_S1
-Compile Start Time 2017/02/16 01:03:25.061984
-Compile End Time 2017/02/16 01:03:25.102150
-Compile Elapsed Time 0:00:00.040166
-Execute Start Time 2017/02/16 01:03:28.196863
-Execute End Time 2017/02/16 01:03:28.208332
-Execute Elapsed Time 0:00:00.011469
+>>display statistics for QID MXID11000006521212357413143091999000000000206U3333300_612_S1 PROGRESS;
+Qid MXID11000006521212357413143091999000000000206U3333300_612_S1
+Compile Start Time 2017/03/27 22:20:21.762150
+Compile End Time 2017/03/27 22:20:21.795421
+Compile Elapsed Time 0:00:00.033271
+Execute Start Time 2017/03/27 22:20:25.191770
+Execute End Time 2017/03/27 22:20:25.204461
+Execute Elapsed Time 0:00:00.012691
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -2131,7 +2147,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/02/16 01:03:28.206366
+First Row Returned Time 2017/03/27 22:20:25.202687
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -2139,41 +2155,42 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type OPERATOR_STATS
-SQL Process Busy Time 5,649
+SQL Process Busy Time 7,069
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 135 KB
-SQL Heap Used 14 KB
+SQL Heap Allocated 200 KB
+SQL Heap Used 78 KB
+SQL Heap WM 10,341 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
Request Message Bytes 39,712
Reply Message Count 15
-Reply Message Bytes 42,256
+Reply Message Bytes 42,416
-Table Name
+ ID DOP Table Name
Records Accessed Records Used HBase/Hive HBase/Hive HBase/Hive IO HBase/Hive IO
Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time
-TRAFODION.SCH.TSTAT
+ 1 6 TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 4,503 2,387
+ 4 4 4 0 6,523 3,310
- Id TDB Name Mode TopN CPU Time File Count
- BMO Heap Used BMO Heap Total BMO Heap WM BMO Space BufSz BMO Space BufCnt
- ScrBlk Size ScrBlk Read ScrBlk Written ScrIO Read ScrIO Written
- 6 EX_HASH_GRBY DISK -1 2,559 0
- 4 1,024 7,687 256 0
- -1 0 0 0 0
+ Id TDB Name Mode DOP TopN CPU Time File Count
+ BMO Heap Used BMO Heap Total BMO Heap WM BMO Space BufSz BMO Space BufCnt
+ Size ScrBlk Read ScrBlk Written ScrIO Read ScrIO Written ScrIO Time
+ 6 EX_HASH_GRBY DISK 2 -1 2,725 0
+ 0 0 0 256 0
+ -1 0 0 0 0 0
--- SQL operation complete.
->>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_336_S1 PROGRESS;
-Qid MXID11000027092212353966950645999000000000206U3333300_336_S1
-Compile Start Time 2017/02/16 01:03:25.061984
-Compile End Time 2017/02/16 01:03:25.102150
-Compile Elapsed Time 0:00:00.040166
-Execute Start Time 2017/02/16 01:03:28.196863
-Execute End Time 2017/02/16 01:03:28.208332
-Execute Elapsed Time 0:00:00.011469
+>>get statistics for QID MXID11000006521212357413143091999000000000206U3333300_612_S1 PROGRESS;
+Qid MXID11000006521212357413143091999000000000206U3333300_612_S1
+Compile Start Time 2017/03/27 22:20:21.762150
+Compile End Time 2017/03/27 22:20:21.795421
+Compile Elapsed Time 0:00:00.033271
+Execute Start Time 2017/03/27 22:20:25.191770
+Execute End Time 2017/03/27 22:20:25.204461
+Execute Elapsed Time 0:00:00.012691
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -2191,7 +2208,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/02/16 01:03:28.206366
+First Row Returned Time 2017/03/27 22:20:25.202687
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -2199,45 +2216,46 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type OPERATOR_STATS
-SQL Process Busy Time 5,649
+SQL Process Busy Time 7,069
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 135 KB
-SQL Heap Used 14 KB
+SQL Heap Allocated 200 KB
+SQL Heap Used 78 KB
+SQL Heap WM 10,341 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
Request Message Bytes 39,712
Reply Message Count 15
-Reply Message Bytes 42,256
+Reply Message Bytes 42,416
-Table Name
+ ID DOP Table Name
Records Accessed Records Used HBase/Hive HBase/Hive HBase/Hive IO HBase/Hive IO
Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time
-TRAFODION.SCH.TSTAT
+ 1 6 TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 4,503 2,387
+ 4 4 4 0 6,523 3,310
- Id TDB Name Mode TopN CPU Time File Count
- BMO Heap Used BMO Heap Total BMO Heap WM BMO Space BufSz BMO Space BufCnt
- ScrBlk Size ScrBlk Read ScrBlk Written ScrIO Read ScrIO Written
- 6 EX_HASH_GRBY DISK -1 2,559 0
- 4 1,024 7,687 256 0
- -1 0 0 0 0
+ Id TDB Name Mode DOP TopN CPU Time File Count
+ BMO Heap Used BMO Heap Total BMO Heap WM BMO Space BufSz BMO Space BufCnt
+ Size ScrBlk Read ScrBlk Written ScrIO Read ScrIO Written ScrIO Time
+ 6 EX_HASH_GRBY DISK 2 -1 2,725 0
+ 0 0 0 256 0
+ -1 0 0 0 0 0
--- SQL operation complete.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_336_S1 DEFAULT;
-Qid MXID11000027092212353966950645999000000000206U3333300_336_S1
-Compile Start Time 2017/02/16 01:03:25.061984
-Compile End Time 2017/02/16 01:03:25.102150
-Compile Elapsed Time 0:00:00.040166
-Execute Start Time 2017/02/16 01:03:28.196863
-Execute End Time 2017/02/16 01:03:28.208332
-Execute Elapsed Time 0:00:00.011469
+>>display statistics for QID MXID11000006521212357413143091999000000000206U3333300_612_S1 DEFAULT;
+Qid MXID11000006521212357413143091999000000000206U3333300_612_S1
+Compile Start Time 2017/03/27 22:20:21.762150
+Compile End Time 2017/03/27 22:20:21.795421
+Compile Elapsed Time 0:00:00.033271
+Execute Start Time 2017/03/27 22:20:25.191770
+Execute End Time 2017/03/27 22:20:25.204461
+Execute Elapsed Time 0:00:00.012691
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -2255,7 +2273,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/02/16 01:03:28.206366
+First Row Returned Time 2017/03/27 22:20:25.202687
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -2266,27 +2284,27 @@ Stats Collection Type OPERATOR_STATS
LC RC Id PaId ExId Frag TDB Name DOP Dispatches Oper CPU Time Est. Records Used Act. Records Used Details
-10 . 11 . 5 0 EX_ROOT 1 5 17 0 4 1049
-9 . 10 11 4 0 EX_SPLIT_TOP 1 5 7 2 4
-8 . 9 10 4 0 EX_SEND_TOP 2 10 1,025 2 4
-7 . 8 9 4 2 EX_SEND_BOTTOM 2 21 77 2 4
-6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 7 2 4 3223
-5 . 6 7 3 2 EX_HASH_GRBY 2 6 2,559 1 4 0|0|0
-4 . 5 6 2 2 EX_SPLIT_TOP 2 11 8 100 4
-3 . 4 5 2 2 EX_SEND_TOP 4 18 572 100 4
-2 . 3 4 2 3 EX_SEND_BOTTOM 4 35 136 100 4
-1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 11 100 4 1377
-. . 1 2 1 3 EX_TRAF_KEY_SELECT 6 12 3,690 100 4 TRAFODION.SCH.TSTAT|4|176
-
---- SQL operation complete.
->>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_336_S1 DEFAULT;
-Qid MXID11000027092212353966950645999000000000206U3333300_336_S1
-Compile Start Time 2017/02/16 01:03:25.061984
-Compile End Time 2017/02/16 01:03:25.102150
-Compile Elapsed Time 0:00:00.040166
-Execute Start Time 2017/02/16 01:03:28.196863
-Execute End Time 2017/02/16 01:03:28.208332
-Execute Elapsed Time 0:00:00.011469
+10 . 11 . 5 0 EX_ROOT 1 5 10 0 4 1211
+9 . 10 11 4 0 EX_SPLIT_TOP 1 5 8 2 4
+8 . 9 10 4 0 EX_SEND_TOP 2 10 1,193 2 4
+7 . 8 9 4 2 EX_SEND_BOTTOM 2 17 142 2 4
+6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 9 2 4 3732
+5 . 6 7 3 2 EX_HASH_GRBY 2 6
<TRUNCATED>