External

Create table option

Description

A table created without the EXTERNAL clause is called a managed table because Hive manages its data. For more information please refer to Create a External Table.

External tables are translated to regular tables.

Sample Source

Hive

CREATE EXTERNAL TABLE table1 ( 
    col1 integer
);

Snowflake

--** MSC-INFORMATION - MSCINF0006 - EXTERNAL TABLE TRANSLATED TO REGULAR TABLE **
CREATE OR REPLACE TABLE table1 ( 
    col1 integer
);

Known Issues

Snowflake allows the use of external tables but there are several differences in the tables properties used in Hive. Please refer to (Snowflake)SQL Reference (Create External Table) for more information.

Related EWIs

• MSCINF0006: External table translated to a regular table.