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 <[email protected]> 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 <[email protected]>
> 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 <[email protected]>
>> 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*
