[jira] [Created] (FLINK-26712) Metadata keys should not conflict with physical columns

["Timo Walther (Jira)" <ji...@apache.org>]

Timo Walther created FLINK-26712:
------------------------------------

             Summary: Metadata keys should not conflict with physical columns
                 Key: FLINK-26712
                 URL: https://issues.apache.org/jira/browse/FLINK-26712
             Project: Flink
          Issue Type: Sub-task
          Components: Table SQL / API
            Reporter: Timo Walther


If you have an field called timestamp and in addition want to read the timestamp from the metadata:

{code}
CREATE TABLE animal_sightings_with_metadata (
  `timestamp` TIMESTAMP(3),
  `name` STRING,
  `country` STRING,
  `number` INT,
  `append_time` TIMESTAMP(3) METADATA FROM 'timestamp',
  `partition` BIGINT METADATA VIRTUAL,
  `offset` BIGINT METADATA VIRTUAL,
  `headers` MAP<STRING, BYTES> METADATA,
  `timestamp-type` STRING METADATA,
  `leader-epoch` INT METADATA,
  `topic` STRING METADATA
)
{code}

This gives:
{code}
[ERROR] Could not execute SQL statement. Reason:
org.apache.flink.table.api.ValidationException: Field names must be unique. Found duplicates: [timestamp]
{code}



--
This message was sent by Atlassian Jira
(v8.20.1#820001)