[
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.01.patch
Status: Patch Available (was: Open)
> 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
> Fix For: 4.0.0
>
> Attachments: HIVE-22433.01.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)
