hive sql查询数据导出到本地目录/hdfs

舟率率 8/4/2023 sparkhive

-- 导出到本地文件系统
insert overwrite local directory '/home/mydir/mydir/'
    ROW FORMAT DELIMITED
    FIELDS TERMINATED BY '\t'
    LINES TERMINATED BY '\n'
select *
from test;

-- 导出到HDFS中
insert overwrite directory '/home/mydir/mydir/'
    ROW FORMAT DELIMITED
    FIELDS TERMINATED BY '\t'
    LINES TERMINATED BY '\n'
select *
from test;

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15