[HIVE-17567] CONCAT in sub-query isn't working - ASF JIRA

XML

Word

Printable

JSON

Normal Concat keywords works.

select concat("('", concat_ws("|", collect_set(value) ), "')") from some_table;

rlike is also working fine :

select a.values from some_table a where a.value_list rlike ('1234|234.2')

when concat is used in sub-query :

select a.values from some_table a where a.values rlike( select concat("('", concat_ws("|", collect_set(value) ), "')") from some_table );

A error is thrown :

FAILED: ParseException line 2:2 cannot recognize input near 'select' 'concat' '(' in expression specification