Explanation:
The correct function is TRANSFORM, which is used to apply a specified function to each element in an array. In this scenario, it converts each Celsius temperature reading in the array to Fahrenheit. The syntax is transform(expr, func), where expr is the array and func is the function to apply to each element.
Ultimate access to all questions.
No comments yet.
You are tasked with converting temperature readings from Celsius to Fahrenheit in an IoT dataset. Each device has 5 readings stored in an array. Complete the SQL query by selecting the appropriate function to apply the conversion to each element in the array.
Schema: deviceId INT, deviceTemp ARRAY
SELECT deviceId, __(deviceTempC, i -> (i * 9/5) + 32) as deviceTempF FROM sensors
A
APPLY
B
MULTIPLY
C
ARRAYEXPR
D
TRANSFORM
E
FORALL