[HIVE-22431] Hive JDBC Storage Handler: java.lang.ClassCastException on accessing TINYINT, SMALLINT Data Type 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 04:54
• Updated: 27/Feb/24 22:23
• Resolved: 31/Oct/19 06:04

Description

Steps to Reproduce:

//MySQL table:
create table testtbl(a TINYINT, b SMALLINT);

// Insert to table via mysql connector

//Hive table:
CREATE EXTERNAL TABLE `hive_table`(               
      a TINYINT, b SMALLINT
 )           
    STORED BY                                          
      'org.apache.hive.storage.jdbc.JdbcStorageHandler'                       
    TBLPROPERTIES (                                                            
      'hive.sql.database.type'='MYSQL',                                  
      'hive.sql.dbcp.password'='',             
      'hive.sql.dbcp.username'='',             
      'hive.sql.jdbc.driver'='com.mysql.jdbc.Driver',  
      'hive.sql.jdbc.url'='',  
      'hive.sql.table'='testtbl');

//Hive query:
select * from hive_table;

Failed with exception java.io.IOException:org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.Byte

Failed with exception java.io.IOException:org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.Short

Issue Links

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