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

Kirill Kozlov edited comment on BEAM-7610 at 3/25/20, 6:10 PM:
---------------------------------------------------------------

The underlying issue was fixed in Calcite. Updating vendored Calite to version 
1.22.0 or later should fix this issue.
Not actively working on this, will move to Unassigned.


was (Author: kirillkozlov):
The underlying issue was fixed in Calcite. Updating vendored Calite to version 
1.22.0 or later should fix this issue.

> SELECT COALESCE(...) isn't inferred as non-nullable field
> ---------------------------------------------------------
>
>                 Key: BEAM-7610
>                 URL: https://issues.apache.org/jira/browse/BEAM-7610
>             Project: Beam
>          Issue Type: Bug
>          Components: dsl-sql
>    Affects Versions: 2.13.0
>            Reporter: Gleb Kanterov
>            Priority: Major
>
> In Calcite, Coalesce is described as:
> {code}
> ReturnTypes.cascade(ReturnTypes.LEAST_RESTRICTIVE,
>             SqlTypeTransforms.LEAST_NULLABLE)
> {code}
> However, giving non-null constant as an argument doesn't result in a 
> non-nullable expression:
> {code}
>     Schema inputSchema = Schema.of(
>         Schema.Field.of("name", Schema.FieldType.STRING.withNullable(true)));
>     PCollection<Row> input = p.apply(Create.of(ImmutableList.<Row>of())
>         .withCoder(SchemaCoder.of(inputSchema)));
>     Schema outputSchema = input
>         .apply(SqlTransform.query("SELECT COALESCE(name, 'unknown') as name 
> FROM PCOLLECTION"))
>         .getSchema();
>     assertEquals(
>         Schema.builder().addStringField("name").build(),
>         outputSchema);
> {code}
> Not sure if it's a problem in Calcite or Beam SQL.
> There are no other functions that can be used to produce a non-nullable field.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to