本文更新Phoenix相关实践总结:
时间戳->时间
select count(uid),substr(to_char(CONVERT_TZ(to_date(to_char(time,’ '),‘s’), ‘UTC’, ‘Asia/Shanghai’),‘yyyy-MM-dd HH:mm:ss’),0,10) as format_time from xaas.user_module_tdl group by format_time;
保存搜索结果
!record
将phoenix中一列的相同数值批量修改:
upsert into xaas.user(uid,channel_id,gender) select uid,channel_id,1 from xaas.user where gender is null;
phoenix 删除数据
delete from xaas.user where gps_lat is null