vya Gehlot [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 semina
t;
> I'll try this in a Windows machine in the meanwhile.
>
>
>
> From: Divya Gehlot
> Sent: Wednesday, August 2, 2017 11:14:56 PM
> To: user@drill.apache.org
> Subject: Re: delimiter in column values
>
> Hi ,
> This is my output when run in sqlline
:56 PM
To: user@drill.apache.org
Subject: Re: delimiter in column values
Hi ,
This is my output when run in sqlline on Windows Embedded mode
0: jdbc:drill:zk=local> select * from
`dfs`.`installedsoftwares/ApacheDrill/apache-drill-1.10.0.tar/apache-drill-1.10.0/sample-da
|
> | ["colonedata4","coltwodata4","-33.8724176","151.2067579",""] |
> | ["colonedata5","coltwodata5","","",""] |
> | ["This, col6 dat
---+
9 rows selected (0.502 seconds)
0: jdbc:drill:schema=dfs.root> select columns[0] from `sample_data.csv`;
+---+
|EXPR$0 |
+---+
| Column1 |
| colonedata1
I don't believe the text reader in Drill is that advanced
> as to interpret the list of column headers across multiple lines, while
> the actual data is in a single line per row.
>
> Typically text data is in CSV (or other delimiters similar to the comma)
> and can have the firs
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<mailto:divya.htco...@gmail.com>]
Sent: Tu
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
> To: u
divya.htco...@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
Column
divya.htco...@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
Column
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
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 a String.
>
> Is t
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:div
13 matches
Mail list logo