062.mql 878 B

12345678910111213141516171819202122232425262728293031323334353637
  1. select sz_g from /univ_demo/person WHERE sz_g != '' group by sz_g
  2. /**
  3. output()
  4. **/
  5. ;
  6. select distinct sz_g from /univ_demo/person WHERE sz_g != ''
  7. /**
  8. output()
  9. **/
  10. ;
  11. -- SELECT area.business_trend_15m AS "business_trend", area.timestamp AS "time"
  12. -- FROM /zhejiang_mobile/area area WHERE area.event_name like '%2026春节网络保障%'
  13. -- AND area.area_name = '5ajiaxingnanhujingqu' LIMIT 0, 500000
  14. -- /**
  15. -- output()
  16. -- **/
  17. -- ;
  18. -- SELECT temp01.time AS "timestamp",
  19. -- temp01.business_trend.time('2026-02-17 00:00:00','').find(name = '总用户数') AS "total_users"
  20. -- FROM (SELECT area.business_trend_15m AS "business_trend", area.timestamp AS "time"
  21. -- FROM /zhejiang_mobile/area area WHERE area.event_name like '%2026春节网络保障%'
  22. -- AND area.area_name = '5ajiaxingnanhujingqu' LIMIT 0, 500000) temp01 LIMIT 0, 500000
  23. -- /**
  24. -- output()
  25. -- **/
  26. -- ;