hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nitin Pawar <nitinpawar...@gmail.com>
Subject Re: Possible to use regex column specification with WHERE clause?
Date Tue, 24 Apr 2012 07:30:44 GMT
you may want to have a programmatic approach for doing this and
provide hive with a final query.

You can solve this with either solving your regular expression outside
hive paradigm and then provide the query to hive


On 4/23/12, Ryabin, Thomas <Tom.Ryabin@mckesson.com> wrote:
> Hi,
>
>
>
> I know that it is possible to use regex column specification with the
> SELECT clause like so:
>
> SELECT `employee.*` FROM employees;
>
>
>
> I was wondering if it is possible to use it with the WHERE clause also.
> For example I want to create the query:
>
> SELECT `employee.*` FROM employees WHERE $1 = 'Steve';
>
>
>
> where $1 represents a column that was matched by the regex. Any ideas?
>
>
>
> Thanks,
>
> Thomas Ryabin
>
>


-- 
Nitin Pawar

Mime
View raw message