Hi , I received the data in the format which I posted .
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 >
