Description
>>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
Attachments
Issue Links
- links to