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

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: