[
https://issues.apache.org/jira/browse/HIVE-23176?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17083066#comment-17083066
]
Zoltan Haindrich commented on HIVE-23176:
-----------------------------------------
I don't understand why this feature should be removed - is there any other
feature which could be used instead?
I think the ability to select/deselect column programmatically is a usefull
feature - even more in a world where people tend to create tables with >100
columns...
I don't think there is anything like this in the standard - or is there any?
> Remove SELECT REGEX Column Feature
> ----------------------------------
>
> Key: HIVE-23176
> URL: https://issues.apache.org/jira/browse/HIVE-23176
> Project: Hive
> Issue Type: Improvement
> Reporter: David Mollitor
> Assignee: David Mollitor
> Priority: Major
> Attachments: HIVE-23176.1.patch, HIVE-23176.2.patch,
> HIVE-23176.3.patch, HIVE-23176.4.patch, HIVE-23176.4.patch
>
>
> 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]
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
