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 Mon, 28 Nov 2016 13:00:36 GMT
 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