use namespace dba_ns; #选定数据库
set user_write_ugi:hdfs://nmg01-xxxx-hdfs.dmop.xxxxx.com:54310/app/ecom/fcr/bigdata_dump/user_feature/=xx,xxxxxxx; #赋值:用户名,密码
insert overwrite directory 'hdfs://nmg01-xxxx-hdfs.dmop.xxxxx.com:54310/app/ecom/fcr/bigdata_dump/user_feature/{DATE}' # 到出数据到hdfs
row format delimited fields terminated by '\t' #在导出数据的时候来指定列之间的分隔符
select *
from db.userfeature
where event_day='{DATE}';