| 12345678910111213141516171819202122232425262728293031323334353637 |
- select sz_g from /univ_demo/person WHERE sz_g != '' group by sz_g
- /**
- output()
- **/
- ;
- select distinct sz_g from /univ_demo/person WHERE sz_g != ''
- /**
- output()
- **/
- ;
- -- SELECT area.business_trend_15m AS "business_trend", area.timestamp AS "time"
- -- FROM /zhejiang_mobile/area area WHERE area.event_name like '%2026春节网络保障%'
- -- AND area.area_name = '5ajiaxingnanhujingqu' LIMIT 0, 500000
- -- /**
- -- output()
- -- **/
- -- ;
- -- SELECT temp01.time AS "timestamp",
- -- temp01.business_trend.time('2026-02-17 00:00:00','').find(name = '总用户数') AS "total_users"
- -- FROM (SELECT area.business_trend_15m AS "business_trend", area.timestamp AS "time"
- -- FROM /zhejiang_mobile/area area WHERE area.event_name like '%2026春节网络保障%'
- -- AND area.area_name = '5ajiaxingnanhujingqu' LIMIT 0, 500000) temp01 LIMIT 0, 500000
- -- /**
- -- output()
- -- **/
- -- ;
|