You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by "Tanner Clary (Jira)" <ji...@apache.org> on 2024/09/09 23:27:00 UTC

[jira] [Created] (CALCITE-6568) Snowflake incorrectly unparses BigQuery's TIMESTAMP() function

Tanner Clary created CALCITE-6568:
-------------------------------------

             Summary: Snowflake incorrectly unparses BigQuery's TIMESTAMP() function
                 Key: CALCITE-6568
                 URL: https://issues.apache.org/jira/browse/CALCITE-6568
             Project: Calcite
          Issue Type: Bug
            Reporter: Tanner Clary


BigQuery offers the [TIMESTAMP()](https://cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#timestamp) function which can be used to construct a BigQuery {{TIMESTAMP}} (a Calcite {{TIMESTAMP_LTZ}}).

 Currently if this function is invoked with Snowflake as the "target" dialect, the {{RelToSqlConverter}} does not unparse it into the Snowflake analogue, {{TIMESTAMP_LTZ}} [1]

[1] This migration guide identifies the Snowflake equivalent for many BigQuery functions. 
https://cloud.google.com/bigquery/docs/migration/snowflake-sql



--
This message was sent by Atlassian Jira
(v8.20.10#820010)