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

Posted to issues@beam.apache.org by "Kenneth Knowles (Jira)" <ji...@apache.org> on 2022/06/03 22:51:00 UTC

[jira] [Commented] (BEAM-5789) [SQL] CASE CAST(.. as DATE) ELSE NULL doesn't work

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

Kenneth Knowles commented on BEAM-5789:
---------------------------------------

This issue has been migrated to https://github.com/apache/beam/issues/19155

> [SQL] CASE CAST(.. as DATE) ELSE NULL doesn't work
> --------------------------------------------------
>
>                 Key: BEAM-5789
>                 URL: https://issues.apache.org/jira/browse/BEAM-5789
>             Project: Beam
>          Issue Type: Bug
>          Components: dsl-sql
>            Reporter: Anton Kedin
>            Priority: P3
>
> CASE CAST(.. as DATE) ELSE NULL    seem to result in multiple conversions from string to date. That chain seems to fail as one of the string representations of the date is not supported by CAST expression.
> Source: https://stackoverflow.com/questions/52861989/how-does-calcite-deal-with-data-conversion/52878780



--
This message was sent by Atlassian Jira
(v8.20.7#820007)