FAQ
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.

Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 2 | next ›
Discussion Overview
groupimpala-user @
categorieshadoop
postedApr 20, '14 at 3:51a
activeApr 21, '14 at 5:39a
posts2
users2
websitecloudera.com
irc#hadoop

2 users in discussion

John Meza: 1 post Marcel Kornacker: 1 post

People

Translate

site design / logo © 2022 Grokbase