Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
Which operation is not supported when using a streaming dataframe view created by spark.readStream.table('recordings_bronze').createOrReplaceTempView('recordings_tmp_vw')?
spark.readStream.table('recordings_bronze').createOrReplaceTempView('recordings_tmp_vw')
A
SELECT device_id, count(device_id) AS total_recordings FROM recordings_tmp_vw GROUP BY device_id
B
SELECT * FROM recordings_tmp_vw WHERE heartrate > 0
C
SELECT * FROM recordings_tmp_vw ORDER BY device_id
D
SELECT *, current_timestamp() as receipt_time FROM recordings_tmp_vw
E
SELECT * FROM recordings_tmp_vw
