工作日志: hive统计指标

hive生产环境初探

查询某个分区的数据量, 并测试hive的分区函数

select count(*) from activity where year=2015 and month=7 and day=1

select distinct from_unixtime(cast(occur_time/1000 as BIGINT),'yyyyMMdd') occur_time
from activity where year=2015 and month=7 and day=1

手贱误删除了生产上的activity表的恢复过程