11-02-2022 04:22 AM
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
11-02-2022 04:32 AM
@Cheuk Hin Christophe Poon Missing semi-colon at end of line 2?
%sql set spark.databricks.delta.retentionDurationCheck.enabled = False; VACUUM test_deltatable
View solution in original post
11-02-2022 10:21 PM
I asked a stupid question😂 I forgot to add ;
This one works
%sql set spark.databricks.delta.retentionDurationCheck.enabled = False; VACUUM test_deltatable;
never-displayed
Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections.
Click here to register and join today!
Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.