Uploaded image for project: 'Apache Trafodion (Retired)'
  1. Apache Trafodion (Retired)
  2. TRAFODION-2631

Disk IO counter is not populated for hdfs/hive IOs

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 2.2.0
    • 2.2.0
    • sql-exe
    • None

    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

          Activity

            People

              selvag Selvaganesan Govindarajan
              selvag Selvaganesan Govindarajan
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: