impala string function to extract text after a given separator
Use split_part(string source, string delimiter, bigint n) function. The value of n would be as the fields are numbered starting from 1.
select split_part('633000000HIQWA4:005160000UT334',':',2);+----------------------------------------------------+| split_part('633000000HIQWA4:005160000UT334',':',2) |+----------------------------------------------------+| 005160000UT334 |+----------------------------------------------------+