1、查询hive
export HIVE_HOME=/data/apps/hive
export PATH=$PATH:/usr/local/bin:$HIVE_HOME/binhive -e "use DB;SELECT_SQL>redirect.txt
2、awk去重
cat file1.txt file2.txt |awk 'a[$0]++' |sort -u >redirect.txt
3、while循环、if判断
while read line;
do
initNum=10;
if [ $initNum -eq 1 ]
then
count1=$((count1+1));
fi
done < redirect.txt
4、数组循环
dateArr=('2012-11-20' '2012-11-21')
for filedate in ${dateArr[*]}
do
echo $filedate
done
5、方法调用
#方法定义
function tongjiFunc() {
filedate=`date -d "$1" +"%Y-%m-%d"`;}##调用tongjiFunc 2012-11-20
6、统计行数
wc -l
7、awk重复次数
awk '{arr[$0]++} END{ for (key in arr) print key,"-->",arr[key] }' e