[IMPALA-11268] Allow STORED BY and STORED AS as well

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: Impala 4.2.0
• Component/s: Frontend
• Labels: impala-iceberg
• Epic Color: ghx-label-1
• Assignee: Gergely Fürnstáhl
• Reporter: Zoltán Borók-Nagy
• Created: 25/Apr/22 12:42
• Updated: 03/Aug/22 10:27
• Resolved: 03/Aug/22 10:27

Description

Currently Impala only recognizes the STORED AS clause, and it uses it for every file format and storage engine.
Hive behaves differently, it uses STORED AS for file formats, and STORED BY for storage engines like Kudu, HBase, Iceberg.
This is especially convenient for Iceberg uses, because they can write the following statement to create a table:
CREATE TABLE ice_t (i int) STORED BY ICEBERG STORED AS PARQUET;

We could extend Impala's syntax to allow the above as. For backward-compatibility we still need to support STORED AS ICEBERG as well.

Issue Links

• split to: IMPALA-11442 Allow "STORED BY ... STORED AS ..." in Impala