hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zheng Shao (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-420) Support regular expressions for column in select clause
Date Fri, 01 May 2009 21:45:31 GMT

    [ 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.


Mime
View raw message