How do I output the results of a HiveQL query to CSV?

Question

I want to put my Results of a hiveql query into a CSV file. How can I do it? I tried doing this, but it didn’t work. insert overwrite directory '/download/output.csv' select goods from the table; Select the correct answer from above options

Answer 1

You are using the right command insert overwrite ,it is the best function to use to save data in a file, but it is saving data in HDFS directory.So, you will not find the data in your local csv file.To save the data in your Local machine you have to use the word “local” insert overwrite local directory '/download/output.csv' select goods from table; This will save the Data in your csv file. Hope this helps!