Re: Does drill recognize new line correctly?

2016-01-06 Thread Stefán Baxter
gt; Returns 1 record ("test value") > > Thank you. > > -- > Miura, Masahide > > > -Original Message- > From: Stefán Baxter [mailto:ste...@activitystream.com] > Sent: Wednesday, January 06, 2016 4:54 PM > To: user > Subject: Re: Does drill re

Re: Does drill recognize new line correctly?

2016-01-06 Thread Peder Jakobsen | gmail
Hi, if you are working in Unix, use *iconv* to remove newlines, and other things like BOMS, converting to UTF-8 etc. Perhaps Google "iconv remove newlines from csv"..? iconv is quick, you can process Gibabytes of nested csv files in minutes. If you are using Windows, I'm not sure. Peder On

RE: Does drill recognize new line correctly?

2016-01-06 Thread masahide.miura
llo | +++ 1 row selected (0.228 seconds) it can't find {a: 7, b: "hello \ngoodbye"} record. Thank you. -- Miura, Masahide -Original Message- From: Jacques Nadeau [mailto:jacq...@dremio.com] Sent: Thursday, January 07, 2016 1:29 AM To: user Subject: Re: Does drill

RE: Does drill recognize new line correctly?

2016-01-06 Thread Jacques Nadeau
gt; From: Jacques Nadeau [mailto:jacq...@dremio.com] > Sent: Thursday, January 07, 2016 1:29 AM > To: user > Subject: Re: Does drill recognize new line correctly? > > For CSV: > > Drill doesn't currently support newlines within a csv record. The reason > has to do with supp

Re: Does drill recognize new line correctly?

2016-01-05 Thread Stefán Baxter
Hi, I'm not the right person to give you an answer from the Drill perspective but is it possible that your JSON serializer is not escaping characters that should be escaped? please see: -