[jira] [Created] (HIVE-17567) CONCAT in sub-query isn't working

["Ganesh Tripathi (JIRA)" <ji...@apache.org>]

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)