RE: delimiter in column values

[mailto:divya.htco...@gmail.com] Sent: Sunday, August 06, 2017 7:41 PM To: user@drill.apache.org Subject: Re: delimiter in column values Hi, Please find the response inline : 1. Your delimiter is a pipe in this example, and not a comma as originally seen in the attached file. For such seminars, either

Re: delimiter in column values

03","134"] | > | ["colonedata4","coltwodata4","-33.8724176","151.2067579",""] | > | ["colonedata5","coltwodata5","","",""] | >

RE: delimiter in column values

---+ 9 rows selected (0.502 seconds) 0: jdbc:drill:schema=dfs.root> select columns[0] from `sample_data.csv`; +---+ |EXPR$0 | +---+ | Column1 | | colonedata1

Re: delimiter in column values

data is in CSV (or other delimiters similar to the comma) > and can have the first line representing a header. > > Also, I'm not sure if there was ever an option introduced to allow > skipping of the initial set of lines within a text file being read. > > > -Origina

Re: delimiter in column values

elimiters similar to the comma) and can have the first line representing a header. Also, I'm not sure if there was ever an option introduced to allow skipping of the initial set of lines within a text file being read. -Original Message- From: Divya Gehlot [mailto:divya.htco...@gmail.com

Re: delimiter in column values

header. > > Also, I'm not sure if there was ever an option introduced to allow > skipping of the initial set of lines within a text file being read. > > > -Original Message- > From: Divya Gehlot [mailto:divya.htco...@gmail.com] > Sent: Tuesday, August 01, 2017 7:06 PM

RE: delimiter in column values

...@gmail.com] Sent: Tuesday, August 01, 2017 7:06 PM To: user@drill.apache.org Subject: Re: delimiter in column values 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 "Ch

RE: delimiter in column values

...@gmail.com] Sent: Tuesday, August 01, 2017 7:06 PM To: user@drill.apache.org Subject: Re: delimiter in column values 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 "Ch

Re: delimiter in column values

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"

Re: delimiter in column values

Hi , I received the data in the format which I posted . Thanks, Divya On 1 August 2017 at 22:39, Kunal Khatua 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

RE: delimiter in column values

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