[HIVE-22433] Hive JDBC Storage Handler: Incorrect results fetched from BOOLEAN and TIMESTAMP DataType From JDBC Data Source

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Component/s: StorageHandler
• Labels: pull-request-available
• Target Version/s: 4.0.0
• Assignee: Syed Shameerur Rahman
• Reporter: Syed Shameerur Rahman
• Created: 30/Oct/19 05:14
• Updated: 27/Feb/24 22:23
• Resolved: 04/Nov/19 16:29

Description

Steps to Reproduce:

//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

Issue Links

• blocks: HIVE-22392 Hive JDBC Storage Handler: Support For Writing Data to JDBC Data Source
• links to: GitHub Pull Request #833