[
https://issues.apache.org/jira/browse/HIVE-3611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13874609#comment-13874609
]
Lefty Leverenz commented on HIVE-3611:
--------------------------------------
Is this for the original Hive Server? Because the wikidoc for HiveServer2
already shows BINARY support, but the original Hive Server wikidoc has no list
of supported datatypes.
* [JDBC Data Types for HS2 -- includes BINARY
|https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients#HiveServer2Clients-JDBCDataTypes]
* [JDBC for original Hive Server -- no datatype list
|https://cwiki.apache.org/confluence/display/Hive/HiveClient#HiveClient-JDBC]
If someone provides a list, I'll add it to the wiki for the original Hive
Server's JDBC. Or verify this list culled from JdbcColumn.java: BOOLEAN, CHAR
{?}, VARCHAR {?}, TINYINT, SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE, DECIMAL,
DATE, TIMESTAMP. Plus BINARY in Hive 0.13.0, of course, unless it's only for
HiveServer2 in which case the wikidoc for HS2 JDBC documented it prematurely.
(TL;DR) CHAR is in jdbc/src/java/org/apache/*hive*/jdbc/JdbcColumn.java but
not in jdbc/src/java/org/apache/*hadoop*/*hive*/jdbc/JdbcColumn.java, and I
don't know the difference between them except that the wiki's sample code for
HS2 points to ..*hive*.jdbc.HiveDriver while the sample code for the original
Hive Server points to ..*hadoop*.*hive*.jdbc.HiveDriver. Does that mean CHAR
is supported by HS2 but not by the original Hive Server? There are several
discrepancies between types in JdbcColumn.java and those in the wiki list for
HS2 -- STRING instead of CHAR/VARCHAR, DATE not in list, ARRAY/MAP/STRUCT in
list.
Perhaps this belongs in a separate JIRA ticket or email thread. When I started
writing, I thought it would be simple.
> Hive JDBC doesn't support BINARY column
> ---------------------------------------
>
> Key: HIVE-3611
> URL: https://issues.apache.org/jira/browse/HIVE-3611
> Project: Hive
> Issue Type: Improvement
> Components: JDBC
> Affects Versions: 0.9.0
> Reporter: Viji
> Assignee: Xuefu Zhang
> Labels: patch
> Attachments: HIVE-3611.1.patch.txt, HIVE-3611.2.patch,
> HIVE-3611.3.patch, HIVE-3611.4.patch
>
>
> Similar to HIVE-2957, the JDBC HiveDriver should also support BINARY type
> columns.
--
This message was sent by Atlassian JIRA
(v6.1.5#6160)
