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
