You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Usman Ali <us...@platalytics.com> on 2016/02/16 08:34:27 UTC

Custom Schema Support for Delimited Files

Hi,
       Is there any support for giving custom schema for schema-less
delimited files in storage plug-in or somewhere else? If not, is it going
to be part of any future release?

Usman Ali

Re: Custom Schema Support for Delimited Files

Posted by Usman Ali <us...@platalytics.com>.
thank you.

On Tue, Feb 16, 2016 at 12:41 PM, Hsuan Yi Chu <hy...@maprtech.com> wrote:

> Hi,
> How about defining a view on top?
>
> For example, create view XXX as select cast(columns[0] as int) col1,
> cast(columns[1] as int)  col2 from `xxx.csv`.
>
>
>
>
> On Mon, Feb 15, 2016 at 11:34 PM, Usman Ali <us...@platalytics.com>
> wrote:
>
> > Hi,
> >        Is there any support for giving custom schema for schema-less
> > delimited files in storage plug-in or somewhere else? If not, is it going
> > to be part of any future release?
> >
> > Usman Ali
> >
>

Re: Custom Schema Support for Delimited Files

Posted by Hsuan Yi Chu <hy...@maprtech.com>.
Hi,
How about defining a view on top?

For example, create view XXX as select cast(columns[0] as int) col1,
cast(columns[1] as int)  col2 from `xxx.csv`.




On Mon, Feb 15, 2016 at 11:34 PM, Usman Ali <us...@platalytics.com>
wrote:

> Hi,
>        Is there any support for giving custom schema for schema-less
> delimited files in storage plug-in or somewhere else? If not, is it going
> to be part of any future release?
>
> Usman Ali
>