Regarding data import into hive from csv
I have issue in importing the data from dataframe converted to csv then uploading it into hive but its not loading properly .
My procedure:
1st I took a Data frame from database and converted into a csv ,which has 343 columns and 24 lakhs rows
2nd I took the csv file to hive and I loaded the data to hive using load data code to table which i created directly by connect the hive to same database .
this is what ,I am doing.
In this case , my issue is for some rows it taking proper values but for some is null or 0.
then i took a sample of 5 rows and I checked manually then i find out in csv file some rows there are some extra comma .so I manually removed and tried ,it worked but this cant be happening in real-time .
so pls help me on this by giving some suggestion.

