SELECT count(0),TO_STRING(TO_LOCALTIME(time), ‘yyyy-MM-dd HH‘) FROM ‘[LOGFILEPATH]‘ group by TO_STRING(TO_LOCALTIME(time), ‘yyyy-MM-dd HH‘)
log parser
原文：http://www.cnblogs.com/Rannie/p/4372394.html
