SSC-EWI-HV0001

The ROW FORMAT clause is not supported in Snowflake

Severity

Medium

Description

This EWI is added when a ROW FORMAT statement is encountered.

Code Example

Input Code:

BigQuery

IN -> Hive_01.sql

CREATE TABLE parquet_table ( 
id INT, data STRING
)  
 ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' ESCAPED BY '\\' COLLECTION ITEMS TERMINATED BY ';' MAP KEYS TERMINATED BY ':' LINES TERMINATED BY '\n' NULL DEFINED AS 'NULL_VALUE';

Output Code:

Snowflake

OUT -> Hive_01.sql

CREATE TABLE parquet_table (
 id INT,
 data STRING
)
!!!RESOLVE EWI!!! /*** SSC-EWI-HV0001 - THE ROW FORMAT CLAUSE IS NOT SUPPORTED IN SNOWFLAKE ***/!!!
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ',' ESCAPED BY '\\'
COLLECTION ITEMS TERMINATED BY ';'
MAP KEYS TERMINATED BY ':'
LINES TERMINATED BY '\n'
NULL DEFINED AS 'NULL_VALUE'
;