impala常用

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(( / ) as bigint)), 'HKT')  --时间转换成UTC+8时区
     from_unixtime(unix_timestamp(from_utc_timestamp(from_unixtime(cast(( / ) as bigint)), 'HKT')),'yyyyMMddHH') ; --变换格式
           

3、group by、having直接跟函数表达式别名，不能跟函数

4、

select cast(1.9 as bigint);

得1，在mysql\oracle中得2