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...