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)