Like Khurram, I'm also not able to reproduce this issue.
My format plugin is defined as follows:
"csv": {
"type": "text",
"extensions": [
"csv"
],
"extractHeader": true,
"delimiter": ","
}
Query:
> select * from `tmp.csv`;
+----------+-------------+----------+--------------+--------+
| 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.244 seconds)
Data:
# cat tmp.csv
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
On Tue, Nov 29, 2016 at 9:45 PM, 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*
>
