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 Wed, 30 Nov 2016 06:03:07 GMT
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 <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*
>

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