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 ';'?

Highlighted

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

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?

Don't have an account?
Coming from Hortonworks? Activate your account here