Ya Its working but what if i am using :- select A.`sepalen`, A.`sepalwidth`, A.`patelen`, A.`patelwidth`, A.class from dfs.tmp.`copydata.csv` as A;
why my last column data showing blank? And One more thing See my csv file:- sepalen,sepalwidth,patelen,patelwidth,class 5.1,3.5,1.4,Iris-setosa,0.2 4.9,3,1.4,Iris-setosa,0.2 4.7,3.2,1.3,Iris-setosa,0.2 4.6,3.1,1.5,Iris-setosa,0.2 5,3.6,1.4,Iris-setosa,0.2 5.4,3.9,1.7,Iris-setosa,0.4 4.6,3.4,1.4,Iris-setosa,0.3 5,3.4,1.5,Iris-setosa,0.2 4.4,2.9,1.4,Iris-setosa,0.2 4.9,3.1,1.5,Iris-setosa,0.1 5.4,3.7,1.5,Iris-setosa,0.2 4.8,3.4,1.6,Iris-setosa,0.2 This is my previous file. Now if i add comma after class Check this new file. sepalen,sepalwidth,patelen,patelwidth,class, 5.1,3.5,1.4,Iris-setosa,0.2 4.9,3,1.4,Iris-setosa,0.2 4.7,3.2,1.3,Iris-setosa,0.2 4.6,3.1,1.5,Iris-setosa,0.2 5,3.6,1.4,Iris-setosa,0.2 5.4,3.9,1.7,Iris-setosa,0.4 4.6,3.4,1.4,Iris-setosa,0.3 5,3.4,1.5,Iris-setosa,0.2 4.4,2.9,1.4,Iris-setosa,0.2 4.9,3.1,1.5,Iris-setosa,0.1 5.4,3.7,1.5,Iris-setosa,0.2 4.8,3.4,1.6,Iris-setosa,0.2 And Fire this query:- select A.`sepalen`, A.`sepalwidth`, A.`patelen`, A.`patelwidth`, A.class from dfs.tmp.`copydata.csv` as A; then the output is show fine. but if the comma is not there in then the last column data showing blank. Is this a bug ?? ...................... Thanks & Regards *Sanjiv Kumar*
