[
https://issues.apache.org/jira/browse/DRILL-3745?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14875662#comment-14875662
]
Sergio Lob commented on DRILL-3745:
-----------------------------------
Related issue: DatabaseMetadata.getIndexInfo() and
DatabaseMetadata.getPrimaryKeys() calls against a Hive table also fail with
error message:
Caused by: java.sql.SQLException: SYSTEM ERROR: RuntimeException: 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
> 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
>
> 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)
