Question: how to export data from hive to text file?
Answer: Step 1: Create Output directory. mkdir /root/local_bdp/posts/export-hive-data-into-file/output. Step 2: Go to hive CLI and execute the following code. INSERT OVERWRITE LOCAL DIRECTORY '/root/local_bdp/posts/export-hive-data-into-file/output' ROW FORMAT DELIMITED. FIELDS TERMINATED BY ':' SELECT * FROM bdp.