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 Tablearrow-up-right.

circle-exclamation

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)arrow-up-right for more information.

Last updated

Was this helpful?