How will you consume CSV file into the Hive warehouse using built SerDe?
- 1 Answers
- 893 Views
- I also Faced
- E-Mail Answers
Answer Posted / Poonam Chaubey
To consume a CSV file into the Hive warehouse using a built-in SerDe (Serializer/Deserializer), follow these steps: 1. Create an external table with the desired structure and location. 2. Set the serialization library property (hive.serde2.binary.version) to '1.0' or '1.1'. 3. Use the COMMA_SERDE for CSV files, which is a built-in SerDe in Hive.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Where does the data of a Hive table gets stored?
What is the stable version of Hive ?
Can We Change settings within Hive Session? If Yes, How?
When to choose "External Table" in Hive?
What are the different types of tables available in Hive?
How can I delete the above index named index_bonuspay?
When we are using queries instead of scripting?
How to skip header rows from a table in Hive?
When to use explode in Hive?
What is a Hive variable? What for we use it?
