You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Selvaganesan Govindarajan (JIRA)" <ji...@apache.org> on 2017/10/12 21:48:00 UTC
[jira] [Resolved] (TRAFODION-2631) Disk IO counter is not populated
for hdfs/hive IOs
[ 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)