[ https://issues.apache.org/jira/browse/BEAM-7610?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17122771#comment-17122771 ]
Beam JIRA Bot commented on BEAM-7610: ------------------------------------- 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. > 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: P2 > Labels: stale-P2 > > 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)