Explanation:
In Spark SQL, fields within a STRUCT column are accessed using dot notation (column_name.field_name). Therefore, payload.date is the correct syntax.
A
SELECT payload['date']
B
SELECT payload.date
C
SELECT extract(date from payload)
D
SELECT payload->date
No comments yet.