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

Switch to Plain View
Hive, mail # user - Using INDEX inside SUBSTR


+
dyuti a 2013-07-10, 12:06
Copy link to this message
-
Re: Using INDEX inside SUBSTR
Stephen Sprague 2013-07-10, 13:35
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
>
>
>