Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Is there a way to use Impala find_in_set() function with ';'?

Is there a way to use Impala find_in_set() function with ';'?

New Contributor

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?

 

Thanks,
Apoorva

1 REPLY 1
Highlighted

Re: Is there a way to use Impala find_in_set() function with ';'?

Contributor

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?