[HIVE-23176] Remove SELECT REGEX Column Feature

• Type: Improvement
• Status: Patch Available
• Priority: Major
• Resolution: Unresolved
• Labels: backward-incompatible
• Target Version/s: 4.0.0
• Assignee: David Mollitor
• Reporter: David Mollitor
• Created: 10/Apr/20 15:02
• Updated: 17/Nov/22 11:31

Description

Remove the Hive feature: REGEX Column.

 

Hive has this interesting feature for doing REGEX to SELECT multiple columns.  This needs to go.  It is not SQL standard and as currently implemented, it is impossible to determine if a column identifier is a REGEX or the actual name of the column.  If a column name is enclosed in back ticks then any UTF-8 character is a valid table name.

 

https://dev.mysql.com/doc/refman/8.0/en/identifiers.html

https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Select

Issue Links

• is depended upon by: HIVE-23172 Quoted Backtick Columns Are Not Parsing Correctly
• is related to: HIVE-16496 Enhance asterisk expression (as in "select *") with EXCLUDE clause
• supercedes: HIVE-17310 Regex column referencing in aggregate functions/group by
• supercedes: HIVE-7631 Add support for NOT operator in column regex
• supercedes: HIVE-23182 Semantic Exception: rule Identifier failed predicate allowQuotedId
• links to: Hive Dev Mailing List Thread