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