[I] Unimplemented error when the output table contains timestamp with timezone [arrow-java]

[via GitHub]

Ke-Wng opened a new issue, #787:
URL: https://github.com/apache/arrow-java/issues/787

   ### Describe the bug, including details regarding any error messages, 
version, and platform.
   
   # Description
   
   When we create a table with the following schema (the `ts` column is a 
timestamp with a time zone)：
   
   
![Image](https://github.com/user-attachments/assets/eaaedc18-5727-4cd5-bc50-83285527815b)
   
   Then we query this table, its output will report unimplemented error:
   
   
![Image](https://github.com/user-attachments/assets/391fb93c-94e7-4e25-958a-a577c9fcd15f)
   
   But if we change the flight sql jdbc driver from 18.3.0 to 18.2.0 or 
earlier, the ouput is just fine.
   
   # Plantform
   
   - Client: DBeaver Community Edition 25.1.0
   - Operating System: Windows 10 19045.5965
   - Database: datalayers (our proprietary database)
   - Driver: flight-sql-jdbc-driver 18.3.0
   
   # Potential reasons
   
   The error messages suggest the issue stems from [Arrow-Java 
18.3.0](https://github.com/apache/arrow-java) is dependent on [Calcite-Avatica 
1.26.0](https://github.com/apache/calcite-avatica/tree/rel/avatica-1.26.0). It 
appears Calcite-Avatica 1.26.0 doesn't support timestamp types with timezone in 
query result sets. In contrast, Arrow-Java 18.2.0 and earlier versions rely on 
Calcite-Avatica 1.25.0 (as seen in 
https://github.com/apache/arrow-java/pull/634), which explains why their query 
result sets are correct.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscr...@arrow.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org