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

Strict type checks are not enforced on join conditions when CBO disabled

Log workAgile BoardRank to TopRank to BottomAdd voteVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Query Processor
    • Labels:
      None
    • Target Version/s:

      Description

      When hive.strict.checks.type.safety property is set to true, queries with unsafe comparisons should fail with an appropriate exception no matter if CBO is enabled or not (hive.cbo.enable).

      At the moment the safety checks are not applied in join conditions present in the ON clause when CBO is disabled.

      For example, both queries below should fail.

      set hive.strict.checks.type.safety=true;
      set hive.cbo.enable=false;
      SELECT * FROM biginttbl INNER JOIN strtbl ON bigintcol=strcol;
      SELECT * FROM biginttbl INNER JOIN strtbl WHERE bigintcol=strcol;
      

      At the moment, the second query (with WHERE clause) will fail but not the first one (with ON clause).

        Attachments

          Activity

          $i18n.getText('security.level.explanation', $currentSelection) Viewable by All Users
          Cancel

            People

            • Assignee:
              zabetak Stamatis Zampetakis Assign to me
              Reporter:
              zabetak Stamatis Zampetakis

              Dates

              • Created:
                Updated:

                Issue deployment