hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stephen Sprague <sprag...@gmail.com>
Subject Re: Using INDEX inside SUBSTR
Date Wed, 10 Jul 2013 13:35:37 GMT
rather than us just do the work for you show us your attempts to solve
this.  hint: did you look at this page?

https://cwiki.apache.org/Hive/languagemanual-udf.html#LanguageManualUDF-StringFunctions


On Wed, Jul 10, 2013 at 5:06 AM, dyuti a <hadoop.hive04@gmail.com> 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
>
>
>

Mime
View raw message