[ https://issues.apache.org/jira/browse/BEAM-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17123057#comment-17123057 ]
Beam JIRA Bot commented on BEAM-5789: ------------------------------------- This issue is P2 but has been unassigned without any comment for 60 days so it has been labeled "stale-P2". If this issue is still affecting you, we care! Please comment and remove the label. Otherwise, in 14 days the issue will be moved to P3. Please see https://beam.apache.org/contribute/jira-priorities/ for a detailed explanation of what these priorities mean. > [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: P2 > Labels: stale-P2 > > 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.3.4#803005)