Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-14549 HiveServer2: Improve HiveServer2 JDBC/ODBC ResultSet performance - part2
  3. HIVE-13770

HiveServer2: Improve Thrift result set streaming when serializing thrift ResultSets in tasks by fetching the results as soon as they are available

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • HiveServer2, JDBC
    • None

    Description

      When serializing the Thrift result set in final task, i.e. the hive.server2.thrift.resultset.serialize.in.tasks property is set to true, HS2 does not start sending the results until the entire result set has been written to HDFS.

      This is not efficient and we should find a way for HS2 to start sending the results as soon as a block of result becomes available. The advantage for this is two folds. One, the client can start consuming the results much sooner. Two, we can start reclaiming the storage space in HDFS used by a particular result set block as soon as the result set block has been successfully sent to the client.

      It's worth checking if this is also the case when not serializing the Thrift result set in final task.

      Attachments

        Activity

          People

            ziyangz Ziyang Zhao
            holman.lan0@gmail.com Holman Lan
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated: