Error while creating delta table with partitions
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-12-2023 12:27 PM
Hi,
PARTITION -> PARTITIONED
Good Luck
** You might also want to subscribe to Warsaw Databricks YT channel: https://www.youtube.com/channel/UC1-u_2nI97cNHtu_FQ3HP_A
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-23-2023 02:36 PM
@Retired_mod Hi. Is that not exactly what I suggested before? Sorry for stupid questions, but I am learning rules or earning kudos and getting solutions approved, therefore suggestions from your end would be appreciated. Thank you.
** You might also want to subscribe to Warsaw Databricks YT channel: https://www.youtube.com/channel/UC1-u_2nI97cNHtu_FQ3HP_A