hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ryabin, Thomas" <Tom.Rya...@McKesson.com>
Subject Possible to use regex column specification with WHERE clause?
Date Mon, 23 Apr 2012 13:43:57 GMT
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


Mime
View raw message