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* > >
