Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
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
Attachments
Attachments
Issue Links
- blocks
-
HIVE-22392 Hive JDBC Storage Handler: Support For Writing Data to JDBC Data Source
- Closed
- links to