语法格式:
INSERT OVERWRITE [LOCAL] DIRECTORY directory1
[ROW FORMAT row_format]
select_statement1;
注意 : 加local : 导入到本地 ,不加local --> 导入到 hdfs
例:将查询到的结果保存到本地 , 字段之间以\t
分隔
INSERT OVERWRITE LOCAL DIRECTORY "/opt/data/"
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
select name ,age,gender from student;