Re: Insert based on whether string contains

2012-01-04 Thread bejoy_ks
Message- From: "Tucker, Matt" Date: Wed, 4 Jan 2012 08:56:44 To: user@hive.apache.org; Bejoy Ks Reply-To: user@hive.apache.org Subject: Re: Insert based on whether string contains The find_in_set() UDF is a safer choice for doing a search for that value, as %239% could also match 2390,

Re: Insert based on whether string contains

2012-01-04 Thread Tucker, Matt
n FROM omniture WHERE event_list LIKE ‘%239%’; Hope it helps!.. Regards, Bejoy.K.S From: Dave Houston mailto:r...@crankyadmin.net>> To: user@hive.apache.org<mailto:user@hive.apache.org> Sent: Wednesday, January 4, 2012 6:41 PM Subject: Insert based on

Re: Insert based on whether string contains

2012-01-04 Thread Bejoy Ks
, visid_low), geo_city, geo_country, geo_region FROM omniture WHERE event_list LIKE  ‘%239%’;   Hope it helps!..   Regards, Bejoy.K.S From: Dave Houston To: user@hive.apache.org Sent: Wednesday, January 4, 2012 6:41 PM Subject: Insert based on whether string

Insert based on whether string contains

2012-01-04 Thread Dave Houston
Hi there, i have a string that has '239, 236, 232, 934' (not always in that order) and want to insert into another table if 239 is in the string. INSERT OVERWRITE TABLE video_plays_for_sept SELECT concat(visid_high, visid_low), geo_city, geo_country, geo_region from omniture where regexp_extrac