hive> load data inpath 'hdfs:///usr/matrix/input/cdr_summ_imei_cell_info.csv' into table tcdr;
3、查询数据并将hive查询出来的数据导出到指定文件夹下
hive> insert overwrite local directory '/opt/modules/hive-1.2.1/cdp'
row format delimited fields terminated by ','
select *,drop_num/duration as cdp from tcdr order by cdp desc limit 1;
4、查看数据查询结果
[root@node1 ~]# cd /opt/modules/hive-1.2.1/cdp
[root@node1 cdp]# cat 000000_0