Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Using INDEX inside SUBSTR

Copy link to this message
Re: Using INDEX inside SUBSTR
rather than us just do the work for you show us your attempts to solve
this.  hint: did you look at this page?

On Wed, Jul 10, 2013 at 5:06 AM, dyuti a <[EMAIL PROTECTED]> wrote:

> Hi All,
> One of my Teradata query is
> SUBSTR(PRESG_ID,INDEX(PRESG_ID,' ')+1,1) IN  ('1','2','3')
> Any idea of the above to convert to hive, It seems to be a simple qus but
> am stuck...didn't get a chance to try it out in cluster :(
> -Thanks