Re: documentation issue for RLIKE/REGEXP

2013-08-11 Thread Lefty Leverenz
It's fixed: "E.g. 'foobar' RLIKE 'foo' evaluates to TRUE and so does 'foobar' RLIKE '^f.*r$'." https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF Thanks, all. On Sun, Aug 11, 2013 at 11:03 AM, Dean Wampler wrote: > I just confirmed that for Hive v0.10 (and probably all versio

Re: documentation issue for RLIKE/REGEXP

2013-08-11 Thread Dean Wampler
I just confirmed that for Hive v0.10 (and probably all versions) "foobar" rlike "foo" returns true, just to be clear. In other words, the Java regular expression does NOT have to match the whole string. The wiki should be changed. If someone wants to give me permission, I'll do it ;) dean On Fr

Re: documentation issue for RLIKE/REGEXP

2013-08-09 Thread Lefty Leverenz
1) Did you miss the first word? ("NULL if A or B is NULL") 2) Darren Yin posted a similar message to the user liston August 1st (or July 31st in some time zones)

documentation issue for RLIKE/REGEXP

2013-08-08 Thread Sergey Shelukhin
Double checking before I try to edit. The page here: https://cwiki.apache.org/Hive/languagemanual-udf.html says: A RLIKE B if A or B is NULL, TRUE if any (possibly empty) substring of A matches the Java regular expression B, otherwise FALSE. E.g. 'foobar' RLIKE 'foo' evaluates to FALSE whereas