drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Leon Clayton <lclay...@maprtech.com>
Subject Re: Last Column showing blank in csv file
Date Wed, 30 Nov 2016 16:15:40 GMT
Are we sure there is no hidden characters on the end of the one or more lines. thinking <ctrl-m>
?

try a dos2unix on the file to check this theory out. 


> On 30 Nov 2016, at 10:45, Sanjiv Kumar <ktrsanjiv@gmail.com> wrote:
> 
> Hello
>      Yes you are right.  select * from `tmp.csv`
> Is Working fine, but if select column then the last column data showing
> blank.
> Run this query:-
> select A.`sepalen`, A.`sepalwidth`, A.`patelen`, A.`patelwidth`, A.class
> from dfs.tmp.`copydata.csv` as A;
> 
> If you run this query you will get last column data as blank.
> 
> On Wed, Nov 30, 2016 at 11:15 AM, 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*
>> 
> 
> 
> 
> -- 
> ......................
>  Thanks & Regards
>  *Sanjiv Kumar*


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