csdnmrliu的博客

1.hive建表 1.1建内部表（文本） create table if not exists test.imsiBackFill( s1apid string, enodebid string, xdrsize int, failed int, success int) PARTITIONED BY( date_id string, ...

1. select语句 1.1 简单查询 注：最好不要使用 select * select * from test.imsiBackFill where date_id = 20180920 and hour = 10 limit 10; 1.2 统计行数 select count(1) from test.imsiBackFill where date_id = 2018092...

编写shell脚本自动化导出指定hql结果到csv文件并删除sql语句和关闭连接日志 1. hql文件准备 select a.enodebid as enodebid, sum(xdrsize) as totalXdrSize, sum(failed) as totalFailed, sum(success) as totalSuccess from test.i...