You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Jim Scott <js...@maprtech.com> on 2014/09/19 18:04:13 UTC
file format quote character
Is there a configuration option to specify the quote character for a file
format?
i.e. some fields are surrounded with " marks or some other quote character
Re: file format quote character
Posted by Ted Dunning <te...@gmail.com>.
Sounds like a quick JIRA. Go for it!
The other thing that will come up will be the escape convention (backslash
and doubling are the common options).
On Fri, Sep 19, 2014 at 9:49 AM, Jim Scott <js...@maprtech.com> wrote:
> It isn't explicitly a CSV file ... the file has ^ field separators and ~
> quote characters.
>
> I have this format definition, but I need a way to specify that the quote
> character is ~
> "nndb": {
> "type": "text",
> "extensions": [
> "txt"
> ]),
> "delimiter": "^"
> },
>
>
>
> On Fri, Sep 19, 2014 at 11:43 AM, Tomer Shiran <ts...@maprtech.com>
> wrote:
>
> > CSV file?
> >
> > On Fri, Sep 19, 2014 at 9:04 AM, Jim Scott <js...@maprtech.com> wrote:
> >
> > > Is there a configuration option to specify the quote character for a
> file
> > > format?
> > >
> > > i.e. some fields are surrounded with " marks or some other quote
> > character
> > >
> >
> >
> >
> > --
> > Tomer Shiran
> > VP Product Management | MapR Technologies | 650-804-8657
> >
>
Re: file format quote character
Posted by Jim Scott <js...@maprtech.com>.
It isn't explicitly a CSV file ... the file has ^ field separators and ~
quote characters.
I have this format definition, but I need a way to specify that the quote
character is ~
"nndb": {
"type": "text",
"extensions": [
"txt"
]),
"delimiter": "^"
},
On Fri, Sep 19, 2014 at 11:43 AM, Tomer Shiran <ts...@maprtech.com> wrote:
> CSV file?
>
> On Fri, Sep 19, 2014 at 9:04 AM, Jim Scott <js...@maprtech.com> wrote:
>
> > Is there a configuration option to specify the quote character for a file
> > format?
> >
> > i.e. some fields are surrounded with " marks or some other quote
> character
> >
>
>
>
> --
> Tomer Shiran
> VP Product Management | MapR Technologies | 650-804-8657
>
Re: file format quote character
Posted by Tomer Shiran <ts...@maprtech.com>.
CSV file?
On Fri, Sep 19, 2014 at 9:04 AM, Jim Scott <js...@maprtech.com> wrote:
> Is there a configuration option to specify the quote character for a file
> format?
>
> i.e. some fields are surrounded with " marks or some other quote character
>
--
Tomer Shiran
VP Product Management | MapR Technologies | 650-804-8657