[FLINK-12625] Support catalogs in SQL Client

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.9.0
• Component/s: Table SQL / Client
• Labels: pull-request-available
• Assignee: Bowen Li
• Reporter: Bowen Li
• Created: 26/May/19 04:18
• Updated: 14/Nov/19 21:00
• Resolved: 14/Nov/19 21:00

Description

An umbrella ticket for making SQL Client work with Catalog APIs

Issue Links

• relates to: FLINK-11275 Unified Catalog APIs
• links to: GitHub Pull Request #8589

Sub-Tasks

• Client should not register table-source-sink twice in TableEnvironment: Closed
• Support catalogs in SQL-Client yaml config file: Closed
• Document how to configure and use catalogs in SQL CLI: Closed
• Add descriptor, validator, and factory for GenericInMemoryCatalog: Closed
• Add descriptor, validator, and factory for HiveCatalog: Closed
• Support 'default-database' config for catalog entries in SQL CLI yaml file: Closed
• support 'properties' in catalog entries in SQL CLI yaml file: Closed
• deprecate descriptor, validator, and factory of ExternalCatalog: Closed
• support 'show catalogs' and 'show databases' functionalities end-2-end in TableEnvironment and SQL CLI: Closed
• support "use catalog" and "use database" in SQL CLI: Closed
• add commented-out defaults to sql client yaml file to make it easier for users to adopt: Closed
• remember current catalog and database in SQL CLI SessionContext: Closed
• modify 'use database' syntax in SQL CLI to be consistant with standard sql: Closed
• add end-to-end tests for "USE CATALOG" and "USE DATABASE" commands in SQL CLI: Closed
• set current catalog and database after registering tables and views in SQL CLI: Closed