Answer-first summary for fast verification
Answer: SELECT * FROM recordings_tmp_vw ORDER BY device_id
Streaming DataFrames/Datasets have certain limitations. Operations like multiple streaming aggregations, limit and take first N rows, distinct operations, deduplication after aggregation, and sorting operations are either not supported or have specific conditions. Sorting operations, for instance, are only supported after an aggregation and in Complete Output Mode. The operation `SELECT * FROM recordings_tmp_vw ORDER BY device_id` involves sorting, which is not supported on streaming Datasets without prior aggregation, making it the correct answer.
Author: LeetQuiz Editorial Team
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
No comments yet.