hive数据导入导出

-- 从本地文件加载数据：
LOAD DATA LOCAL INPATH '/home/hadoop/input/ncdc/micro-tab/sample.txt' OVERWRITE INTO TABLE records;
load data local inpath '/home/hive/partitions/files' into table logs partition (dt='2017-08-01',country='GB');

-- 数据导出
beeline -u jdbc:hive2://ip:port -n username -p password --verbose=true --outputformat=dsv -e "
select * from table_name
" > table_name.dsv

-- 导出数据
insert overwrite local directory '/tmp/table_name/'
row format delimited fields terminated by ',' 
select * from table_name;

hive -e "
set mapred.job.queue.name=queue_name;
set hive.cli.print.header=true;
use db_name;
select * from table_name;" > table_name.txt