Hive数据导出到外部,形成文件

1、hive -e "
SET hive.exec.compress.output=false;
insert overwrite directory ‘/home/data/’
row format delimited fields terminated by ‘,’
stored as textfile
select * from table_name;"
2、hive -e "select * from table_name“ > file_name