...
- Default Value: CONSERVATIVE
- Possible Values:
- "NEVER", never use the legacy optimizer (all CBO errors are fatal).
- "ALWAYS", always use the legacy optimizer (CBO errors are not fatal).
- "CONSERVATIVE", use the legacy optimizer only when the CBO error is not related to subqueries and views.
- "TEST", specific behavior only for tests, do not use in production.
- Added In: HIVE-24601HIVE-24601
Options are "NEVER", "CONSERVATIVE", "ALWAYS", "TEST". The strategy defines when Hive fallbacks to legacy optimizer when CBO fails:
...