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

Backport: Fastpath for limited fetches from unpartitioned tables

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 0.14.0, 0.15.0
    • Fix Version/s: 1.0.0
    • Component/s: Physical Optimizer
    • Labels:
    • Release Note:
      SimpleFetchOptimizer for limited fetches without filters

      Description

      Currently, for flat tables, the threshold check is applicable for a query like select * from lineitem limit 1;.

      This is not necessary as without a filter clause, this can be executed entirely via FetchTask. Running a cluster task is redundant for this case.

      This fastpath is applicable for partitioned tables already.

        Issue Links

          Activity

          Hide
          hagleitn Gunther Hagleitner added a comment -

          +1

          Show
          hagleitn Gunther Hagleitner added a comment - +1
          Hide
          gopalv Gopal V added a comment -

          Committed to branch, thanks Gunther Hagleitner.

          Show
          gopalv Gopal V added a comment - Committed to branch, thanks Gunther Hagleitner .
          Hide
          thejas Thejas M Nair added a comment -

          Updating release version for jiras resolved in 1.0.0 .

          Show
          thejas Thejas M Nair added a comment - Updating release version for jiras resolved in 1.0.0 .
          Hide
          thejas Thejas M Nair added a comment -

          This issue has been fixed in Apache Hive 1.0.0. If there is any issue with the fix, please open a new jira to address it.

          Show
          thejas Thejas M Nair added a comment - This issue has been fixed in Apache Hive 1.0.0. If there is any issue with the fix, please open a new jira to address it.

            People

            • Assignee:
              gopalv Gopal V
              Reporter:
              gopalv Gopal V
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development