[ https://issues.apache.org/jira/browse/TRAFODION-2631?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Selvaganesan Govindarajan resolved TRAFODION-2631. -------------------------------------------------- Resolution: Fixed > 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.4.14#64029)