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 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 > > >