type of the expression must be an array but resolved to string

[Anonymous]

Using tELTHiveMap component I am trying to join between 2 tables.  The join condition is a bit complex:

table1.col1 = trim(substring(regexp_replace(upper(table2.col2), ""," ")), 0, instr(trim(regexp_replace(upper(table2.col2), ""," "),' ')))

It is basically get the first word in uppercase from table2.col2.
The TOS gives the error "type of the expression must be an array but it resolved to string"
How do I resolve this?
The generated Select statement runs through Hive command line successfully. 

[Anonymous]

Hi
Where do you input this expression? Can you please upload a screenshot of component settings? It will be helpful for us to find the problem.