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

refactor Hive strict checks to be more granular, allow order by no limit and no partition filter by default for now

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Blocker
    • Resolution: Fixed
    • None
    • 2.0.0
    • None

    Description

      Making strict mode the default recently appears to have broken many normal queries, such as some TPCDS benchmark queries, e.g. Q85:
      Response message: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: SemanticException [Error 10041]: No partition predicate found for Alias "web_sales" Table "web_returns"

      We should remove this restriction from strict mode, or change the default back to non-strict. Perhaps make a 3-value parameter, nonstrict, semistrict, and strict, for backward compat for people who are relying on strict already.

      Attachments

        1. HIVE-12727.patch
          15 kB
          Sergey Shelukhin
        2. HIVE-12727.01.patch
          15 kB
          Sergey Shelukhin
        3. HIVE-12727.02.patch
          22 kB
          Sergey Shelukhin
        4. HIVE-12727.03.patch
          532 kB
          Sergey Shelukhin
        5. HIVE-12727.04.patch
          29 kB
          Sergey Shelukhin
        6. HIVE-12727.05.patch
          29 kB
          Sergey Shelukhin
        7. HIVE-12727.06.patch
          92 kB
          Sergey Shelukhin
        8. HIVE-12727.07.patch
          96 kB
          Sergey Shelukhin

        Issue Links

        is related to

        Bug - A problem which impairs or prevents the functions of the product. HIVE-15148 disallow loading data into bucketed tables (by default)

        • Major - Major loss of function.
        • Resolved

        Improvement - An improvement or enhancement to an existing feature or task. HIVE-18251 Loosen restriction for some checks

        • Major - Major loss of function.
        • Closed

        Task - A task that needs to be done. HIVE-12413 Default mode for hive.mapred.mode should be strict

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

        Bug - A problem which impairs or prevents the functions of the product. HIVE-14346 Change the default value for hive.mapred.mode to null

        • Major - Major loss of function.
        • Resolved

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

          People

            sershe Sergey Shelukhin Assign to me
            sershe Sergey Shelukhin
            Votes:
            0 Vote for this issue
            Watchers:
            9 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment