René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Unimplemented error when the output table contains timestamp with timezone","articleBody":"### Describe the bug, including details regarding any error messages, version, and platform.\n\n# Description\n\nWhen we create a table with the following schema (the `ts` column is a timestamp with a time zone)：\n\n![Image](https://github.com/user-attachments/assets/eaaedc18-5727-4cd5-bc50-83285527815b)\n\nThen we query this table, its output will report unimplemented error:\n\n![Image](https://github.com/user-attachments/assets/391fb93c-94e7-4e25-958a-a577c9fcd15f)\n\nBut if we change the flight sql jdbc driver from 18.3.0 to 18.2.0 or earlier, the ouput is just fine.\n\n# Plantform\n\n- Client: DBeaver Community Edition 25.1.0\n- Operating System: Windows 10 19045.5965\n- Database: datalayers (our proprietary database)\n- Driver: flight-sql-jdbc-driver 18.3.0\n\n# Potential reasons\n\nThe 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.","author":{"url":"https://github.com/Ke-Wng","@type":"Person","name":"Ke-Wng"},"datePublished":"2025-06-13T09:35:06.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":5},"url":"https://github.com/787/arrow-java/issues/787"}