Ganesh Tripathi created HIVE-17567:
--------------------------------------
Summary: CONCAT in sub-query isn't working
Key: HIVE-17567
URL: https://issues.apache.org/jira/browse/HIVE-17567
Project: Hive
Issue Type: Bug
Components: CLI, Hive
Affects Versions: 1.1.0
Environment: cdh5.12.1
Reporter: Ganesh Tripathi
* Normal Concat keywords works.
{code:java}
select concat("('", concat_ws("|", collect_set(value) ), "')") from some_table;
{code}
* rlike is also working fine :
{code:java}
select a.values from some_table a where a.value_list rlike ('1234|234.2')
{code}
* when concat is used in sub-query :
{code:java}
select a.values from some_table a where a.values rlike( select concat("('",
concat_ws("|", collect_set(value) ), "')") from some_table );
{code}
* A error is thrown :
{code:java}
FAILED: ParseException line 2:2 cannot recognize input near 'select' 'concat'
'(' in expression specification
{code}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
