
Ultimate access to all questions.
Which operation is not supported when using a streaming dataframe view created by 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*