You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Christopher Matta <cm...@mapr.com> on 2015/09/04 16:20:06 UTC
Support for Hive CHAR type
It doesn’t look like Drill 1.1.0 supports the Hive CHAR type?
In Hive:
create table development.foo
(
bad CHAR(10)
);
And then in sqlline:
> use `hive.development`;
> select * from foo;
Error: PARSE ERROR: Unsupported Hive data type CHAR.
Following Hive data types are supported in Drill INFORMATION_SCHEMA:
BOOLEAN, BYTE, SHORT, INT, LONG, FLOAT, DOUBLE, DATE, TIMESTAMP,
BINARY, DECIMAL, STRING, VARCHAR, LIST, MAP, STRUCT and UNION
[Error Id: 58bf3940-3c09-4ad2-8f52-d052dffd4b17 on dtpg05:31010] (state=,code=0)
This Jira <https://issues.apache.org/jira/browse/DRILL-1570> was closed
back in October, but it would seem that CHAR isn’t currently supported.
Will this be in 1.2.0?
Chris Mattacmatta@mapr.com
215-701-3146
Re: Support for Hive CHAR type
Posted by Jacques Nadeau <ja...@dremio.com>.
Great, thanks!
--
Jacques Nadeau
CTO and Co-Founder, Dremio
On Tue, Sep 8, 2015 at 5:27 AM, Nathaniel Auvil <na...@gmail.com>
wrote:
> I aped Chris's fragments to reproduce in:
> https://issues.apache.org/jira/browse/DRILL-3745
>
> On Tue, Sep 8, 2015 at 1:36 AM, Jacques Nadeau <ja...@dremio.com> wrote:
>
> > It looks like we need a JIRA to make sure this gets fixed. Nathaniel,
> will
> > you post one?
> >
> > --
> > Jacques Nadeau
> > CTO and Co-Founder, Dremio
> >
> > On Fri, Sep 4, 2015 at 10:35 AM, Nathaniel Auvil <
> > nathaniel.auvil@gmail.com>
> > wrote:
> >
> > > without CHAR support, drill can not be used in Squirrel when the hive
> > > plugin is enabled and a hive table has CHAR
> > >
> > > On Fri, Sep 4, 2015 at 12:00 PM, Venki Korukanti <
> > > venki.korukanti@gmail.com>
> > > wrote:
> > >
> > > > I think we can support this. CHAR was added in recent versions of
> Hive.
> > > It
> > > > got missed when we upgraded the supported Hive versions in plugin.
> > > >
> > > > Thanks
> > > > Venki
> > > >
> > > > On Fri, Sep 4, 2015 at 8:58 AM, Christopher Matta <cm...@mapr.com>
> > > wrote:
> > > >
> > > > > According to this page:
> > > > >
> > > >
> > >
> >
> http://kristinehahn.github.io/drill/docs/hive-to-drill-data-type-mapping/
> > > > > it
> > > > > looks like Drill should convert CHAR to VARCHAR, but it's not.
> > > > >
> > > > > On Friday, September 4, 2015, Christopher Matta <cm...@mapr.com>
> > > wrote:
> > > > >
> > > > > > Does this mean there aren't plans to support this data type? What
> > > about
> > > > > > Hive comparability?
> > > > > >
> > > > > > On Friday, September 4, 2015, Kristine Hahn <khahn@maprtech.com
> > > > > > <javascript:_e(%7B%7D,'cvml','khahn@maprtech.com');>> wrote:
> > > > > >
> > > > > >> Do the docs need to be clarified about Drill lack of support for
> > > > > >> variable-length CHAR in the Supported Data Types
> > > > > >> <http://kristinehahn.github.io/drill/docs/supported-data-types/
> > > > >--these
> > > > > >> are
> > > > > >> the SQL types? I think so. We need to ditch the example of
> > CHAR(30)
> > > > for
> > > > > >> sure. The docs say that the Hive CHAR type is mapped to the SQL
> > > > VARCHAR
> > > > > >> type, but the ramifications of this mapping with regard to using
> > > Hive
> > > > > >> don't
> > > > > >> jump out at you. We need to spell it out using a Hive example,
> > > right?
> > > > > >>
> > > > > >> Kristine Hahn
> > > > > >> Sr. Technical Writer
> > > > > >> 415-497-8107 @krishahn skype:krishahn
> > > > > >>
> > > > > >>
> > > > > >> On Fri, Sep 4, 2015 at 7:20 AM, Christopher Matta <
> > cmatta@mapr.com>
> > > > > >> wrote:
> > > > > >>
> > > > > >> > It doesn’t look like Drill 1.1.0 supports the Hive CHAR type?
> > > > > >> >
> > > > > >> > In Hive:
> > > > > >> >
> > > > > >> > create table development.foo
> > > > > >> > (
> > > > > >> > bad CHAR(10)
> > > > > >> > );
> > > > > >> >
> > > > > >> > And then in sqlline:
> > > > > >> >
> > > > > >> > > use `hive.development`;
> > > > > >> > > select * from foo;
> > > > > >> > Error: PARSE ERROR: Unsupported Hive data type CHAR.
> > > > > >> >
> > > > > >> > Following Hive data types are supported in Drill
> > > INFORMATION_SCHEMA:
> > > > > >> > BOOLEAN, BYTE, SHORT, INT, LONG, FLOAT, DOUBLE, DATE,
> TIMESTAMP,
> > > > > >> > BINARY, DECIMAL, STRING, VARCHAR, LIST, MAP, STRUCT and UNION
> > > > > >> > [Error Id: 58bf3940-3c09-4ad2-8f52-d052dffd4b17 on
> dtpg05:31010]
> > > > > >> > (state=,code=0)
> > > > > >> >
> > > > > >> > This Jira <https://issues.apache.org/jira/browse/DRILL-1570>
> > was
> > > > > closed
> > > > > >> > back in October, but it would seem that CHAR isn’t currently
> > > > > supported.
> > > > > >> > Will this be in 1.2.0?
> > > > > >> >
> > > > > >> > Chris Mattacmatta@mapr.com
> > > > > >> > 215-701-3146
> > > > > >> >
> > > > > >> >
> > > > > >>
> > > > > >
> > > > > >
> > > > > > --
> > > > > > Chris Matta
> > > > > > cmatta@mapr.com <javascript:_e(%7B%7D,'cvml','cmatta@mapr.com
> ');>
> > > > > > 215-701-3146
> > > > > >
> > > > > >
> > > > >
> > > > > --
> > > > > Chris Matta
> > > > > cmatta@mapr.com
> > > > > 215-701-3146
> > > > >
> > > >
> > >
> >
>
Re: Support for Hive CHAR type
Posted by Nathaniel Auvil <na...@gmail.com>.
I aped Chris's fragments to reproduce in:
https://issues.apache.org/jira/browse/DRILL-3745
On Tue, Sep 8, 2015 at 1:36 AM, Jacques Nadeau <ja...@dremio.com> wrote:
> It looks like we need a JIRA to make sure this gets fixed. Nathaniel, will
> you post one?
>
> --
> Jacques Nadeau
> CTO and Co-Founder, Dremio
>
> On Fri, Sep 4, 2015 at 10:35 AM, Nathaniel Auvil <
> nathaniel.auvil@gmail.com>
> wrote:
>
> > without CHAR support, drill can not be used in Squirrel when the hive
> > plugin is enabled and a hive table has CHAR
> >
> > On Fri, Sep 4, 2015 at 12:00 PM, Venki Korukanti <
> > venki.korukanti@gmail.com>
> > wrote:
> >
> > > I think we can support this. CHAR was added in recent versions of Hive.
> > It
> > > got missed when we upgraded the supported Hive versions in plugin.
> > >
> > > Thanks
> > > Venki
> > >
> > > On Fri, Sep 4, 2015 at 8:58 AM, Christopher Matta <cm...@mapr.com>
> > wrote:
> > >
> > > > According to this page:
> > > >
> > >
> >
> http://kristinehahn.github.io/drill/docs/hive-to-drill-data-type-mapping/
> > > > it
> > > > looks like Drill should convert CHAR to VARCHAR, but it's not.
> > > >
> > > > On Friday, September 4, 2015, Christopher Matta <cm...@mapr.com>
> > wrote:
> > > >
> > > > > Does this mean there aren't plans to support this data type? What
> > about
> > > > > Hive comparability?
> > > > >
> > > > > On Friday, September 4, 2015, Kristine Hahn <khahn@maprtech.com
> > > > > <javascript:_e(%7B%7D,'cvml','khahn@maprtech.com');>> wrote:
> > > > >
> > > > >> Do the docs need to be clarified about Drill lack of support for
> > > > >> variable-length CHAR in the Supported Data Types
> > > > >> <http://kristinehahn.github.io/drill/docs/supported-data-types/
> > > >--these
> > > > >> are
> > > > >> the SQL types? I think so. We need to ditch the example of
> CHAR(30)
> > > for
> > > > >> sure. The docs say that the Hive CHAR type is mapped to the SQL
> > > VARCHAR
> > > > >> type, but the ramifications of this mapping with regard to using
> > Hive
> > > > >> don't
> > > > >> jump out at you. We need to spell it out using a Hive example,
> > right?
> > > > >>
> > > > >> Kristine Hahn
> > > > >> Sr. Technical Writer
> > > > >> 415-497-8107 @krishahn skype:krishahn
> > > > >>
> > > > >>
> > > > >> On Fri, Sep 4, 2015 at 7:20 AM, Christopher Matta <
> cmatta@mapr.com>
> > > > >> wrote:
> > > > >>
> > > > >> > It doesn’t look like Drill 1.1.0 supports the Hive CHAR type?
> > > > >> >
> > > > >> > In Hive:
> > > > >> >
> > > > >> > create table development.foo
> > > > >> > (
> > > > >> > bad CHAR(10)
> > > > >> > );
> > > > >> >
> > > > >> > And then in sqlline:
> > > > >> >
> > > > >> > > use `hive.development`;
> > > > >> > > select * from foo;
> > > > >> > Error: PARSE ERROR: Unsupported Hive data type CHAR.
> > > > >> >
> > > > >> > Following Hive data types are supported in Drill
> > INFORMATION_SCHEMA:
> > > > >> > BOOLEAN, BYTE, SHORT, INT, LONG, FLOAT, DOUBLE, DATE, TIMESTAMP,
> > > > >> > BINARY, DECIMAL, STRING, VARCHAR, LIST, MAP, STRUCT and UNION
> > > > >> > [Error Id: 58bf3940-3c09-4ad2-8f52-d052dffd4b17 on dtpg05:31010]
> > > > >> > (state=,code=0)
> > > > >> >
> > > > >> > This Jira <https://issues.apache.org/jira/browse/DRILL-1570>
> was
> > > > closed
> > > > >> > back in October, but it would seem that CHAR isn’t currently
> > > > supported.
> > > > >> > Will this be in 1.2.0?
> > > > >> >
> > > > >> > Chris Mattacmatta@mapr.com
> > > > >> > 215-701-3146
> > > > >> >
> > > > >> >
> > > > >>
> > > > >
> > > > >
> > > > > --
> > > > > Chris Matta
> > > > > cmatta@mapr.com <javascript:_e(%7B%7D,'cvml','cmatta@mapr.com');>
> > > > > 215-701-3146
> > > > >
> > > > >
> > > >
> > > > --
> > > > Chris Matta
> > > > cmatta@mapr.com
> > > > 215-701-3146
> > > >
> > >
> >
>
Re: Support for Hive CHAR type
Posted by Jacques Nadeau <ja...@dremio.com>.
It looks like we need a JIRA to make sure this gets fixed. Nathaniel, will
you post one?
--
Jacques Nadeau
CTO and Co-Founder, Dremio
On Fri, Sep 4, 2015 at 10:35 AM, Nathaniel Auvil <na...@gmail.com>
wrote:
> without CHAR support, drill can not be used in Squirrel when the hive
> plugin is enabled and a hive table has CHAR
>
> On Fri, Sep 4, 2015 at 12:00 PM, Venki Korukanti <
> venki.korukanti@gmail.com>
> wrote:
>
> > I think we can support this. CHAR was added in recent versions of Hive.
> It
> > got missed when we upgraded the supported Hive versions in plugin.
> >
> > Thanks
> > Venki
> >
> > On Fri, Sep 4, 2015 at 8:58 AM, Christopher Matta <cm...@mapr.com>
> wrote:
> >
> > > According to this page:
> > >
> >
> http://kristinehahn.github.io/drill/docs/hive-to-drill-data-type-mapping/
> > > it
> > > looks like Drill should convert CHAR to VARCHAR, but it's not.
> > >
> > > On Friday, September 4, 2015, Christopher Matta <cm...@mapr.com>
> wrote:
> > >
> > > > Does this mean there aren't plans to support this data type? What
> about
> > > > Hive comparability?
> > > >
> > > > On Friday, September 4, 2015, Kristine Hahn <khahn@maprtech.com
> > > > <javascript:_e(%7B%7D,'cvml','khahn@maprtech.com');>> wrote:
> > > >
> > > >> Do the docs need to be clarified about Drill lack of support for
> > > >> variable-length CHAR in the Supported Data Types
> > > >> <http://kristinehahn.github.io/drill/docs/supported-data-types/
> > >--these
> > > >> are
> > > >> the SQL types? I think so. We need to ditch the example of CHAR(30)
> > for
> > > >> sure. The docs say that the Hive CHAR type is mapped to the SQL
> > VARCHAR
> > > >> type, but the ramifications of this mapping with regard to using
> Hive
> > > >> don't
> > > >> jump out at you. We need to spell it out using a Hive example,
> right?
> > > >>
> > > >> Kristine Hahn
> > > >> Sr. Technical Writer
> > > >> 415-497-8107 @krishahn skype:krishahn
> > > >>
> > > >>
> > > >> On Fri, Sep 4, 2015 at 7:20 AM, Christopher Matta <cm...@mapr.com>
> > > >> wrote:
> > > >>
> > > >> > It doesn’t look like Drill 1.1.0 supports the Hive CHAR type?
> > > >> >
> > > >> > In Hive:
> > > >> >
> > > >> > create table development.foo
> > > >> > (
> > > >> > bad CHAR(10)
> > > >> > );
> > > >> >
> > > >> > And then in sqlline:
> > > >> >
> > > >> > > use `hive.development`;
> > > >> > > select * from foo;
> > > >> > Error: PARSE ERROR: Unsupported Hive data type CHAR.
> > > >> >
> > > >> > Following Hive data types are supported in Drill
> INFORMATION_SCHEMA:
> > > >> > BOOLEAN, BYTE, SHORT, INT, LONG, FLOAT, DOUBLE, DATE, TIMESTAMP,
> > > >> > BINARY, DECIMAL, STRING, VARCHAR, LIST, MAP, STRUCT and UNION
> > > >> > [Error Id: 58bf3940-3c09-4ad2-8f52-d052dffd4b17 on dtpg05:31010]
> > > >> > (state=,code=0)
> > > >> >
> > > >> > This Jira <https://issues.apache.org/jira/browse/DRILL-1570> was
> > > closed
> > > >> > back in October, but it would seem that CHAR isn’t currently
> > > supported.
> > > >> > Will this be in 1.2.0?
> > > >> >
> > > >> > Chris Mattacmatta@mapr.com
> > > >> > 215-701-3146
> > > >> >
> > > >> >
> > > >>
> > > >
> > > >
> > > > --
> > > > Chris Matta
> > > > cmatta@mapr.com <javascript:_e(%7B%7D,'cvml','cmatta@mapr.com');>
> > > > 215-701-3146
> > > >
> > > >
> > >
> > > --
> > > Chris Matta
> > > cmatta@mapr.com
> > > 215-701-3146
> > >
> >
>
Re: Support for Hive CHAR type
Posted by Nathaniel Auvil <na...@gmail.com>.
without CHAR support, drill can not be used in Squirrel when the hive
plugin is enabled and a hive table has CHAR
On Fri, Sep 4, 2015 at 12:00 PM, Venki Korukanti <ve...@gmail.com>
wrote:
> I think we can support this. CHAR was added in recent versions of Hive. It
> got missed when we upgraded the supported Hive versions in plugin.
>
> Thanks
> Venki
>
> On Fri, Sep 4, 2015 at 8:58 AM, Christopher Matta <cm...@mapr.com> wrote:
>
> > According to this page:
> >
> http://kristinehahn.github.io/drill/docs/hive-to-drill-data-type-mapping/
> > it
> > looks like Drill should convert CHAR to VARCHAR, but it's not.
> >
> > On Friday, September 4, 2015, Christopher Matta <cm...@mapr.com> wrote:
> >
> > > Does this mean there aren't plans to support this data type? What about
> > > Hive comparability?
> > >
> > > On Friday, September 4, 2015, Kristine Hahn <khahn@maprtech.com
> > > <javascript:_e(%7B%7D,'cvml','khahn@maprtech.com');>> wrote:
> > >
> > >> Do the docs need to be clarified about Drill lack of support for
> > >> variable-length CHAR in the Supported Data Types
> > >> <http://kristinehahn.github.io/drill/docs/supported-data-types/
> >--these
> > >> are
> > >> the SQL types? I think so. We need to ditch the example of CHAR(30)
> for
> > >> sure. The docs say that the Hive CHAR type is mapped to the SQL
> VARCHAR
> > >> type, but the ramifications of this mapping with regard to using Hive
> > >> don't
> > >> jump out at you. We need to spell it out using a Hive example, right?
> > >>
> > >> Kristine Hahn
> > >> Sr. Technical Writer
> > >> 415-497-8107 @krishahn skype:krishahn
> > >>
> > >>
> > >> On Fri, Sep 4, 2015 at 7:20 AM, Christopher Matta <cm...@mapr.com>
> > >> wrote:
> > >>
> > >> > It doesn’t look like Drill 1.1.0 supports the Hive CHAR type?
> > >> >
> > >> > In Hive:
> > >> >
> > >> > create table development.foo
> > >> > (
> > >> > bad CHAR(10)
> > >> > );
> > >> >
> > >> > And then in sqlline:
> > >> >
> > >> > > use `hive.development`;
> > >> > > select * from foo;
> > >> > Error: PARSE ERROR: Unsupported Hive data type CHAR.
> > >> >
> > >> > Following Hive data types are supported in Drill INFORMATION_SCHEMA:
> > >> > BOOLEAN, BYTE, SHORT, INT, LONG, FLOAT, DOUBLE, DATE, TIMESTAMP,
> > >> > BINARY, DECIMAL, STRING, VARCHAR, LIST, MAP, STRUCT and UNION
> > >> > [Error Id: 58bf3940-3c09-4ad2-8f52-d052dffd4b17 on dtpg05:31010]
> > >> > (state=,code=0)
> > >> >
> > >> > This Jira <https://issues.apache.org/jira/browse/DRILL-1570> was
> > closed
> > >> > back in October, but it would seem that CHAR isn’t currently
> > supported.
> > >> > Will this be in 1.2.0?
> > >> >
> > >> > Chris Mattacmatta@mapr.com
> > >> > 215-701-3146
> > >> >
> > >> >
> > >>
> > >
> > >
> > > --
> > > Chris Matta
> > > cmatta@mapr.com <javascript:_e(%7B%7D,'cvml','cmatta@mapr.com');>
> > > 215-701-3146
> > >
> > >
> >
> > --
> > Chris Matta
> > cmatta@mapr.com
> > 215-701-3146
> >
>
Re: Support for Hive CHAR type
Posted by Venki Korukanti <ve...@gmail.com>.
I think we can support this. CHAR was added in recent versions of Hive. It
got missed when we upgraded the supported Hive versions in plugin.
Thanks
Venki
On Fri, Sep 4, 2015 at 8:58 AM, Christopher Matta <cm...@mapr.com> wrote:
> According to this page:
> http://kristinehahn.github.io/drill/docs/hive-to-drill-data-type-mapping/
> it
> looks like Drill should convert CHAR to VARCHAR, but it's not.
>
> On Friday, September 4, 2015, Christopher Matta <cm...@mapr.com> wrote:
>
> > Does this mean there aren't plans to support this data type? What about
> > Hive comparability?
> >
> > On Friday, September 4, 2015, Kristine Hahn <khahn@maprtech.com
> > <javascript:_e(%7B%7D,'cvml','khahn@maprtech.com');>> wrote:
> >
> >> Do the docs need to be clarified about Drill lack of support for
> >> variable-length CHAR in the Supported Data Types
> >> <http://kristinehahn.github.io/drill/docs/supported-data-types/>--these
> >> are
> >> the SQL types? I think so. We need to ditch the example of CHAR(30) for
> >> sure. The docs say that the Hive CHAR type is mapped to the SQL VARCHAR
> >> type, but the ramifications of this mapping with regard to using Hive
> >> don't
> >> jump out at you. We need to spell it out using a Hive example, right?
> >>
> >> Kristine Hahn
> >> Sr. Technical Writer
> >> 415-497-8107 @krishahn skype:krishahn
> >>
> >>
> >> On Fri, Sep 4, 2015 at 7:20 AM, Christopher Matta <cm...@mapr.com>
> >> wrote:
> >>
> >> > It doesn’t look like Drill 1.1.0 supports the Hive CHAR type?
> >> >
> >> > In Hive:
> >> >
> >> > create table development.foo
> >> > (
> >> > bad CHAR(10)
> >> > );
> >> >
> >> > And then in sqlline:
> >> >
> >> > > use `hive.development`;
> >> > > select * from foo;
> >> > Error: PARSE ERROR: Unsupported Hive data type CHAR.
> >> >
> >> > Following Hive data types are supported in Drill INFORMATION_SCHEMA:
> >> > BOOLEAN, BYTE, SHORT, INT, LONG, FLOAT, DOUBLE, DATE, TIMESTAMP,
> >> > BINARY, DECIMAL, STRING, VARCHAR, LIST, MAP, STRUCT and UNION
> >> > [Error Id: 58bf3940-3c09-4ad2-8f52-d052dffd4b17 on dtpg05:31010]
> >> > (state=,code=0)
> >> >
> >> > This Jira <https://issues.apache.org/jira/browse/DRILL-1570> was
> closed
> >> > back in October, but it would seem that CHAR isn’t currently
> supported.
> >> > Will this be in 1.2.0?
> >> >
> >> > Chris Mattacmatta@mapr.com
> >> > 215-701-3146
> >> >
> >> >
> >>
> >
> >
> > --
> > Chris Matta
> > cmatta@mapr.com <javascript:_e(%7B%7D,'cvml','cmatta@mapr.com');>
> > 215-701-3146
> >
> >
>
> --
> Chris Matta
> cmatta@mapr.com
> 215-701-3146
>
Re: Support for Hive CHAR type
Posted by Christopher Matta <cm...@mapr.com>.
According to this page:
http://kristinehahn.github.io/drill/docs/hive-to-drill-data-type-mapping/ it
looks like Drill should convert CHAR to VARCHAR, but it's not.
On Friday, September 4, 2015, Christopher Matta <cm...@mapr.com> wrote:
> Does this mean there aren't plans to support this data type? What about
> Hive comparability?
>
> On Friday, September 4, 2015, Kristine Hahn <khahn@maprtech.com
> <javascript:_e(%7B%7D,'cvml','khahn@maprtech.com');>> wrote:
>
>> Do the docs need to be clarified about Drill lack of support for
>> variable-length CHAR in the Supported Data Types
>> <http://kristinehahn.github.io/drill/docs/supported-data-types/>--these
>> are
>> the SQL types? I think so. We need to ditch the example of CHAR(30) for
>> sure. The docs say that the Hive CHAR type is mapped to the SQL VARCHAR
>> type, but the ramifications of this mapping with regard to using Hive
>> don't
>> jump out at you. We need to spell it out using a Hive example, right?
>>
>> Kristine Hahn
>> Sr. Technical Writer
>> 415-497-8107 @krishahn skype:krishahn
>>
>>
>> On Fri, Sep 4, 2015 at 7:20 AM, Christopher Matta <cm...@mapr.com>
>> wrote:
>>
>> > It doesn’t look like Drill 1.1.0 supports the Hive CHAR type?
>> >
>> > In Hive:
>> >
>> > create table development.foo
>> > (
>> > bad CHAR(10)
>> > );
>> >
>> > And then in sqlline:
>> >
>> > > use `hive.development`;
>> > > select * from foo;
>> > Error: PARSE ERROR: Unsupported Hive data type CHAR.
>> >
>> > Following Hive data types are supported in Drill INFORMATION_SCHEMA:
>> > BOOLEAN, BYTE, SHORT, INT, LONG, FLOAT, DOUBLE, DATE, TIMESTAMP,
>> > BINARY, DECIMAL, STRING, VARCHAR, LIST, MAP, STRUCT and UNION
>> > [Error Id: 58bf3940-3c09-4ad2-8f52-d052dffd4b17 on dtpg05:31010]
>> > (state=,code=0)
>> >
>> > This Jira <https://issues.apache.org/jira/browse/DRILL-1570> was closed
>> > back in October, but it would seem that CHAR isn’t currently supported.
>> > Will this be in 1.2.0?
>> >
>> > Chris Mattacmatta@mapr.com
>> > 215-701-3146
>> >
>> >
>>
>
>
> --
> Chris Matta
> cmatta@mapr.com <javascript:_e(%7B%7D,'cvml','cmatta@mapr.com');>
> 215-701-3146
>
>
--
Chris Matta
cmatta@mapr.com
215-701-3146
Re: Support for Hive CHAR type
Posted by Christopher Matta <cm...@mapr.com>.
Does this mean there aren't plans to support this data type? What about
Hive comparability?
On Friday, September 4, 2015, Kristine Hahn <kh...@maprtech.com> wrote:
> Do the docs need to be clarified about Drill lack of support for
> variable-length CHAR in the Supported Data Types
> <http://kristinehahn.github.io/drill/docs/supported-data-types/>--these
> are
> the SQL types? I think so. We need to ditch the example of CHAR(30) for
> sure. The docs say that the Hive CHAR type is mapped to the SQL VARCHAR
> type, but the ramifications of this mapping with regard to using Hive don't
> jump out at you. We need to spell it out using a Hive example, right?
>
> Kristine Hahn
> Sr. Technical Writer
> 415-497-8107 @krishahn skype:krishahn
>
>
> On Fri, Sep 4, 2015 at 7:20 AM, Christopher Matta <cmatta@mapr.com
> <javascript:;>> wrote:
>
> > It doesn’t look like Drill 1.1.0 supports the Hive CHAR type?
> >
> > In Hive:
> >
> > create table development.foo
> > (
> > bad CHAR(10)
> > );
> >
> > And then in sqlline:
> >
> > > use `hive.development`;
> > > select * from foo;
> > Error: PARSE ERROR: Unsupported Hive data type CHAR.
> >
> > Following Hive data types are supported in Drill INFORMATION_SCHEMA:
> > BOOLEAN, BYTE, SHORT, INT, LONG, FLOAT, DOUBLE, DATE, TIMESTAMP,
> > BINARY, DECIMAL, STRING, VARCHAR, LIST, MAP, STRUCT and UNION
> > [Error Id: 58bf3940-3c09-4ad2-8f52-d052dffd4b17 on dtpg05:31010]
> > (state=,code=0)
> >
> > This Jira <https://issues.apache.org/jira/browse/DRILL-1570> was closed
> > back in October, but it would seem that CHAR isn’t currently supported.
> > Will this be in 1.2.0?
> >
> > Chris Mattacmatta@mapr.com <javascript:;>
> > 215-701-3146
> >
> >
>
--
Chris Matta
cmatta@mapr.com
215-701-3146
Re: Support for Hive CHAR type
Posted by Kristine Hahn <kh...@maprtech.com>.
Do the docs need to be clarified about Drill lack of support for
variable-length CHAR in the Supported Data Types
<http://kristinehahn.github.io/drill/docs/supported-data-types/>--these are
the SQL types? I think so. We need to ditch the example of CHAR(30) for
sure. The docs say that the Hive CHAR type is mapped to the SQL VARCHAR
type, but the ramifications of this mapping with regard to using Hive don't
jump out at you. We need to spell it out using a Hive example, right?
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn skype:krishahn
On Fri, Sep 4, 2015 at 7:20 AM, Christopher Matta <cm...@mapr.com> wrote:
> It doesn’t look like Drill 1.1.0 supports the Hive CHAR type?
>
> In Hive:
>
> create table development.foo
> (
> bad CHAR(10)
> );
>
> And then in sqlline:
>
> > use `hive.development`;
> > select * from foo;
> Error: PARSE ERROR: Unsupported Hive data type CHAR.
>
> Following Hive data types are supported in Drill INFORMATION_SCHEMA:
> BOOLEAN, BYTE, SHORT, INT, LONG, FLOAT, DOUBLE, DATE, TIMESTAMP,
> BINARY, DECIMAL, STRING, VARCHAR, LIST, MAP, STRUCT and UNION
> [Error Id: 58bf3940-3c09-4ad2-8f52-d052dffd4b17 on dtpg05:31010]
> (state=,code=0)
>
> This Jira <https://issues.apache.org/jira/browse/DRILL-1570> was closed
> back in October, but it would seem that CHAR isn’t currently supported.
> Will this be in 1.2.0?
>
> Chris Mattacmatta@mapr.com
> 215-701-3146
>
>