drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Khurram Faraaz <kfar...@maprtech.com>
Subject Re: Last Column showing blank in csv file
Date Mon, 28 Nov 2016 19:07:59 GMT
Please share (attach) your CSV data files here.
Also please share your exact queries and the actual output that Drill
returns to you. That way someone here can take a look.

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

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