Hive常用代码
解析JSON： 1 SELECT CAST(GET_JSON_OBJECT(field, '$.json_path') AS string) 正则匹配 1 SELECT regexp_like('text', 'regex')……
16 4 2 2 1 1 hive articles
Presto常用代码
解析JSON： 1 SELECT CAST(json_extract(field, '$.json_path') AS string) 正则匹配 1 SELECT regexp_like('text', 'regex') 定义查询变量 1 2 3 4 5 6 7 8 9 10 11 WITH VARIABLES AS ( SELECT '2022-11-01' AS mdt, '2022-11-31' AS edt ) SELECT a1column FROM app.table a INNER JOIN VARIABLES ON a1dt >= VARIABLES.mdt AND a.dt <= VARIABLES.edt……