topic Re: PARSE_SYNTAX_ERROR: Syntax error at or near 'VACUUM' in Data Engineering

PARSE_SYNTAX_ERROR: Syntax error at or near 'VACUUM'

Dicer — Wed, 02 Nov 2022 11:22:37 GMT

I tried to VACUUM a delta table, but there is a Syntax error.

Here is the code:

%sql
set spark.databricks.delta.retentionDurationCheck.enabled = False
 
VACUUM test_deltatable

Ravi — Wed, 02 Nov 2022 11:32:00 GMT

@Cheuk Hin Christophe Poon Missing semi-colon at end of line 2?

%sql
set spark.databricks.delta.retentionDurationCheck.enabled = False;
 
VACUUM test_deltatable

Dicer — Thu, 03 Nov 2022 05:21:24 GMT

I asked a stupid question😂 I forgot to add ;

This one works

%sql
set spark.databricks.delta.retentionDurationCheck.enabled = False;
 
VACUUM test_deltatable;