Explanation:
To enable automatic liquid clustering on a new table, use CLUSTER BY AUTO.
Ultimate access to all questions.
No comments yet.
You want Databricks to automatically choose clustering keys for a new table events. Which SQL command is correct?
A
CREATE TABLE events (event_id STRING, event_time TIMESTAMP) CLUSTER BY AUTO;
B
CREATE TABLE events (event_id STRING, event_time TIMESTAMP) CLUSTER BY (AUTO);
C
CREATE TABLE events (event_id STRING, event_time TIMESTAMP) AUTO CLUSTER;
D
CREATE TABLE events (event_id STRING, event_time TIMESTAMP) PARTITION BY AUTO;