Shohei Okumiya

[WIP][PoC] The minimal implementation of Partition-Aware Optimization

2

Don't review this PR. It is an example of Partition-Aware Optimization that is not ready to be merged. - https://issues.apache.org/jira/browse/HIVE-27734 - https://docs.google.com/document/d/1srEK3atO2T3Apa-FsF6bW__ECY-nFrev_1RZ8EN4UF8/edit?usp=sharing

HIVE-28193: Skip CBO fallback when EXCEPT/INTERSECT/QUALIFY are used

3

### What changes were proposed in this pull request? Skip `hive.cbo.fallback.strategy=CONSERVATIVE|ALWAYS` when EXCEPT, INTERSECT, or QUALIFY are used. https://issues.apache.org/jira/browse/HIVE-28193 ### Why are the changes needed? Users see a confusing error...

HIVE-28208: WITH column list doesn't work with CTE materialization

3

### What changes were proposed in this pull request? ANSI SQL supports column aliases for CTEs. Hive also supports it but it fails when CTEs are materialized. https://issues.apache.org/jira/browse/HIVE-28208 ### Why...

HIVE-28302: Let SUM UDF return NULL when all rows have non-numeric texts

1

### What changes were proposed in this pull request? Make SUM return not 0.0 but NULL when both of the following conditions are satisfied. - The input type is a...

TEZ-4569: SCATTER_GATHER + BROADCAST hangs on DAG Recovery

2

Let an AM correctly restore its state and restart tasks. https://issues.apache.org/jira/browse/TEZ-4569

HIVE-28411: Bucket Map Join on Iceberg tables

3

### What changes were proposed in this pull request? Enable Bucket Map Join using Bucket Transform of Apache Iceberg. This is a part of the Partition-Aware Optimization initiative. - https://issues.apache.org/jira/browse/HIVE-28411...

HIVE-28446: Convert some reserved words to non-reserved words

1

### What changes were proposed in this pull request? Mark some reserved words as non-reserved based on the ANSI standard. I did the following. 1. [Write unit tests using the...

HIVE-12679: Allow users to be able to specify an implementation of IMetaStoreClient via HiveConf

26

### What changes were proposed in this pull request? Make it possible to replace the default IMetaStoreClient with a custom one. It is the third time to try to send...

HIVE-28363: Improve heuristics of FilterStatsRule without column stats

2

### What changes were proposed in this pull request? Make FilterStatsRule reduce the number of filtered rows by half when # of distinct values is empty. https://issues.apache.org/jira/browse/HIVE-28363 ### Why are...

HIVE-24167: TPC-DS query 14 fails while generating plan for the filter

2

### What changes were proposed in this pull request? With this change, Hive skips using or persisting runtime stats when PlanMapper throws [equivalence mapping violation](https://github.com/apache/hive/blob/rel/release-4.0.0/ql/src/java/org/apache/hadoop/hive/ql/plan/mapper/PlanMapper.java#L220). In some more contexts, we've...