공부

[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