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 10:45:50 GMT
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