drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nathaniel Auvil (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-3745) Hive CHAR not supported
Date Tue, 08 Sep 2015 12:27:46 GMT
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)

Mime
View raw message