Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-27831 Set hive.cbo.fallback.strategy to NEVER by default
  3. HIVE-28333

Skip CBO for UNIQUEJOIN and TABLESAMPLE

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 4.1.0
    • CBO

    Description

      CBO doesn't support TABLESAMPLE, UNIQUEJOIN, and UNIONTYPE.

      TABLESAMPLE not supported

      fname=archive_excludeHadoop20.q

      SELECT key FROM harbucket TABLESAMPLE(BUCKET 1 OUT OF 10) SORT BY key

      org.apache.hadoop.hive.ql.optimizer.calcite.CalciteSemanticException: Table Sample specified for harbucket. Currently we don't support Table Sample clauses in CBO, turn off cbo for queries on tableSamples.

      UNIQUE JOIN not supported

      fname=explainuser_2.q

      EXPLAIN FROM UNIQUEJOIN PRESERVE src a_n19 (a_n19.key), PRESERVE src1 b_n15 (b_n15.key), PRESERVE srcpart c_n4 (c_n4.key) SELECT a_n19.key, b_n15.key, c_n4.key 

      org.apache.hadoop.hive.ql.optimizer.calcite.CalciteSemanticException: UNIQUE JOIN is currently not supported in CBO, turn off cbo to use UNIQUE JOIN.

      Attachments

        Issue Links

          links to

          Web Link GitHub Pull Request #5307

          Activity

            People

              soumyakanti.das Soumyakanti Das
              soumyakanti.das Soumyakanti Das
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: