[FLINK-12846] Carry primary key and unique key information in TableSchema

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Component/s: Table SQL / API
• Labels: pull-request-available
• Assignee: Jark Wu
• Reporter: Jark Wu
• Created: 14/Jun/19 07:36
• Updated: 08/Dec/19 05:08
• Resolved: 04/Dec/19 04:14

Description

The primary key and unique key is a standard meta information in SQL. And they are important information for optimization, for example, AggregateRemove, AggregateReduceGrouping and state layout optimization for TopN and Join.

So in this issue, we want to extend TableSchema to carry more information about primary key and unique keys. So that the TableSource can declare this meta information.

Issue Links

• is a child of: FLINK-11492 Support the full Blink SQL runtime
• is duplicated by: FLINK-14978 Introduce constraint class hierarchy required for primary keys
• links to: GitHub Pull Request #8736
• links to: GitHub Pull Request #10213