drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sanjiv Kumar <ktrsan...@gmail.com>
Subject Re: Last Column showing blank in csv file
Date Tue, 29 Nov 2016 06:10:10 GMT
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*

Mime
View raw message