You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by Abhishek Girish <ag...@mapr.com> on 2015/01/09 01:29:09 UTC

Support for Text Datatype

Hi all,

The documentation (
https://cwiki.apache.org/confluence/display/DRILL/Data+Types) lists Text as
a supported data type in Drill and I vaguely remember using the same
sometime before in my CTAS scripts.

As of now, my queries with an explicit cast to Text fails complaining "*Unknown
datatype name 'TEXT' "*

Can someone confirm if Text is indeed a supported data type and the current
behavior is a bug? Or if it unsupported and the documentation needs to be
corrected. I'll file a JIRA accordingly.

Regards,
Abhishek

Re: Support for Text Datatype

Posted by Abhishek Girish <ab...@gmail.com>.
Then there is a high chance I might have used it with Postgres instead.
Like you said, the documentation needs to be updated. But I shall wait for
your confirmation. Thanks!

On Thu, Jan 8, 2015 at 6:18 PM, Aman Sinha <as...@maprtech.com> wrote:

> Text type fails validation in Calcite/Optiq so I don't think it was ever
> supported.  There's a good chance the documentation needs to be
> updated..but let me confirm that by tomorrow.
>
> On Thu, Jan 8, 2015 at 4:29 PM, Abhishek Girish <ag...@mapr.com> wrote:
>
> > Hi all,
> >
> > The documentation (
> > https://cwiki.apache.org/confluence/display/DRILL/Data+Types) lists Text
> > as
> > a supported data type in Drill and I vaguely remember using the same
> > sometime before in my CTAS scripts.
> >
> > As of now, my queries with an explicit cast to Text fails complaining
> > "*Unknown
> > datatype name 'TEXT' "*
> >
> > Can someone confirm if Text is indeed a supported data type and the
> current
> > behavior is a bug? Or if it unsupported and the documentation needs to be
> > corrected. I'll file a JIRA accordingly.
> >
> > Regards,
> > Abhishek
> >
>

Re: Support for Text Datatype

Posted by Aman Sinha <as...@maprtech.com>.
Text type fails validation in Calcite/Optiq so I don't think it was ever
supported.  There's a good chance the documentation needs to be
updated..but let me confirm that by tomorrow.

On Thu, Jan 8, 2015 at 4:29 PM, Abhishek Girish <ag...@mapr.com> wrote:

> Hi all,
>
> The documentation (
> https://cwiki.apache.org/confluence/display/DRILL/Data+Types) lists Text
> as
> a supported data type in Drill and I vaguely remember using the same
> sometime before in my CTAS scripts.
>
> As of now, my queries with an explicit cast to Text fails complaining
> "*Unknown
> datatype name 'TEXT' "*
>
> Can someone confirm if Text is indeed a supported data type and the current
> behavior is a bug? Or if it unsupported and the documentation needs to be
> corrected. I'll file a JIRA accordingly.
>
> Regards,
> Abhishek
>