使用set设置变量
hive> set name=lucy;
hive> set name;
name=lucy
hive> select * from employee where name='${hiveconf:name}';
Total jobs = 1
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there's no reduce operator
Starting Job = job_1471442913162_0001, Tracking URL = http://ubuntu:8088/proxy/application_1471442913162_0001/
Kill Command = /app/bigdata/hadoop-2.7.2/bin/hadoop job -kill job_1471442913162_0001
Hadoop job information for Stage-1: number