Hello Yes you are right. select * from `tmp.csv` Is Working fine, but if select column then the last column data showing blank. Run this query:- select A.`sepalen`, A.`sepalwidth`, A.`patelen`, A.`patelwidth`, A.class from dfs.tmp.`copydata.csv` as A;
If you run this query you will get last column data as blank. On Wed, Nov 30, 2016 at 11:15 AM, Sanjiv Kumar <ktrsan...@gmail.com> wrote: > I am using latest version 1.8 and in window 10 operating system. > > On Tue, Nov 29, 2016 at 11:40 AM, Sanjiv Kumar <ktrsan...@gmail.com> > wrote: > >> 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* >> > > > > -- > ...................... > Thanks & Regards > *Sanjiv Kumar* > -- ...................... Thanks & Regards *Sanjiv Kumar*