Hive query output to file

Question

I run hive query by java code. Example:

"SELECT * FROM table WHERE id > 100"

How to export result to hdfs file.a

Answer 1

To directly insert the result of any hive query into HDFS file, try this command:

INSERT OVERWRITE DIRECTORY '/output/path/dir' SELECT * FROM table WHERE id > 100;

You can refer the following video tutorial which will clear all your doubts regarding Hadoop: