select logday,app_version,element_page,count(1) as pv
from ods_news.event
where logday=format_datetime(cast('2020-08-01' as timestamp),'yyyyMMdd') and app_version!=''
group by 1,2,3
presto GROUP BY 子句对 SELECT 语句的输出进行分组, 分组中是匹配值的数据行。 Group BY 子句支持任意表达式, 包括指定列名或列序号(从1开始)