[
https://issues.apache.org/jira/browse/DRILL-3745?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15163837#comment-15163837
]
Arina Ielchiieva commented on DRILL-3745:
-----------------------------------------
Since Drill basically handles all chars as varchars to work correctly with hive
chars, we can return them as varchars but trimmed beforehand so they can be
compared to each other.
Proposed solution -
[https://github.com/arina-ielchiieva/drill/commit/0e3821e5d100d295e163d7d03d94a064329a4982]
Can anybody look at it?
> Hive CHAR not supported
> -----------------------
>
> Key: DRILL-3745
> URL: https://issues.apache.org/jira/browse/DRILL-3745
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.1.0
> Reporter: Nathaniel Auvil
> Assignee: Arina Ielchiieva
>
> 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 was originally found when getting failures trying to connect via JDBS
> using Squirrel. We have the Hive plugin enabled with tables using CHAR.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
