- 显示表中除了partition意外的所有列
select t.`(ds)?+.+` from table t;
- 聚合
wm_concat(';',cust_id)
- 统计非空
yin count(DISTINCT )
- 相当于if(a=null,0,a)
coalesce(a,0)
- 将a表放在内存中,用于到a表是小表导致数据倾斜的时候
SELECT /*+MAPJOIN(a) */
- 将a表和b表的t列合并为一张表
SELECT t
FROM (
SELECT CAST(a AS BIGINT) AS t
FROM table_y1
WHERE ds = ${bizdate}
UNION ALL
SELECT CAST(b AS BIGINT) AS t
FROM table_y2
WHERE ds = ${bizdate}
) aa - 最新一天的数据
SELECT a FROM table_a WHERE ds = max_pt('table_a')
- 1
sql
最新推荐文章于 2024-08-02 10:52:27 发布