[
https://issues.apache.org/jira/browse/CALCITE-7170?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sanskriti Bora updated CALCITE-7170:
------------------------------------
Description:
I would like to propose adding support for binding ISO-formatted string values
to date, time, and timestamp types in Avatica. Currently, Avatica only supports
binding these types using Java objects (such as java.sql.Date, java.sql.Time,
and java.sql.Timestamp), which can be limiting for clients that work with
standard string representations.
Adding ISO string binding would improve interoperability and make it easier to
work with standard date/time formats across different clients and languages.
Simple client use case example:
{code} try (var connection =
DriverManager.getConnection("jdbc:arrow-flight://localhost:5000;useEncryption=false");
PreparedStatement createSchemaStatement = connection.prepareStatement("create
schema if not exists foo"); PreparedStatement createTableStatement =
connection.prepareStatement("create table if not exists foo.bar (t time, d
date, ts timestamp)"); PreparedStatement insertStatement =
connection.prepareStatement("insert into test values (?, ?, ?)")) {
createSchemaStatement.execute();
createTableStatement.execute();
insertStatement.setString(1, "2025-08-14T15:53:00.000Z");
insertStatement.setString(2, "2025-04-01");
insertStatement.setString(3, "21:39:50");
insertStatement.executeUpdate();
} \{code}
was:
I would like to propose adding support for binding ISO-formatted string values
to date, time, and timestamp types in Avatica. Currently, Avatica only supports
binding these types using Java objects (such as java.sql.Date, java.sql.Time,
and java.sql.Timestamp), which can be limiting for clients that work with
standard string representations.
Adding ISO string binding would improve interoperability and make it easier to
work with standard date/time formats across different clients and languages.
Simple client use case example:
{{try (var connection =
DriverManager.{_}getConnection{_}("jdbc:arrow-flight://localhost:5000;useEncryption=false");}}
{code} PreparedStatement createSchemaStatement =
connection.prepareStatement("create schema if not exists foo");
{code} PreparedStatement createTableStatement =
connection.prepareStatement("create table if not exists foo.bar (t time, d
date, ts timestamp)");
{code} PreparedStatement insertStatement = connection.prepareStatement("insert
into test values (?, ?, ?)")
{{) {}}
{\{ createSchemaStatement.execute();}}
{\{ createTableStatement.execute();}}
{\{ insertStatement.setString(1, "2025-08-14T15:53:00.000Z");}}
{\{ insertStatement.setString(2, "2025-04-01");}}
{\{ insertStatement.setString(3, "21:39:50");}}
{\{ }}
{\{ insertStatement.executeUpdate();}}
{{}}}
> Support ISO String Binding for Date/Time/Timestamp in Avatica
> -------------------------------------------------------------
>
> Key: CALCITE-7170
> URL: https://issues.apache.org/jira/browse/CALCITE-7170
> Project: Calcite
> Issue Type: Improvement
> Components: avatica
> Reporter: Sanskriti Bora
> Priority: Critical
> Labels: pull-request-available
>
> I would like to propose adding support for binding ISO-formatted string
> values to date, time, and timestamp types in Avatica. Currently, Avatica only
> supports binding these types using Java objects (such as java.sql.Date,
> java.sql.Time, and java.sql.Timestamp), which can be limiting for clients
> that work with standard string representations.
> Adding ISO string binding would improve interoperability and make it easier
> to work with standard date/time formats across different clients and
> languages.
>
> Simple client use case example:
> {code} try (var connection =
> DriverManager.getConnection("jdbc:arrow-flight://localhost:5000;useEncryption=false");
> PreparedStatement createSchemaStatement =
> connection.prepareStatement("create schema if not exists foo");
> PreparedStatement createTableStatement = connection.prepareStatement("create
> table if not exists foo.bar (t time, d date, ts timestamp)");
> PreparedStatement insertStatement = connection.prepareStatement("insert into
> test values (?, ?, ?)")) {
> createSchemaStatement.execute();
> createTableStatement.execute();
> insertStatement.setString(1, "2025-08-14T15:53:00.000Z");
> insertStatement.setString(2, "2025-04-01");
> insertStatement.setString(3, "21:39:50");
> insertStatement.executeUpdate();
> } \{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
