CCA 175 Real Time Exam Scenario 10 | Read CSV File | Write in HIVE Table

Data Description
1. All the category records are stored at /user/spark/dataset/retail_db/categories
2. Data is in text format comma separated

Output Requirement
1. Create a metastore table named 'categories_partitioned'
2. Table should only contain category_id, category_name
3. Save all categories in metastore table categories_partitioned

Download the sample data from our Github repository.

🔵 COMPLETE APACHE SPARK TUTORIAL PLAYLIST 🔵

🔵 WORKING WITH STRUCTURED DATA IN APACHE SPARK 🔵

🔵 WORKING WITH DATE COLUMNS IN APACHE SPARK 🔵

🔵 WORKING WITH WINDOWING, AGGREGATE FUNCTIONS IN APACHE SPARK 🔵

[kaelo]

I am using Itversity terminal to do this and I get an errow when I try and run

[rajantawade]

hi,
Output Requirement does not tell which column should the table be partitioned by

[alokranjan]

Hi, in the question you have mentioned text file but you are reading it as CSV, is it allowed during the exam?