shell 脚本执行带参数的hivesql

hive> select * from hbase_table_1;
OK
1       zhangsan
2       lisi

hive> desc hbase_table_1;
OK
key                     int                                         
value                   string 

hive> set zzz=5;
hive> set zzz;
zzz=5
hive> set system:xxx=5;
hive> set system:xxx;
system:xxx=5
hive> set system:yyy=${system:xxx};
hive> set system:yyy;
system:yyy=5
hive> set go=${hiveconf:zzz};
hive> set go;
go=5
hive> set a=1;
hive> set b=a;
hive> set b;
b=a
hive> set c=${hiveconf:${hiveconf:b}};
hive> set c;
c=1

[root@zgg ~]# cat test.sh
table="hbase_table_1"
hive -e "desc $table"

[root@zgg ~]# sh test.sh
key                     int                                         
value                   string     

[root@zgg ~]# hive --hiveconf a=1 -e 'select * from hbase_table_1 where key=${hiveconf:a};'
....
1       zhangsan

[root@zgg ~]# cat test.sql
select * from hbase_table_1 where key=${hiveconf:b};

[root@zgg ~]# hive --hiveconf b=2 -f test.sql
....
2       lisi

[root@zgg ~]# hive --hivevar a=1 -e 'select * from hbase_table_1 where key=${hivevar:a};'
....
1       zhangsan

[root@zgg ~]# cat test.sql
select * from hbase_table_1 where key=${hivevar:b};

[root@zgg ~]# hive --hivevar b=2 -f test.sql
....
2       lisi

[root@zgg ~]# hive -d a=1 -e 'select * from hbase_table_1 where key=${a};'
....
1       zhangsan

[root@zgg ~]# cat test.sql
select * from hbase_table_1 where key=${b};

[root@zgg ~]# hive -d b=2 -f test.sql
....
2       lisi