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 Wed, 30 Nov 2016 05:45:42 GMT
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