how to export hive into a csv or txt in a big data, the data are more than 10000, and i use hue browser to export it.
i already tried insert overwrite local directory code, but it didn't work
Asked
Active
Viewed 1,110 times
-2
-
Possible duplicate of [How to export a Hive table into a CSV file?](https://stackoverflow.com/questions/17086642/how-to-export-a-hive-table-into-a-csv-file) – vikrant rana Jul 04 '19 at 06:49
2 Answers
1
INSERT OVERWRITE LOCAL DIRECTORY '/tmp/dir/file1'
ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
SELECT * from tablename;
come out of hive cli
go to this /tmp/dir/ location
cat file1/* > file1.csv
zip file1 file1.csv
winscp it to windows and enjoy :)
Sagar Morakhia
- 777
- 6
- 13
-
-
Insert overwrite can be written in hue. Once the query is completed km hue, then go to Unix cli to check the folder – Sagar Morakhia Jul 04 '19 at 02:53
-
-
Change the name as in?? You can put whatever location you want to. – Sagar Morakhia Jul 04 '19 at 03:13
-
i've tried to use the code above, but it was error thee statement is : Error while compiling statement:FAILED: ParseException line 2:43 cannot recognize input near ',' 'select''*'in statement – Rimba Frida Jul 04 '19 at 07:03
-
It ran for me fine. Can you check if there is any junk character while you're copy-pasting it. If possible, type in everything manually in hive cli and you should be able to run successfully. – Sagar Morakhia Jul 04 '19 at 07:10
-
okay, it works. but i still can't open /tmp/dir/ location . how should i do? – Rimba Frida Jul 04 '19 at 07:45
-
Apologies I cannot spoon feed you on everything. Chrck my answer and try to figure it out. – Sagar Morakhia Jul 04 '19 at 07:48
-
okay, thank you for your answer. but i stll can't open my directory – Rimba Frida Jul 05 '19 at 07:00
0
You can query your data from the command line as such:
hive -e 'select x from table1' > /your/directory/data.csv
Refer to this solution for more info:
skhan
- 199
- 10