hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "David Mollitor (Jira)" <>
Subject [jira] [Commented] (HIVE-23176) Remove SELECT REGEX Column Feature
Date Tue, 14 Apr 2020 13:36:00 GMT


David Mollitor commented on HIVE-23176:

bq.  is there any other feature which could be used instead?

In MySQL, one can query {{information_schema}} to get the column names

> Remove SELECT REGEX Column Feature
> ----------------------------------
>                 Key: HIVE-23176
>                 URL:
>             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,
> 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.
> []
> []

This message was sent by Atlassian Jira

View raw message