Thanks. What version of Drill are you using ? And is this on Linux ? 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* >