向Hive中传入变量的方式

use test;
 
---学生信息表
create table IF NOT EXISTS student(
sno bigint comment ‘学号‘ ,
sname string comment ‘姓名‘ ,
sage bigint comment ‘年龄‘ ,
pdate string comment ‘入学日期‘
)
COMMENT ‘学生信息表‘
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ‘\t‘
LINES TERMINATED BY ‘\n‘
STORED AS TEXTFILE;
 
LOAD DATA LOCAL INPATH
‘/home/users/root/testdata_student‘
INTO TABLE student;

name1 21 20130901
name2 22 20130901
name3 23 20130901
name4 24 20130901
name5 25 20130902
name6 26 20130902
name7 27 20130902
name8 28 20130902
name9 29 20130903
name10 30 20130903
name11 31 20130903
name12 32 20130904
name13 33 20130904

#!/bin/bash
tablename="student"
limitcount="8"
hive -S -e "use test; select * from ${tablename} limit ${limitcount};"

#!/bin/bash
tablename="student"
limitcount="8"
 
hive -S     -hiveconf enter_school_date="20130902"     -hiveconf min_age="26"     -e     "    use test;         select * from ${tablename}         where             pdate=‘${hiveconf:enter_school_date}‘             and             sage>‘${hiveconf:min_age}‘         limit ${limitcount};"

#!/bin/bash
 
hive -hiveconf enter_school_date="20130902" -hiveconf min_ag="26" -f testvar.sql

use test;
select * from student
where
pdate=‘${hiveconf:enter_school_date}‘
and
sage > ‘${hiveconf:min_ag}‘
limit 8;

#!/bin/bash
hive -f testvar.sql

use test;
set hivevar:center_school_date="20130920";
set hivevar:min_age="26";
select * from student
where
pdate=‘${hivevar:enter_school_date}‘
and
sage > ‘${hivevar:min_ag}‘
limit 8;