drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abhishek Girish <abhishek.gir...@gmail.com>
Subject Re: Last Column showing blank in csv file
Date Thu, 01 Dec 2016 03:36:33 GMT
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 <lclayton@maprtech.com> 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 <ktrsanjiv@gmail.com> 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 <ktrsanjiv@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 <ktrsanjiv@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 <ktrsanjiv@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*
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message