Using INDEX inside SUBSTR

[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