Error while creating delta table with partitions

Faisal
Contributor

‎11-12-2023 01:38 AM

Hi All,

I am unable to create delta table with partitioning option, can someone please correct me what I am missing and help me with updated query

 

 

CREATE OR REPLACE TABLE invoice 
USING DELTA 
PARTITION BY (year(shp_dt), month(shp_dt)) 
LOCATION '/tables/invoice' 
AS
SELECT
  *,
  current_timestamp() as adls_load_timestamp
FROM
  hive_metastore.invoice_edw 
WHERE 
  shp_dt between '2023-01-01' and '2023-12-31';
​

Error in SQL statement: ParseException: 
[PARSE_SYNTAX_ERROR] Syntax error at or near 'PARTITION'.(line 2, pos 55)

 

 

 
0 Kudos