You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@drill.apache.org by "Nathaniel Auvil (JIRA)" <ji...@apache.org> on 2015/09/08 14:27:46 UTC

[jira] [Created] (DRILL-3745) Hive CHAR not supported

Nathaniel Auvil created DRILL-3745:
--------------------------------------

             Summary: Hive CHAR not supported
                 Key: DRILL-3745
                 URL: https://issues.apache.org/jira/browse/DRILL-3745
             Project: Apache Drill
          Issue Type: Bug
          Components: Client - JDBC
    Affects Versions: 1.1.0
            Reporter: Nathaniel Auvil
            Assignee: Daniel Barclay (Drill)


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)