Selvaganesan Govindarajan created TRAFODION-2631:
----------------------------------------------------
Summary: Disk IO counter is not populated for hdfs/hive IOs
Key: TRAFODION-2631
URL: https://issues.apache.org/jira/browse/TRAFODION-2631
Project: Apache Trafodion
Issue Type: Bug
Components: sql-exe
Affects Versions: 2.2-incubating
Reporter: Selvaganesan Govindarajan
Assignee: Selvaganesan Govindarajan
Fix For: 2.2-incubating
>>select [last 0] * from hive.hive.store_orc ;
..
--- 0 row(s) selected.
>>fc get
>>get statistics for qid current ;
..
Qid
MXID11000017354212363181358222000000000000206U3333300_157___SQLCI_DML_LAST__
Compile Start Time 2017/06/02 16:36:58.273995
Compile End Time 2017/06/02 16:37:00.100361
Compile Elapsed Time 0:00:01.826366
Execute Start Time 2017/06/02 16:37:00.100932
Execute End Time 2017/06/02 16:37:00.538304
Execute Elapsed Time 0:00:00.437372
State DEALLOCATED
Rows Affected 0
SQL Error Code 100
Stats Error Code 0
Query Type SQL_SELECT_NON_UNIQUE
Sub Query Type SQL_STMT_NA
Estimated Accessed Rows 0
Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
Number of SQL Processes 1
Number of Cpus 1
Transaction Id -1
Source String select [last 0] * from hive.hive.store_orc ;
SQL Source Length 44
Rows Returned 0
First Row Returned Time -1
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Query hash 5095926260958264825
Stats Collection Type OPERATOR_STATS
SQL Process Busy Time 373,044
UDR Process Busy Time 0
SQL Space Allocated 9,301 KB
SQL Space Used 9,294 KB
SQL Heap Allocated 10,341 KB
SQL Heap Used 10,337 KB
SQL Heap WM 10,337 KB
Processes Created 0
Process Create Time 0
Request Message Count 0
Request Message Bytes 0
Reply Message Count 0
Reply Message Bytes 0
BMO Space Buffer Size 0
BMO Space Buffer Count 0
BMO Interim Row Count 0
Scr. Overflow Mode UNKNOWN
Scr. File Count 0
Scr. IO Size 0
Scr. Read Count 0
Scr. Write Count 0
Scr. IO Max Time 0
Sort TopN -1
Id DOP Table Name
EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed
SE_IOs SE_IO_KBytes SE_IO_SumTime SE_IO_MaxTime
1 1 HIVE.STORE_ORC
100 12 100 12
0 4 16,816 16,816
--- SQL operation complete.
>>
SE_IOs is 0 in the above output
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
