How can data be exported from a hive?

1 year ago

Olivia Parker

1 minute

Hive offers various ways to export data, with common methods including:

Export the query results to a specific directory using the INSERT OVERWRITE DIRECTORY statement, for example:

INSERT OVERWRITE DIRECTORY '/path/to/output'
SELECT * FROM table_name;

Export the query results to the local file system by using the INSERT OVERWRITE LOCAL DIRECTORY statement, for example:

INSERT OVERWRITE LOCAL DIRECTORY '/path/to/output'
SELECT * FROM table_name;

Use the INSERT INTO LOCAL DIRECTORY statement to insert the query results into the local file system, for example:

INSERT INTO LOCAL DIRECTORY '/path/to/output'
SELECT * FROM table_name;

Export the query results to another Hive table using the INSERT OVERWRITE TABLE statement, for example:

INSERT OVERWRITE TABLE new_table
SELECT * FROM table_name;

Export data using Hive’s export tool to other storage systems such as HDFS, Amazon S3, etc.