hive sql 每几分钟内统计一次

select
year(dateday),month(dateday),day(dateday),hour(timeday),floor(minute(timeday)/10),avg(indexValue)
 from table
 group by year(dateday),month(dateday),day(dateday),hour(timeday),floor(minute(timeday)/10);