I'm looking for examples of queries with a where clause condition similiar
to:
select ipaddr, count(ipaddr), uri from tableA where year=2014 and month=2
and day=12 and uriContains("abcd") Group By ipaddr;
This query counts the number of times a unique ip address queries a uri
containing a specific string. The query returns rows with string column *uri
*containing "abcd".
I've looked at the Impala function instr, but don't see how it can be used
in the where clause.
I've tried creating a udf but can't get it to work as a where clause
condition.
This query must be well explored, with 1000's of implementations, i can't
find much info on this anywhere.
thanks
John
To unsubscribe from this group and stop receiving emails from it, send an email to impala-user+unsubscribe@cloudera.org.
