You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Tanner Clary (Jira)" <ji...@apache.org> on 2024/01/05 01:08:00 UTC

[jira] [Comment Edited] (CALCITE-6186) Enable DATEDIFF for Snowflake, map to BigQuery equivalents

    [ https://issues.apache.org/jira/browse/CALCITE-6186?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17803374#comment-17803374 ] 

Tanner Clary edited comment on CALCITE-6186 at 1/5/24 1:07 AM:
---------------------------------------------------------------

Hey [~julianhyde] I added a Proof of Concept here: https://github.com/apache/calcite/pull/3613

Leave any comments, styling and whatnot will get cleaned up but wanted your thoughts on the initial implementation.


was (Author: JIRAUSER298151):
Hey [~julianhyde] I added a Proof of Concept here: https://github.com/tanclary/calcite/commit/72815dbbe6894d4bb4cb938b5dab090b28f1047b

Leave any comments, styling and whatnot will get cleaned up but wanted your thoughts on the initial implementation.

> Enable DATEDIFF for Snowflake, map to BigQuery equivalents
> ----------------------------------------------------------
>
>                 Key: CALCITE-6186
>                 URL: https://issues.apache.org/jira/browse/CALCITE-6186
>             Project: Calcite
>          Issue Type: Improvement
>            Reporter: Tanner Clary
>            Assignee: Tanner Clary
>            Priority: Major
>
> (Any suggestions for a better title would be helpful).
> Snowflake supports the DATEDIFF function: https://docs.snowflake.com/en/sql-reference/functions/datediff
> This is equivalent to the BigQuery TIMESTAMP/TIME/DATE/DATETIME_DIFF functions according to: https://cloud.google.com/bigquery/docs/migration/snowflake-sql#date_and_time_functions
> The operands are reorder but otherwise the functions operate similarly



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