공부
[Spark][SQL] GET_JSON_OBJECT
승가비
2021. 1. 8. 07:11
728x90
SELECT
GET_JSON_OBJECT(ext, '$.id') track_id,
COUNT(1) cnt
FROM {db}.{table}
WHERE 1=1
AND day = 20210107
AND GET_JSON_OBJECT(ext, '$.tp') = 'TRACK'
GROUP BY GET_JSON_OBJECT(ext, '$.id')
LIMIT 1000
728x90