hive sql 每几分钟汇集

sql:

select year(dateday),month(dateday),day(dateday),hour(timeday),floor(minute(timeday)/10),avg(indexValue) from t_ovo_host_performance where dateday >='2016-06-11' and dateday <='2016-07-11' and ip='192.168.122.1' and indexName='CPU Usage rate(%)' group by year(dateday),month(dateday),day(dateday),hour(timeday),floor(minute(timeday)/10);

要求 dateday为yyyy-MM-dd HH:mm:ss 或者 yyyy-MM-dd 或者HH:mm:ss 不然，hour等函数得到的值是null.

group by 后面的字段要与select中非组函数的字段一致。