Use the following command used to export hive data into CSV file.
set hive.io.output.fileformat = CSVTextFile;
INSERT OVERWRITE LOCAL DIRECTORY ‘dir_path’ SELECT FIELD1, FIELD2, FIELD3 FROM TABLE1;
Jan 15
Export Hive data into CSV file
Permanent link to this article: https://blog.openshell.in/2013/01/export-hive-data-into-csv-file/