Category: Hive

Export Hive data into CSV file

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;

Permanent link to this article: https://blog.openshell.in/2013/01/export-hive-data-into-csv-file/