Reply
New Contributor
Posts: 1
Registered: ‎06-16-2014

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

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

Cloudera Employee
Posts: 27
Registered: ‎09-27-2013

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

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?