[
https://issues.apache.org/jira/browse/HIVE-420?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12705131#action_12705131
]
Zheng Shao commented on HIVE-420:
---------------------------------
@Amr, I think we don't need ^ and $ for regex matching. We only need that for
regex searching in case the searched regex has to start from the beginning of
the string or the end of the string.
For matching, the whole string has to be matched with the regex, so there is no
need for ^ and $.
What do you think?
You can try my examples out at http://www.fileformat.info/tool/regex.htm
> Support regular expressions for column in select clause
> -------------------------------------------------------
>
> Key: HIVE-420
> URL: https://issues.apache.org/jira/browse/HIVE-420
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Query Processor
> Affects Versions: 0.2.0, 0.3.0, 0.3.1, 0.4.0
> Reporter: Prasad Chakka
> Assignee: Zheng Shao
> Priority: Minor
> Fix For: 0.4.0
>
> Attachments: HIVE-420.1.patch, HIVE-420.2.patch, HIVE-420.3.patch,
> HIVE-420.4.patch
>
>
> support queries like `select a.[^ds] from a where a.ds='2009-09-09'` which
> are useful when there are humongous number of columns in a table and want to
> select all columns except the partitions columns.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
