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. ... View more