I already pasted the csv file. Just copy and save it as csv. I am also attaching csv file. And the query is same as i mention above.
select A.`sepalen`, A.`sepalwidth`, A.`patelen`, A.`patelwidth`, A.class from dfs.tmp.`copydata.csv` as A; On Mon, Nov 28, 2016 at 6:30 PM, Sanjiv Kumar <ktrsan...@gmail.com> wrote: > 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* > -- ...................... Thanks & Regards *Sanjiv Kumar*
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