This seems like it would work. Thanks, Thomas
-----Original Message----- From: Nitin Pawar [mailto:nitinpawar...@gmail.com] Sent: Tuesday, April 24, 2012 3:31 AM To: user@hive.apache.org Subject: Re: Possible to use regex column specification with WHERE clause? 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.rya...@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
