Incorrect syntax near 'EXTERNAL'.

Question

Hi Expert,

CREATE EXTERNAL FILE FORMAT parquet_file_format

WITH (

FORMAT_TYPE = PARQUET,

[ , DATA_COMPRESSION = { 'org.apache.hadoop.io.compress.GzipCodec' }]

);

while creating external file format getting below error

Incorrect syntax near 'EXTERNAL'.

Answer 1

Can you confirm on which Azure offering you are executing this statement?

and can you try with the below format removing the [] brackets and confirm

CREATE EXTERNAL FILE FORMAT parquetfile1
WITH (
    FORMAT_TYPE = PARQUET,
    DATA_COMPRESSION = 'org.apache.hadoop.io.compress.SnappyCodec'
);