将字符串（看起来像列表）拆分为Hive中的值列表

I would like to split an input string which looks like a list into a comma separated strings. Is there a better way to do it. The below SQL doesn't remove the brackets. I would like to split an input string which loo