[HIVE-23717] In jdbcUrl add config to create External + purge table by default

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.1.0
• Fix Version/s: 4.0.0-alpha-1
• Component/s: HiveServer2, Metastore
• Labels: pull-request-available
• Target Version/s: 3.1.0
• Assignee: Xiaomeng Zhang
• Reporter: Xiaomeng Zhang
• Created: 17/Jun/20 20:40
• Updated: 17/Nov/22 08:47
• Resolved: 22/Jul/20 16:08

Description

External + purge tables are more backward compatible with the old managed tables.

Applications can use a HS2 URL that sets the session level property for default table type to external-purge tables to be true.
As part of this we need a notion of a "session level only" config parameter(s).

Adding a new jdbc config: hiveCreateAsExternalLegacy, a hs2 config hive.create.as.external.legacy, when set to true, create external purge table by default.

Adding MANAGED keyword. "create managed table" will create table based on hive.create.as.acid and hive.craete.as.insert.only values, not impacted by the new config.

Issue Links

• links to: GitHub Pull Request #1143