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

One Star

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

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. 
Community Manager

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

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.
----------------------------------------------------------
Talend | Data Agility for Modern Business