小白上路喽,从命令行开始
show database;
use db_name;
show tables;
desc tb_name;
show functions;
desc function fc_name;
–执行hive sql脚本
hive -f script.sql
–设置mapreduce 队列(设置root,避免队列权限报错)
set mapreduce.job.queuename=root.default
–遇到的坑
1.timestamp类型日期加减1天
cast(from_unixtime(unix_timestamp(t.created_at) +/- 24*3600) as timestamp)
2.order by 支持使用别名,但不支持order by 1(运行不报错,但结果不准确)