hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lefty Leverenz (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-3611) Hive JDBC doesn't support BINARY column
Date Fri, 17 Jan 2014 09:53:22 GMT

    [ 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)

Mime
View raw message