You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Andries Engelbrecht <ae...@maprtech.com> on 2015/03/12 19:07:33 UTC

Drill file encondig

Any place to set the file encoding for Drill?
(file.encoding)

There does not seem to be a parameter in sys.options.

Can only find
sun.jnu.encoding
file.encoding.pkg
sun.io.unicode.encoding

I am having some issues with certain files where I can query the text fields in sqlline and get a result with Cast VarChar, however if I try to apply a regexp_replace on the text field I get an error for some files.
(Encountered an illegal char on line 1, column 38: ‘’)

Thanks
—Andries

Re: Drill file encondig

Posted by Ted Dunning <te...@gmail.com>.
That would be an excellent enhancement!

On Thu, Mar 12, 2015 at 1:08 PM, Steven Phillips <sp...@maprtech.com>
wrote:

> Drill doesn't support encodings besides utf-8 for the text reader, I
> believe.
>
> On Thu, Mar 12, 2015 at 11:07 AM, Andries Engelbrecht <
> aengelbrecht@maprtech.com> wrote:
>
> > Any place to set the file encoding for Drill?
> > (file.encoding)
> >
> > There does not seem to be a parameter in sys.options.
> >
> > Can only find
> > sun.jnu.encoding
> > file.encoding.pkg
> > sun.io.unicode.encoding
> >
> > I am having some issues with certain files where I can query the text
> > fields in sqlline and get a result with Cast VarChar, however if I try to
> > apply a regexp_replace on the text field I get an error for some files.
> > (Encountered an illegal char on line 1, column 38: ‘’)
> >
> > Thanks
> > —Andries
>
>
>
>
> --
>  Steven Phillips
>  Software Engineer
>
>  mapr.com
>

Re: Drill file encondig

Posted by Steven Phillips <sp...@maprtech.com>.
Drill doesn't support encodings besides utf-8 for the text reader, I
believe.

On Thu, Mar 12, 2015 at 11:07 AM, Andries Engelbrecht <
aengelbrecht@maprtech.com> wrote:

> Any place to set the file encoding for Drill?
> (file.encoding)
>
> There does not seem to be a parameter in sys.options.
>
> Can only find
> sun.jnu.encoding
> file.encoding.pkg
> sun.io.unicode.encoding
>
> I am having some issues with certain files where I can query the text
> fields in sqlline and get a result with Cast VarChar, however if I try to
> apply a regexp_replace on the text field I get an error for some files.
> (Encountered an illegal char on line 1, column 38: ‘’)
>
> Thanks
> —Andries




-- 
 Steven Phillips
 Software Engineer

 mapr.com