Hive: Import and Export data from HDFS and Local Directory

Import Data from Local Directory:

hive>LOAD DATA LOCAL INPATH '/local/path' OVERWRITE INTO TABLE table-name;

OVERWRITE is optional in latest versions of hive . You can exclude it if you want to  append data in table.

Export Data to Local Directory:

hive>INSERT OVERWRITE LOCAL DIRECTORY '/local dir/path' SELECT * from table-name;

Import Data from HDFS  :

hive>LOAD DATA INPATH '/hdfs/path/to/file' OVERWRITE INTO TABLE tablename;

OVERWRITE is optional in latest versions of hive . You can exclude it if you want to  append data in table.

Export Data to HDFS:

hive>INSERT OVERWRITE DIRECTORY  /path/to/hdfs' SELECT * FROM tablename;