Databricks Certified Associate Developer for Apache Spark
Comments
Loading comments...
Ultimate access to all questions.
The following code block contains an error. It's intended to return a DataFrame with a column "openDateString" that converts the UNIX epoch integer "openDate" column into a string representation using Java's SimpleDateFormat format (e.g., "Sunday, Dec 4, 2008 1:05 PM"). Identify the error in the code:
storesDF.withColumn("openDateString", from_unixtime(col("openDate"), "EEE, MMM d, yyyy h:mm a", TimestampType()))
storesDF.withColumn("openDateString", from_unixtime(col("openDate"), "EEE, MMM d, yyyy h:mm a", TimestampType()))
Sample storesDF data:
storeId openDate
0 1100746394
1 1474410343
2 1116610009
3 1180035265
4 1408024997
```_
storeId openDate
0 1100746394
1 1474410343
2 1116610009
3 1180035265
4 1408024997
```_
A
The from_unixtime() operation only accepts two parameters – the TimestampTime() arguments not necessary._
B
The from_unixtime() operation only works if column openDate is of type long rather than integer – column openDate must first be converted._
C
The second argument to from_unixtime() is not correct – it should be a variant of TimestampType() rather than a string._
D
The from_unixtime() operation automatically places the input column in java’s SimpleDateFormat – there is no need for a second or third argument._
E
The column openDate must first be converted to a timestamp, and then the Date() function can be used to reformat to java’s SimpleDateFormat.