Question: how to export data in excel from hive?
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. set hive. cli. print. header=true; INSERT OVERWRITE LOCAL DIRECTORY '/root/local_bdp/posts/export-hive-data-into-file/output' ROW FORMAT DELIMITED.