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?

https://cwiki.apache.org/Hive/languagemanual-udf.html#LanguageManualUDF-StringFunctions
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
>
>
>