Thanks pxiongBut I came across the below syntax in stack overflow. Any idea
what it actually does?
Date: Thu, 20 Aug 2015 13:05:23 -0700
Subject: Re: Query doubt
From: pxi...@apache.org
To: user@hive.apache.org
Hi Rakesh,
If you would like to get all the names starting with r, you can use
select * from emp where name like 'r%';
or
select * from emp where name rlike '^r';
or
select * from emp where name regexp '^r';
Thanks.Pengcheng
On Thu, Aug 20, 2015 at 11:40 AM, rakesh sharma <rakeshsharm...@hotmail.com>
wrote:
Hi All
I am trying to get all the names starting with r.My query looks like select *
from emp where name like 'r~%';
But it doesn't result anything;
Any help
thanksrakesh
