04-30-2018 11:22 PM
How to find the position of second occurred character in a string in hive.
if I run SELECT INSTR('ALLEN','L',1,2) FROM DUAL in oracle it will return the position of the second occurance of the character "L" i.e. is 2.
But how can I achieve this in hive.