Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-17627

Use druid scan query instead of the select query.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 3.0.0
    • Druid integration
    • None

    Description

      The biggest difference between select query and scan query is that, scan query doesn't retain all rows in memory before rows can be returned to client.
      It will cause memory pressure if too many rows required by select query.
      Scan query doesn't have this issue.
      Scan query can return all rows without issuing another pagination query, which is extremely useful when query against historical or realtime node directly.

      Attachments

        1. HIVE-17627.1.patch
          15 kB
          Nishant Bangarwa
        2. HIVE-17627.2.patch
          15 kB
          Nishant Bangarwa
        3. HIVE-17627.patch
          15 kB
          Nishant Bangarwa

        Issue Links

          Dependency

          Bug - A problem which impairs or prevents the functions of the product. HIVE-18518 Upgrade druid version to 0.11.0

          • Major - Major loss of function.
          • Closed
          is related to

          Improvement - An improvement or enhancement to an existing feature or task. CALCITE-2077 Druid adapter: Use "scan" query rather than "select" query

          • Major - Major loss of function.
          • Closed
          links to

          Web Link review link

          Activity

            People

              nishantbangarwa Nishant Bangarwa
              bslim Slim Bouguerra
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: