[
https://issues.apache.org/jira/browse/CALCITE-6568?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tanner Clary updated CALCITE-6568:
----------------------------------
Description:
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
was:
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
> 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
> Priority: Major
>
> 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)
