It did help, thanks!
Regards, 孙志禹 From: Tanvi Thacker Date: 2018-11-15 06:06 To: user Subject: Re: Rlike '\s' couldn't get the space Hi, You need to use "rlike '\\s' to escape the single backslash. Regards Tanvi Thacker On Mon, Nov 12, 2018 at 3:02 AM anci_...@yahoo.com <anci_...@yahoo.com> wrote: Dears, I see that using '\s' can get the whitespace character in normal java regular expressions, but in HIVE I found it couldn't. Why? And is there any other differences between the regular expressions in JAVA and HIVE? Regards, 孙志禹