大数据Spark “蘑菇云”行动第88课：Hive脚本、常用命令、having查询及变种实战
HiveScript.sql的脚本内容
show databases;
use default;
show tables;
select * from employees;
hive> !pwd
hive> ! /bin/echo "Hive on spark!"
hive> dfs -ls /
# hive -s -e "select * from employee" >> /usr/local/test.log
# hive -e "select * from employee"
hive -S -e "set" | grep warehouse
desc employee;
select name from (select name,sum(salary) as salarytotal from employee)
employeeforhaving加一个字段 性别 男、女
create table employeeforhaving (userid int, name string,address string,salary double,gender string)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'");
load data local inpath '/..../employee.txt int tables‘ employeeforhaving；
select gender form(select gender,sun(salary) as salarytotal from employeesforhaving group by gender ) subquery where
subquery.salarytotal >30000
SELECT gender ,SUM(salary) FROM employeesforhaving
GROUP BY gender
HAVING SUM(salary)> 30000
