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 > > >
