[ 
https://issues.apache.org/jira/browse/HIVE-420?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12704795#action_12704795
 ] 

Zheng Shao commented on HIVE-420:
---------------------------------

Regex for everything except strings starting with "ab":
{code}
"(ab.*)?+.+"
a
b
ab
abc
abcd
cab
abc
aab
baba
{code}


> 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
>            Priority: Minor
>
> 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.

Reply via email to