使用hivevar
#!/bin/bash
e_date=`date -d "$n_date " +%Y-%m-%d`" 00:00:00"
s_date=`date -d "$n_date -1day" +%Y-%m-%d`" 00:00:00"
name='insp'
hive -hivevar start_time=$s_date -hivevar dbname=$name -hivevar end_time=$e_date -f exec.sql
hive 执行外部sql hive -f xxx.sql