Run the following statement to export the query result of Hive data:
insert overwrite local directory "/tmp/out/" row format delimited fields terminated by "\t" select * from table;