[DRILL-3745] Hive CHAR not supported

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.1.0
• Fix Version/s: 1.7.0
• Labels: doc-impacting
• Assignee: Arina Ielchiieva
• Reporter: Nathaniel Auvil
• Reviewer: Krystal
• Created: 08/Sep/15 12:26
• Updated: 02/May/16 18:57
• Resolved: 16/Mar/16 15:51

Description

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.