[FLINK-23549] Kafka table connector create table example in docs has syntax error

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.13.1
• Fix Version/s: 1.15.0
• Component/s: Connectors / Kafka, Documentation
• Labels: connector doc example kafka pull-request-available stale-assigned syntax table
• Assignee: Mans Singh
• Reporter: Mans Singh
• Created: 29/Jul/21 23:34
• Updated: 12/Oct/21 13:28
• Resolved: 12/Oct/21 06:32

Description

The create table example in the docs has an syntax error (extra comma after the opening bracket):

CREATE TABLE KafkaTable (,
`ts` TIMESTAMP(3) METADATA FROM 'timestamp',
`user_id` BIGINT,
`item_id` BIGINT,
`behavior` STRING
) WITH (
'connector' = 'kafka',
...
)

On executing in the FlinkSQL it produces an error:

[ERROR] Could not execute SQL statement. Reason:
org.apache.flink.sql.parser.impl.ParseException: Encountered "," at line 1, column 26.

Issue Links

• links to: GitHub Pull Request #16639