
Ultimate access to all questions.
Given a Delta Lake table with the following schema for user content post metadata:
user_id LONG,
post_text STRING,
post_id STRING,
longitude FLOAT,
latitude FLOAT,
post_time TIMESTAMP,
date DATE
user_id LONG,
post_text STRING,
post_id STRING,
longitude FLOAT,
latitude FLOAT,
post_time TIMESTAMP,
date DATE
Which column would be the most suitable for partitioning the Delta table?
A
post_time_
B
latitude
C
post_id_
D
user_id_
E
date