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
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
wrote:
> Hi
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
