Answer-first summary for fast verification
Answer: 1. withColumn 2. from_unixtime 3. col("openDate") 4. “EEEE, MMM d, yyyy h:mm a"
The correct answer is A because it uses `withColumn` to add a new column named `openDateString`, `from_unixtime` to convert the UNIX epoch time from the `openDate` column to a formatted string, and the correct format string `"EEEE, MMM d, yyyy h:mm a"` to achieve the desired output. Option B incorrectly uses `date_format` which is not suitable for converting UNIX epoch time directly. Options C, D, and E contain typos or incorrect functions and format strings, making them invalid choices.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Given a DataFrame storesDF with an integer column openDate representing UNIX epoch timestamps, which code snippet correctly converts these timestamps to a string representation using Java's SimpleDateFormat?
The DataFrame structure is as follows:
storeId openDate
0 1100746394
1 1474410343
2 1116610009
3 1180035265
4 1408024997
storeId openDate
0 1100746394
1 1474410343
2 1116610009
3 1180035265
4 1408024997
Fill in the blanks in the following code block to achieve this conversion:
storesDF.__1__("openDateString", __2__(__3__, __4__))
storesDF.__1__("openDateString", __2__(__3__, __4__))
A
B
C
D
E
No comments yet.