How do I export data from Hive to a file?

2 years ago
Liam
1 minute

To export Hive data to a file, you can use the INSERT OVERWRITE statement in Hive along with HDFS commands. Here is an example:

  1. export data table
CREATE TABLE export_table AS SELECT * FROM your_table;
  1. Export the data to the Hadoop user directory.
hadoop fs -cp /user/hive/warehouse/export_table/* /user/hadoop/export_data/
  1. the location of the exported file
hadoop fs -get /user/hadoop/export_data/* /path/to/export_file/

In this way, the data from the Hive table is exported to a file in the local file system.

bannerAds