Hi, You need to use "*rlike '\\s' * to escape the single backslash.
Regards Tanvi Thacker On Mon, Nov 12, 2018 at 3:02 AM [email protected] <[email protected]> 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, > 孙志禹 >
