shell小案例
来源:互联网 发布:蒲城网络党校学员登录 编辑:程序博客网 时间:2024/06/05 00:40
#!/bin/bash
num=$(cat /path/to/a.pid)
kill -9 $num
else
echo "have no pid,make sure app have running!"
fi
cat tables|while read node do echo "node : $node" /usr/local/hive/bin/hive -e "describe $node" >> $node.txtawk '{print $1,$2","}' $node.txt>>$node.txt1echo "#!/bin/bash " >>$node.sh echo "source ../../config/set_env.conf" >>$node.sh echo "\$HIVE << EOF " >>$node.sh echo "drop table $node;" >>$node.sh echo "CREATE EXTERNAL TABLE $node(" >>$node.sh cat $node.txt1>>$node.sh echo ")">>$node.sh echo "ROW FORMAT DELIMITED FIELDS TERMINATED BY '\,' LINES TERMINATED BY '\n'">>$node.sh echo "STORED AS textfile ">>$node.sh echo "location '/user/hadoop/idap/base/';">>$node.sh echo "alter table $node set serdeproperties('serialization.null.format' = '');">>$node.sh #echo "LOAD DATA INPATH \"/user/hadoop/idap/base/$node.txt\" INTO TABLE $node; ">>$node.sh echo "exit;">>$node.sh echo "EOF">>$node.sh echo "if [ $? -ne 0 ];then">>$node.sh echo " exit 2">>$node.sh echo "fi">>$node.sh rm $node.txtrm $node.txt1echo "================"done
if [ -f /path/to/a.pid ];
num=$(cat /path/to/a.pid)
kill -9 $num
else
echo "have no pid,make sure app have running!"
fi
cat tables|while read node do echo "node : $node" /usr/local/hive/bin/hive -e "describe $node" >> $node.txtawk '{print $1,$2","}' $node.txt>>$node.txt1echo "#!/bin/bash " >>$node.sh echo "source ../../config/set_env.conf" >>$node.sh echo "\$HIVE << EOF " >>$node.sh echo "drop table $node;" >>$node.sh echo "CREATE EXTERNAL TABLE $node(" >>$node.sh cat $node.txt1>>$node.sh echo ")">>$node.sh echo "ROW FORMAT DELIMITED FIELDS TERMINATED BY '\,' LINES TERMINATED BY '\n'">>$node.sh echo "STORED AS textfile ">>$node.sh echo "location '/user/hadoop/idap/base/';">>$node.sh echo "alter table $node set serdeproperties('serialization.null.format' = '');">>$node.sh #echo "LOAD DATA INPATH \"/user/hadoop/idap/base/$node.txt\" INTO TABLE $node; ">>$node.sh echo "exit;">>$node.sh echo "EOF">>$node.sh echo "if [ $? -ne 0 ];then">>$node.sh echo " exit 2">>$node.sh echo "fi">>$node.sh rm $node.txtrm $node.txt1echo "================"done
0 0
- shell小案例
- 小案例
- shell进度展示案例
- shell使用案例
- shell 命令案例
- shell 小数比较案例
- shell脚本学习案例
- shell脚本案例
- shell 编程案例整理
- shell---shell小例子
- css小案例 小demo
- SQL Server小案例
- plsq小案例
- smarty成功小案例
- 加载数据小案例
- 备用sql小案例
- div+css小案例
- 小案例走马灯
- poj3061 Subsequence 尺取法
- 计算打车费用
- HDU1251 统计难题 【Trie 树入门】
- 机器学习入门系列05,Classification: Probabilistic Generative Model(分类:概率生成模型)
- 冒泡排序 和 选择排序
- shell小案例
- IDEA+Maven 搭建spring-Spring Mvc-MyBatis环境
- Reverse Bits
- 私人订制docker化vim
- accelerated c++ 读书笔记--第十三章
- 【笔记】FhAdmin项目的sql语句
- Hadoop作业提交之客户端作业提交
- COGS 2085 Asm.Def的一秒
- 如何在Visual C++下调试运行C程序