CREATE [OR REPLACE] TABLE support for Hive

[findinpath]

There exists already INSERT OVERWRITE functionality for partition tables in Trino through the use of the session property:

SET SESSION hive.insert_existing_partitions_behavior = 'OVERWRITE' 

Implement CREATE OR REPLACE for (unpartitioned) Hive tables.

Development information

This functionality builds on top of the scaffolding used for Iceberg & Delta #13180

See:

• Support CREATE OR REPLACE in parser #17050
• Add support for CREATE OR REPLACE TABLE statement #13681

[samssh]

Is anyone currently working on this? Can I contribute to this issue?

[findinpath]

Go for it.

[sug-ghosh]

@findinpath is anyone working on this, if not can I take this?