Thank you very much for your help and your prompt reply.   So perhaps creating a UDF that returns an array and then split the array can be a workaround. According to the documentation a UDF can't return a complex type but is this still true for CDH 5.5+ ? Because according to this complex types are support from cloudera now.   So to summarize my question, is it possible to write a UDF that takes the comma delimited string and returns an array of strings using Impala UDFs? ... View more