impala语句

1、impala语句放进shell里(.sh文件)

2、输入crontab -e 

3、在文件内输入 :00 01 * * * 路径/xxx.sh (每天凌晨一点执行xxx脚本)

4、crontab -l是显示当前crontab任务,注意:千万别手残,输入crontab -r,会删除该节点你账号下所有的crontab任务

hadoop fs -mkdir /user/hive/warehouse/dw_liuff.db/lj_name
hadoop fs -put ljname.txt /user/hive/warehouse/dw_liuff.db/lj_name

hadoop fs -rm  -r  /user/hive/warehouse/dw_liuff.db/lj_name

hdfs dfs -ls /user/hive/warehouse/dw_liuff.db/

load data inpath '/user/hive/warehouse/dw_liuff.db/lj/lj.txt' into table lj_name;

create table lj_name(id string,name string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE

原文地址:https://www.cnblogs.com/liuffblog/p/13599844.html