On Fri, Aug 20, 2010 at 8:37 AM, Ronak Bhatt ronakb...@gmail.com wrote:
Hi - I've a following SQL query. What is the way to convert it into HIVE
runnable format -
Select a.id, count(b.url)
from a, b
where a.id = b.id
and (b.url like '%google.com%' or b.url like '%h.google.com%' or b.url
*I read somewhere that hive does NOT support OR conditionthat's what I
was wondering as to how others handle the situation.*
*
*
On Fri, Aug 20, 2010 at 8:30 AM, Jacob R Rideout apa...@jacobrideout.netwrote:
On Fri, Aug 20, 2010 at 8:37 AM, Ronak Bhatt ronakb...@gmail.com wrote:
Hi -
It definitely does support it.
http://wiki.apache.org/hadoop/Hive/LanguageManual/UDF#Logical_Operators
On Fri, Aug 20, 2010 at 11:37 AM, Ronak Bhatt ronakb...@gmail.com wrote:
I read somewhere that hive does NOT support OR conditionthat's what I
was wondering as to how others handle the