Using INDEX inside SUBSTR

2013-07-10 Thread dyuti a
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

Re: Using INDEX inside SUBSTR

2013-07-10 Thread Stephen Sprague
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.hiv...@gmail.com wrote: Hi All, One of my