Okay, I could reproduce the issue on Windows. 0: jdbc:drill:zk=local> select A.sepalen, A.sepalwidth, A.patelen, A.patelwidth, A.class from dfs.`/drill/tmp.csv` as A; +----------+-------------+----------+--------------+--------+ | sepalen | sepalwidth | patelen | patelwidth | class | +----------+-------------+----------+--------------+--------+ | 5.1 | 3.5 | 1.4 | Iris-setosa | | | 4.9 | 3 | 1.4 | Iris-setosa | | | 4.7 | 3.2 | 1.3 | Iris-setosa | | | 4.6 | 3.1 | 1.5 | Iris-setosa | | | 5 | 3.6 | 1.4 | Iris-setosa | | | 5.4 | 3.9 | 1.7 | Iris-setosa | | | 4.6 | 3.4 | 1.4 | Iris-setosa | | | 5 | 3.4 | 1.5 | Iris-setosa | | | 4.4 | 2.9 | 1.4 | Iris-setosa | | | 4.9 | 3.1 | 1.5 | Iris-setosa | | | 5.4 | 3.7 | 1.5 | Iris-setosa | | | 4.8 | 3.4 | 1.6 | Iris-setosa | | +----------+-------------+----------+--------------+--------+ 12 rows selected (0.277 seconds)
I'll get back if and once I have a workaround / solution. On Wed, Nov 30, 2016 at 7:36 PM, Abhishek Girish <[email protected]> wrote: > I forgot to mention that, the other query works too. > > > select A.sepalen, A.sepalwidth, A.patelen, A.patelwidth, A.class from > dfs.tmp.`tmp.csv` as A; > +----------+-------------+----------+--------------+--------+ > | 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 | > +----------+-------------+----------+--------------+--------+ > 12 rows selected (0.31 seconds) > > > On Wed, Nov 30, 2016 at 8:15 AM, Leon Clayton <[email protected]> > wrote: > >> Are we sure there is no hidden characters on the end of the one or more >> lines. thinking <ctrl-m> ? >> >> try a dos2unix on the file to check this theory out. >> >> >> > On 30 Nov 2016, at 10:45, Sanjiv Kumar <[email protected]> wrote: >> > >> > 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 <[email protected]> >> 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 <[email protected]> >> >> 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 <[email protected]> >> >>> 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* >> >> >
