[Bug] JDBC driver Incorrect/different results with getDate, getTimestamp and getTime with Calendar in ResultSet

[KHassain]

Code of Conduct

• I agree to follow this project's Code of Conduct

Search before asking

• I have searched in the issues and found no similar issues.

Describe the bug

Hi Team,

when we use kyuubi-hive-jdbc-shaded-1.9.2 driver from tableau we are getting different values for date and timestamp with different time zone.

for Eg:

Date field.

Actual value --> 2024-01-15 , in tableau it is showing as 2024-01-14

Timestamp field

Actual value --> 2023-05-04 06:24:58 In tableau desktop if I'm using from IST time zone it is showing as 2023-05-04 00:54:58

if I'm Tableau desktop from CE time zone it is showing as 2023-05-04 04:24:58 and using BST time zone 2023-05-04 05:24:58

we are suspecting somewhere Date and timestamp field are convert into epoch time and resulting out into UTC .

Is there any way that we need avoid the conversions and display the actual value .
Date_Time_Tableau_issue.xlsx

Affects Version(s)

1.9.2

Kyuubi Server Log Output

No response

Kyuubi Engine Log Output

No response

Kyuubi Server Configurations

No response

Kyuubi Engine Configurations

No response

Additional context

No response

Are you willing to submit PR?

• Yes. I would be willing to submit a PR with guidance from the Kyuubi community to fix.
• No. I cannot submit a PR at this time.

[github-actions]

Hello @KHassain,
Thanks for finding the time to report the issue!
We really appreciate the community's efforts to improve Apache Kyuubi.