Re: Multi char csv delimiter

[Arina Yelchiyeva]

Hi Matthias,

Attachments are not supported on the mailing list, please include text 
describing your configuration.

Kind regards,
Arina

> On Jun 24, 2019, at 2:21 PM, Rosenthaler Matthias (PS-DI/ETF1.1) 
>  wrote:
> 
> Hi,
>  
> It seems that multi char delimiter “\n\r” is not supported for csv format 
> drill 1.16.
> The documentation mentions it should work, but it does not work for me. It 
> always says “invalid JSON syntax” if I try to change the storage plugin 
> configuration.
>  
> 
>  
> Mit freundlichen Grüßen / Best regards 
> 
> Matthias Rosenthaler
> 
> Powertrain Solutions, Engine Testing (PS-DI/ETF1.1) 
> Robert Bosch AG | Robert-Bosch-Straße 1 | 4020 Linz | AUSTRIA | www.bosch.at 
>  
> Tel. +43 732 7667-479 | matthias.rosentha...@at.bosch.com 
>  
> 
> Sitz: Robert Bosch Aktiengesellschaft, A-1030 Wien, Göllnergasse 15-17 , 
> Registergericht: FN 55722 w HG-Wien
> Aufsichtsratsvorsitzender: Dr. Uwe Thomas; Geschäftsführung: Dr. Klaus Peter 
> Fouquet
> DVR-Nr.: 0418871- ARA-Lizenz-Nr.: 1831 - UID-Nr.: ATU14719303 - Steuernummer 
> 140/4988

Re: Multi char csv delimiter

[Paul Rogers]

Hi Matthias,

Field delimiters, quotes and quote escapes can be only one character. The line 
delimiter can be multi.

Are you setting the line delimiter?

- Paul

Sent from my iPhone

> On Jun 24, 2019, at 12:10 PM, Arina Yelchiyeva  
> wrote:
> 
> Hi Matthias,
> 
> Attachments are not supported on the mailing list, please include text 
> describing your configuration.
> 
> Kind regards,
> Arina
> 
>> On Jun 24, 2019, at 2:21 PM, Rosenthaler Matthias (PS-DI/ETF1.1) 
>>  wrote:
>> 
>> Hi,
>> 
>> It seems that multi char delimiter “\n\r” is not supported for csv format 
>> drill 1.16.
>> The documentation mentions it should work, but it does not work for me. It 
>> always says “invalid JSON syntax” if I try to change the storage plugin 
>> configuration.
>> 
>> 
>> 
>> Mit freundlichen Grüßen / Best regards 
>> 
>> Matthias Rosenthaler
>> 
>> Powertrain Solutions, Engine Testing (PS-DI/ETF1.1) 
>> Robert Bosch AG | Robert-Bosch-Straße 1 | 4020 Linz | AUSTRIA | www.bosch.at 
>>  
>> Tel. +43 732 7667-479 | matthias.rosentha...@at.bosch.com 
>>  
>> 
>> Sitz: Robert Bosch Aktiengesellschaft, A-1030 Wien, Göllnergasse 15-17 , 
>> Registergericht: FN 55722 w HG-Wien
>> Aufsichtsratsvorsitzender: Dr. Uwe Thomas; Geschäftsführung: Dr. Klaus Peter 
>> Fouquet
>> DVR-Nr.: 0418871- ARA-Lizenz-Nr.: 1831 - UID-Nr.: ATU14719303 - Steuernummer 
>> 140/4988
> 

Re: Multi char csv delimiter

[Khurram Faraaz]

Hi Matthias,

Like Paul mentioned, that information with examples can be found here.
Our documentation mentions that, "As of Drill 1.8, Drill supports
multi-byte delimiters, such as \r\n. "
https://drill.apache.org/docs/plugin-configuration-basics/

Thanks,
Khurram

On Mon, Jun 24, 2019 at 2:31 PM Paul Rogers 
wrote:

> Hi Matthias,
>
> Field delimiters, quotes and quote escapes can be only one character. The
> line delimiter can be multi.
>
> Are you setting the line delimiter?
>
> - Paul
>
> Sent from my iPhone
>
> > On Jun 24, 2019, at 12:10 PM, Arina Yelchiyeva <
> arina.yelchiy...@gmail.com> wrote:
> >
> > Hi Matthias,
> >
> > Attachments are not supported on the mailing list, please include text
> describing your configuration.
> >
> > Kind regards,
> > Arina
> >
> >> On Jun 24, 2019, at 2:21 PM, Rosenthaler Matthias (PS-DI/ETF1.1)
>  wrote:
> >>
> >> Hi,
> >>
> >> It seems that multi char delimiter “\n\r” is not supported for csv
> format drill 1.16.
> >> The documentation mentions it should work, but it does not work for me.
> It always says “invalid JSON syntax” if I try to change the storage plugin
> configuration.
> >>
> >>
> >>
> >> Mit freundlichen Grüßen / Best regards
> >>
> >> Matthias Rosenthaler
> >>
> >> Powertrain Solutions, Engine Testing (PS-DI/ETF1.1)
> >> Robert Bosch AG | Robert-Bosch-Straße 1 | 4020 Linz | AUSTRIA |
> www.bosch.at 
> >> Tel. +43 732 7667-479 | matthias.rosentha...@at.bosch.com  matthias.rosentha...@at.bosch.com>
> >>
> >> Sitz: Robert Bosch Aktiengesellschaft, A-1030 Wien, Göllnergasse 15-17
> , Registergericht: FN 55722 w HG-Wien
> >> Aufsichtsratsvorsitzender: Dr. Uwe Thomas; Geschäftsführung: Dr. Klaus
> Peter Fouquet
> >> DVR-Nr.: 0418871- ARA-Lizenz-Nr.: 1831 - UID-Nr.: ATU14719303 -
> Steuernummer 140/4988
> >
>
>