使用shell将hdfs上的数据导入到hive表中

days=($(seq 20150515 20150517))

hours=()
for (( i=0; i<=23;++i))
do
  if [ $i -lt 10 ]; then
     hours[i]="0"$i
  else
     hours[i]=$i
  fi
done


for day in ${days[*]}
do
    for hour in ${hours[*]}
    do
		  
		date_dir=${day}${hour}0000

		hadoop fs -test -e hdfs://namenode:8020/test/output/bjlt_bak/${date_dir}/part-r-00000
    if [ $? -eq 0 ] ;then
       hql="LOAD DATA  INPATH ""'hdfs://namenode:8020/test/output/bjlt_bak/"${date_dir}"/part-r-00000'  INTO TABLE middle_table.game_match_result"
       hive -e "${hql}"      
	echo ${hql}
    else
      echo "${date_dir}/part-r-00000 is not exist Or Zero bytes in size"
    fi
	done
done

hive -e "${hql}" 

上边一行代码中的双引号一定要加上,否则会报<EOF>的错误