plan is to run the follow statement to populate th...
# troubleshooting
g
plan is to run the follow statement to populate the unnested table
Copy code
INSERT INTO hive_catalog.iot.factory_iot_north_unnested
SELECT
    ts,
    metadata.siteId             AS siteId,
    metadata.deviceId           AS deviceId,
    metadata.sensorId           AS sensorId,
    metadata.unit               AS unit,
    metadata.ts_human           AS ts_human,
    metadata.location.latitude  AS latitude,
    metadata.location.longitude AS longitude,
    metadata.deviceType         AS deviceType,
    measurement
FROM hive_catalog.iot.factory_iot_north;