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 BottomVotersWatch 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

        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:
            10 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Issue deployment