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)

Reply via email to