[jira] [Resolved] (IMPALA-11268) Allow STORED BY and STORED AS as well

["Gergely Fürnstáhl (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IMPALA-11268?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Gergely Fürnstáhl resolved IMPALA-11268.
----------------------------------------
    Fix Version/s: Impala 4.2.0
       Resolution: Fixed

> Allow STORED BY and STORED AS as well
> -------------------------------------
>
>                 Key: IMPALA-11268
>                 URL: https://issues.apache.org/jira/browse/IMPALA-11268
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Frontend
>            Reporter: Zoltán Borók-Nagy
>            Assignee: Gergely Fürnstáhl
>            Priority: Major
>              Labels: impala-iceberg
>             Fix For: Impala 4.2.0
>
>
> 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.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)