I want to load the extracted data(without semi-colon, double-quote and comma) from this csv dataset into Hive table. I don't want to use any external programming language how it can be done?
INPUT BOOK-RATING.csv DATASET :
"User-ID;""ISBN"";""Book-Rating""",,
"276725;""034545104X"";""0""",,
"276726;""0155061224"";""5""",,
"276727;""0446520802"";""0""",,
"276729;""052165615X"";""3""",,
"276729;""0521795028"";""6""",,
"276733;""2080674722"";""0""",,
"276736;""3257224281"";""8""",,
"276737;""0600570967"";""6""",,
"276744;""038550120X"";""7""",,
"276745;""342310538"";""10""",,
AFTER LOADING INTO HIVE TABLE VIEW SHOULD BE IN 3 COLUMNS:
276725 034545104X 0
276726 0155061224 5
276727 0446520802 0
276729 052165615X 3
276729 0521795028 6
276733 2080674722 0
276736 3257224281 8
276737 0600570967 6
276744 038550120X 7
276745 342310538 10