[
https://issues.apache.org/jira/browse/HIVE-22433?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16964917#comment-16964917
]
Syed Shameerur Rahman edited comment on HIVE-22433 at 11/2/19 7:22 AM:
-----------------------------------------------------------------------
Updated PR and HIVE-22433.02.patch to fix the failing qtest and changed the
logic to deserialize timestamp data type.
was (Author: srahman):
Updated PR and HIVE-22433.02.patch to fix the failing qtest and changed the
logic to deserialize timestamp data type.
Note: The input timetstamp in external_jdbc_table_typeconversion.q,
external_jdbc_table_partition.q is different from the output timestamp recorded
in external_jdbc_table_typeconversion.q.out,
external_jdbc_table_partition.q.out, Hence changing the output qtest to match
with the input
> 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, HIVE-22433.02.patch,
> HIVE-22433.03.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)
