Soumyakanti Das created HIVE-28333: -------------------------------------- Summary: Skip CBO for UNIQUEJOIN and TABLESAMPLE 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
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)