[ 
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)

Reply via email to