Hive数据导出方式

hive -S -e"select package_name,count(1) from test_tb group by package_name;"> grp_app_id.dat

 

SET hive.exec.compress.output=false
SET mapreduce.output.fileoutputformat.compress=false

INSERT OVERWRITE LOCAL DIRECTORY '/usr/tmp/user'

SELECT * FROM test_tb WHERE DT='2015-11-01' LIMIT 100;

 

INSERT OVERWRITE LOCAL DIRECTORY '/usr/tmp/user'

row format delimited fields terminated by '@@@'

STORED AS text

SELECT uid,final_login_tim FROM test_tb WHERE DT='2016-03-01' LIMIT 100;