1、E1010 14:22:41.093611 3181 impalad-main.cc:90] Impalad services did not start correctly, exiting. Error: Duplicate registration of subscriber: slave1:22000
State Store Subscriber did not start up.
杀掉statestored,然后重启
2、
from_utc_timestamp(from_unixtime(cast((1421719219938 / 1000) as bigint)), 'HKT') --时间转换成UTC+8时区
from_unixtime(unix_timestamp(from_utc_timestamp(from_unixtime(cast((1421719219938 / 1000) as bigint)), 'HKT')),'yyyyMMddHH') ; --变换格式
3、group by、having直接跟函数表达式别名,不能跟函数
4、select cast(1.9 as bigint);
得1,在mysql\oracle中得2