[jira] [Commented] (HIVE-3611) Hive JDBC doesn't support BINARY column
[ https://issues.apache.org/jira/browse/HIVE-3611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13875839#comment-13875839 ] Lefty Leverenz commented on HIVE-3611: -- Then it sounds like no user documentation is needed. (Please correct me if I'm wrong.) Agreed that adding new documentation for the old JDBC is counterproductive -- that only occurred to me after I posted the comment. Thanks. 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 Fix For: 0.13.0 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)
[jira] [Commented] (HIVE-3611) Hive JDBC doesn't support BINARY column
[ https://issues.apache.org/jira/browse/HIVE-3611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=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)
[jira] [Commented] (HIVE-3611) Hive JDBC doesn't support BINARY column
[ https://issues.apache.org/jira/browse/HIVE-3611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13874870#comment-13874870 ] Xuefu Zhang commented on HIVE-3611: --- [~leftylev] 1. Yes, binary type is in the list of JdbcColumn, but data can only be retrieved via getString() assuming data is encoded as base64. This JIRA adds getBinaryStream(), and binary data is retried as binary. 2. In my opinion, old JDBC (org.apache.hadoop.hive package) is in maintenance/deprecated mode, and we should not be adding new features (data types). However, this is not followed strictly by everyone. Thus, disparities may be seen. 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 Fix For: 0.13.0 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)
[jira] [Commented] (HIVE-3611) Hive JDBC doesn't support BINARY column
[ https://issues.apache.org/jira/browse/HIVE-3611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13874544#comment-13874544 ] Hive QA commented on HIVE-3611: --- {color:green}Overall{color}: +1 all checks pass Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12623574/HIVE-3611.4.patch {color:green}SUCCESS:{color} +1 4940 tests passed Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/944/testReport Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/944/console Messages: {noformat} Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase {noformat} This message is automatically generated. ATTACHMENT ID: 12623574 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)
[jira] [Commented] (HIVE-3611) Hive JDBC doesn't support BINARY column
[ https://issues.apache.org/jira/browse/HIVE-3611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13871426#comment-13871426 ] Hive QA commented on HIVE-3611: --- {color:green}Overall{color}: +1 all checks pass Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12622993/HIVE-3611.3.patch {color:green}SUCCESS:{color} +1 4924 tests passed Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/911/testReport Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/911/console Messages: {noformat} Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase {noformat} This message is automatically generated. ATTACHMENT ID: 12622993 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 Similar to HIVE-2957, the JDBC HiveDriver should also support BINARY type columns. -- This message was sent by Atlassian JIRA (v6.1.5#6160)
[jira] [Commented] (HIVE-3611) Hive JDBC doesn't support BINARY column
[ https://issues.apache.org/jira/browse/HIVE-3611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13870439#comment-13870439 ] Prasad Mujumdar commented on HIVE-3611: --- [~xuefuz] Looks fine, just a couple of minor comments on the reviewboard. 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 Similar to HIVE-2957, the JDBC HiveDriver should also support BINARY type columns. -- This message was sent by Atlassian JIRA (v6.1.5#6160)
[jira] [Commented] (HIVE-3611) Hive JDBC doesn't support BINARY column
[ https://issues.apache.org/jira/browse/HIVE-3611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13860960#comment-13860960 ] Hive QA commented on HIVE-3611: --- {color:green}Overall{color}: +1 all checks pass Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12621147/HIVE-3611.2.patch {color:green}SUCCESS:{color} +1 4820 tests passed Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/783/testReport Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/783/console Messages: {noformat} Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase {noformat} This message is automatically generated. ATTACHMENT ID: 12621147 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 Similar to HIVE-2957, the JDBC HiveDriver should also support BINARY type columns. -- This message was sent by Atlassian JIRA (v6.1.5#6160)
[jira] [Commented] (HIVE-3611) Hive JDBC doesn't support BINARY column
[ https://issues.apache.org/jira/browse/HIVE-3611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13861045#comment-13861045 ] Wee Hiong commented on HIVE-3611: - Hi Xuefu, So glad to hear the patch is available now. I need some instruction on how to install this patch into my Hadoop cluster. Kindly advise... 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 Similar to HIVE-2957, the JDBC HiveDriver should also support BINARY type columns. -- This message was sent by Atlassian JIRA (v6.1.5#6160)
[jira] [Commented] (HIVE-3611) Hive JDBC doesn't support BINARY column
[ https://issues.apache.org/jira/browse/HIVE-3611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13861231#comment-13861231 ] Xuefu Zhang commented on HIVE-3611: --- [~weehiong] The patch, while subject to review, will be committed to trunk, which means that you can get it from the next release (0.13). For your existing hive installation, however, you may choose to backport this patch to the version of hive that you have and rebuild your hive binaries. Practically, a lot of users would ask their service provides to do this for them. This certainly goes beyond the responsibility of the Hive community here. 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 Similar to HIVE-2957, the JDBC HiveDriver should also support BINARY type columns. -- This message was sent by Atlassian JIRA (v6.1.5#6160)
[jira] [Commented] (HIVE-3611) Hive JDBC doesn't support BINARY column
[ https://issues.apache.org/jira/browse/HIVE-3611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13861250#comment-13861250 ] Wee Hiong commented on HIVE-3611: - Hi Xuefu, OK, I understand now. I will wait for next Hive release (0.13). Thank you for the advise. 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 Similar to HIVE-2957, the JDBC HiveDriver should also support BINARY type columns. -- This message was sent by Atlassian JIRA (v6.1.5#6160)
[jira] [Commented] (HIVE-3611) Hive JDBC doesn't support BINARY column
[ https://issues.apache.org/jira/browse/HIVE-3611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13857378#comment-13857378 ] Wee Hiong commented on HIVE-3611: - Hi, Can I have some update as to when the fix will be implemented? I have a MSSQL database with binary column which I wanted to import to Hive urgently. Thank you. 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 Labels: patch Attachments: HIVE-3611.1.patch.txt Similar to HIVE-2957, the JDBC HiveDriver should also support BINARY type columns. -- This message was sent by Atlassian JIRA (v6.1.5#6160)
[jira] [Commented] (HIVE-3611) Hive JDBC doesn't support BINARY column
[ https://issues.apache.org/jira/browse/HIVE-3611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13857518#comment-13857518 ] Xuefu Zhang commented on HIVE-3611: --- I'm going to give a try on this one. The patch attached above is one-year-old. I guess it will needs more work. 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 Similar to HIVE-2957, the JDBC HiveDriver should also support BINARY type columns. -- This message was sent by Atlassian JIRA (v6.1.5#6160)
[jira] [Commented] (HIVE-3611) Hive JDBC doesn't support BINARY column
[ https://issues.apache.org/jira/browse/HIVE-3611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13857529#comment-13857529 ] Wee Hiong commented on HIVE-3611: - Hi Xuefu, I am very very glad to hear from you. I appriciate your help and hope to work you closely for any help/information that you might need from me. Thanks again. 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 Similar to HIVE-2957, the JDBC HiveDriver should also support BINARY type columns. -- This message was sent by Atlassian JIRA (v6.1.5#6160)