[
https://issues.apache.org/jira/browse/TRAFODION-2631?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16035016#comment-16035016
]
ASF GitHub Bot commented on TRAFODION-2631:
-------------------------------------------
GitHub user selvaganesang opened a pull request:
https://github.com/apache/incubator-trafodion/pull/1108
[TRAFODION-2631] Disk IO counter is not populated for hdfs/hive IOs
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/selvaganesang/incubator-trafodion
trafodion-2420_6
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/1108.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #1108
----
commit b3594b338b1a4acd3c0e2f8cb0f37482e42a4ef7
Author: selvaganesang <[email protected]>
Date: 2017-06-02T16:39:42Z
[TRAFODION-2631] Disk IO counter is not populated for hdfs/hive IOs
----
> 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)
