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 <[email protected]> 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 < > [email protected]> > 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 <[email protected]> > 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 <[email protected]> > wrote: > > > > > > > Does this mean there aren't plans to support this data type? What > about > > > > Hive comparability? > > > > > > > > On Friday, September 4, 2015, Kristine Hahn <[email protected] > > > > <javascript:_e(%7B%7D,'cvml','[email protected]');>> 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 <[email protected]> > > > >> 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 [email protected] > > > >> > 215-701-3146 > > > >> > > > > >> > > > > >> > > > > > > > > > > > > -- > > > > Chris Matta > > > > [email protected] <javascript:_e(%7B%7D,'cvml','[email protected]');> > > > > 215-701-3146 > > > > > > > > > > > > > > -- > > > Chris Matta > > > [email protected] > > > 215-701-3146 > > > > > >
