[
https://issues.apache.org/jira/browse/BEAM-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Anton Kedin updated BEAM-5789:
------------------------------
Description:
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
was:
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/posts/52878780
> [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: Major
>
> 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
(v7.6.3#76005)