We have a table where some fields use comma and some use semi-colon as a delimiter. Is there a way I can use find_in_set() function for both types of fields?
This is going to be tricky to do. The impala builtins return single scalar values so you'll need to run
a bunch of them to parse out each columns This could be done with find_in_set, regex_extract(),
substr(), etc if you really know the schema of the data but the performance will probably not be good.
Is Hive able to query this data?