You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Syed Shameerur Rahman (Jira)" <ji...@apache.org> on 2019/11/01 15:35:00 UTC
[jira] [Updated] (HIVE-22433) Hive JDBC Storage Handler: Incorrect
results fetched from BOOLEAN and TIMESTAMP DataType From JDBC Data Source
[ https://issues.apache.org/jira/browse/HIVE-22433?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Syed Shameerur Rahman updated HIVE-22433:
-----------------------------------------
Attachment: HIVE-22433.02.patch
> Hive JDBC Storage Handler: Incorrect results fetched from BOOLEAN and TIMESTAMP DataType From JDBC Data Source
> --------------------------------------------------------------------------------------------------------------
>
> Key: HIVE-22433
> URL: https://issues.apache.org/jira/browse/HIVE-22433
> Project: Hive
> Issue Type: Bug
> Components: StorageHandler
> Reporter: Syed Shameerur Rahman
> Assignee: Syed Shameerur Rahman
> Priority: Major
> Labels: pull-request-available
> Attachments: HIVE-22433.01.patch, HIVE-22433.02.patch
>
>
> Steps to Reproduce:
> {code:java}
> //Derby table:
> create table testtbl(a BOOLEAN, b TIMESTAMP);
> // Insert to table via mysql connector
> // data in db
> true 2019-11-11 12:00:00
> //Hive table:
> CREATE EXTERNAL TABLE `hive_table`(
> a BOOLEAN, b TIMESTAMP
> )
> STORED BY
> 'org.apache.hive.storage.jdbc.JdbcStorageHandler'
> TBLPROPERTIES (
> 'hive.sql.database.type'='DERBY',
> 'hive.sql.dbcp.password'='',
> 'hive.sql.dbcp.username'='',
> 'hive.sql.jdbc.driver'='',
> 'hive.sql.jdbc.url'='',
> 'hive.sql.table'='testtbl');
> //Hive query:
> select * from hive_table;
> // result from select query
> false 2019-11-11 20:00:00
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)