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 Select the correct answer from above options

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: