Shohei Okumiya created HIVE-28414: ------------------------------------- Summary: Flexible join optimization based on partition transform specs Key: HIVE-28414 URL: https://issues.apache.org/jira/browse/HIVE-28414 Project: Hive Issue Type: Sub-task Components: Iceberg integration, StorageHandler Reporter: Shohei Okumiya
This ticket would try to introduce as flexible join optimization as Apache Spark. Apache Spark can optimize a join algorithm when joining keys on both tables share compatible partition specs. For example, both tables have `PARTITION SPEC(day(ts))` and a statement has `FROM a JOIN b ON a.ts = b.ts`, Spark can optimize the join. https://docs.google.com/document/d/1foTkDSM91VxKgkEcBMsuAvEjNybjja-uHk-r3vtXWFE/edit#heading=h.82w8qxfl2uwl -- This message was sent by Atlassian Jira (v8.20.10#820010)