[
https://issues.apache.org/jira/browse/HIVE-23176?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17080653#comment-17080653
]
David Mollitor commented on HIVE-23176:
---------------------------------------
*
https://stackoverflow.com/questions/7450750/selecting-column-using-regexp-in-mysql
* http://bogiecom.com/2013/01/mysql-regex-column-name-selection/
*
https://stackoverflow.com/questions/16002690/regular-expression-to-get-selected-columns
*
https://stackoverflow.com/questions/22532419/sql-query-for-searching-column-name-in-database
This is supported in other RDBMS, but it's not baked in. It is possible to do
this, but with some extra leg work for the client.
> Remove REGEX Column Feature
> ---------------------------
>
> Key: HIVE-23176
> URL: https://issues.apache.org/jira/browse/HIVE-23176
> Project: Hive
> Issue Type: Improvement
> Reporter: David Mollitor
> Priority: Major
>
> 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)
