For my sample dataset as you advised I surrounded with single columns also with quotes and the results are as below : col_Column1 Column2 Column3 Column4 Column5 "Chifley" "coltwodata5" "" "" "" "colonedata1" "coltwodata1" "-35.924476" "138.5987123" "" "colonedata2" "coltwodata2" "-27.4372536" "153.0304583" "137" "colonedata4" "coltwodata4" "-33.8724176" "151.2067579" "" "colonedata5" "coltwodata5" "" "" "" "This col6 data" "coltwodata6" "-33.869732" "151.2055553" "This col7 data yes." "coltwodata7" "1.2845045" "103.8482739" colonedata3" "coltwodata3" "-35.2793885" "149.1233503" "134"
Thanks, Divya On 1 August 2017 at 22:39, Kunal Khatua <kkha...@mapr.com> wrote: > I think you need quotes around the single word datasets as well, because > the quotes act as String delimiters and help in indicating the start and > end of a String. > > Is there a reason why the single word strings cannot be in quotes as well? > > -----Original Message----- > From: Divya Gehlot [mailto:divya.htco...@gmail.com] > Sent: Tuesday, August 01, 2017 3:04 AM > To: user@drill.apache.org > Subject: delimiter in column values > > Hi, > I have data set which has delimeter in first column value when I read the > data set It provides the output below : > > col_Column1 > Column2 > Column3 > Column4 > Column5 > > "This col6 data" coltwodata6 -33.869732 151.2055553 "This col7 data yes." > coltwodata7 1.2845045 103.8482739 Chifley coltwodata5 > colonedata1 coltwodata1 -35.924476 138.5987123 > colonedata2 coltwodata2 -27.4372536 153.0304583 137 > colonedata3 coltwodata3 -35.2793885 149.1233503 134 > colonedata4 coltwodata4 -33.8724176 151.2067579 > colonedata5 coltwodata5 > > > > How can I read the column1 values as is without getting split into two > columns for instance the Column values should be > Column1 > colonedata1, > colonedata2, > colonedata3, > colonedata4, > colonedata5, > "This, col6 data" > "This, col7 data" > Chifley, > > Appreciate the help ! > > Thanks , > Divya >