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