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