[jira] [Updated] (HIVE-28333) Skip CBO for UNIQUEJOIN, TABLESAMPLE, and UNIONTYPE

["Soumyakanti Das (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-28333?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Soumyakanti Das updated HIVE-28333:
-----------------------------------
    Summary: Skip CBO for UNIQUEJOIN, TABLESAMPLE, and UNIONTYPE  (was: Skip CBO for UNIQUEJOIN and TABLESAMPLE)

> Skip CBO for UNIQUEJOIN, TABLESAMPLE, and UNIONTYPE
> ---------------------------------------------------
>
>                 Key: HIVE-28333
>                 URL: https://issues.apache.org/jira/browse/HIVE-28333
>             Project: Hive
>          Issue Type: Sub-task
>          Components: CBO
>            Reporter: Soumyakanti Das
>            Assignee: Soumyakanti Das
>            Priority: Major
>              Labels: pull-request-available
>
> CBO doesn't support TABLESAMPLE and UNIQUEJOIN. 
> h3. TABLESAMPLE not supported
> fname=archive_excludeHadoop20.q
> {code:sql}
> SELECT key FROM harbucket TABLESAMPLE(BUCKET 1 OUT OF 10) SORT BY key
> {code}
> {noformat}
> 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.{noformat}
> h3. UNIQUE JOIN not supported
> fname=explainuser_2.q
> {code:sql}
> 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 
> {code}
> {noformat}
> org.apache.hadoop.hive.ql.optimizer.calcite.CalciteSemanticException: UNIQUE JOIN is currently not supported in CBO, turn off cbo to use UNIQUE JOIN.{noformat}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)