A classic cluster fails to start and terminates with INIT_SCRIPT_FAILURE, naming a cluster-scoped script stored in a volume. Cluster log delivery is configured. Where should the engineer look first to find the failing command?
id q7a8b0becbf
Home / Data Engineer Associate / Objective 6.5
Domain 6: Troubleshooting, Monitoring, and Optimization · 10% of the exam · Full exam outline
A classic cluster fails to start and terminates with INIT_SCRIPT_FAILURE, naming a cluster-scoped script stored in a volume. Cluster log delivery is configured. Where should the engineer look first to find the failing command?
id q7a8b0becbf
A job computes changes in sensor readings with this query:
SELECT device_id, reading_ts,
reading - LAG(reading) OVER (ORDER BY reading_ts) AS delta
FROM iot.silver.readings
Each delta is meant to compare a reading with the previous reading from the same device. As the table grew, executors started running out of memory in the stage that computes the window. Which change fixes the cause?
id q910ca08865