[ https://issues.apache.org/jira/browse/HIVE-22433?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16963009#comment-16963009 ]
Syed Shameerur Rahman commented on HIVE-22433: ---------------------------------------------- [~jcamachorodriguez] Could you please review? * [|https://issues.apache.org/jira/secure/AddComment!default.jspa?id=13265193] > 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 > > > 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)