You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Zoltán Borók-Nagy (Jira)" <ji...@apache.org> on 2022/04/25 12:43:00 UTC

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

Zoltán Borók-Nagy created IMPALA-11268:
------------------------------------------

             Summary: 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


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.7#820007)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org