Stored As

Create table option

Description

STORED AS clause defines the file format for the table. Available formats include TEXTFILE, SEQUENCEFILE among others. For more information refer Storage Formats.

STORED AS clause is not supported by Snowflake.

Sample Source

Hive

CREATE TABLE table1 (
    col1 STRING 
) 
STORED AS TEXTFILE;

Snowflake

CREATE TABLE table1 (
    col1 STRING 
) 
----** MSC-HVXXXX: THE STORED AS CLAUSE IS NOT SUPPORTED IN SNOWFLAKE.
--STORED AS TEXTFILE;

Known Issues

1. In Snowflake, you do not need to explicitly specify a storage format during table creation. Snowflake supports various file formats, including Parquet, Avro, ORC, JSON, CSV, and more, but these formats are handled transparently by Snowflake, and you don't need to specify them explicitly in the CREATE TABLE statement.

Related EWIs

1. MSC-HVXXXX: THE STORED AS CLAUSE IS NOT SUPPORTED IN SNOWFLAKE.