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

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsAdd voteVotersWatch issueWatchersConvert to IssueMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            ziyangz Ziyang Zhao Assign to me
            holman.lan0@gmail.com Holman Lan

            Dates

              Created:
              Updated:

              Slack

                Issue deployment