Share via

Incorrect syntax near 'EXTERNAL'.

Shambhu Rai 1,411 Reputation points
2023-08-02T21:59:13.6733333+00:00

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'.

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,426 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,696 questions
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,080 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nandan Hegde 31,511 Reputation points MVP
    2023-08-03T03:14:52.8933333+00:00

    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'
);
    1 person found this answer helpful.