Shell scripts run Hive SQL

#!/b

START=$(Date+%s);d Atebegin=`Date-D" $" "+%y%m%d"' DateEnd=`Date-D" $" "+%y%m%d"' Sdate=`Date-D"$datebegin-1 days" "+%y%m%d"` while["$datebegin"-le"$dateend" ] DoEcho$datebegin/usr/local/hivebi/bin/hive<<EOF--Hive SQL Like:drop TABLE IF EXISTS yourdb.yourtablename; EOF

datebegin= ' date-d ' $datebegin +1 Day "+%y%m%d"

Sdate= ' date-d ' $sdate +1 Day "+%y%m%d"

 Done END=$ (date +%s); Echo awk ' {print int ($1/3600): "Int ($1%3600/60)": "Int ($1%3600%60)} '

How to use:

chmod +x test. SH . /test. SH 20160505 20160506

Where--is the comment symbol in hive SQL.

Shell scripts run Hive SQL