[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
03","134"] |
> | ["colonedata4","coltwodata4","-33.8724176","151.2067579",""] |
> | ["colonedata5","coltwodata5","","",""] |
>
---+
9 rows selected (0.502 seconds)
0: jdbc:drill:schema=dfs.root> select columns[0] from `sample_data.csv`;
+---+
|EXPR$0 |
+---+
| Column1 |
| colonedata1
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
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
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
...@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
...@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
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"
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
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
11 matches
Mail list logo