loct
Reputation: 367
How can I export csv data from hadoop (through hive in hue) using delimiter other than the comma?
My question is in the title. In addition, hive CLI is not possible for my situation, with only the hive editor in the hue platform.
The reason why xlsx is not used is because only 30,000 records can be exported by xlsx.
Upvotes: 2
Views: 15406
Answers (1)
Kumar
Reputation: 928
Refer the below question. Lot of options are suggested by users.
How to export a Hive table into a CSV file?
Upvotes: 1
Related Questions
- how to export hive data to csv format with double quotes in beeline HDP
- Hive load CSV with commas in quoted fields
- Hive table delimited by comma and multiple spaces
- How to import a table with delimiter ";" into hive?
- Uploading/importing a .csv in Hue - specifying the correct delimiter, etc
- How to load CSV with different delimiter to a single Hadoop table
- Custom delimiter while exporting hive table to CSV from shell command line?
- How to import csv file into hive table when it has delimiter value, say comma, as a field value?
- How do I export a CSV file into Hive table with records value with comma?
- Import CSV file delimited by double quotes and comma into Hbase using Hive