Hive to HDFS transfer

Question

How can you transfer data from Hive to HDFS?

Answer 1

Suppose you want to transfer the data from a hive table "sales" to you HDFS directory "/temp" then you can use the following command

hive> insert overwrite directory '/temp' select * from sales;

Answer 2

Hive does not store data. Hive is Sql like interface on top of HDFS and used for data processing. Hive creates MR Jobs from SQL.

Data resides in HDFS and Hive created MR jobs reads the data and stored it back in HDFS

Comments

Yup agreed. Hive does not store data. Maybe what @Data_Nerd wanted to say is, for dumping the data back into HDFS, after processing, that command is used.