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;
Category: Hive
Permanent link to this article: https://blog.openshell.in/2013/01/export-hive-data-into-csv-file/