[jira] [Created] (HIVE-17310) Regex column referencing in aggregate functions/group by

[Zoltan Chovan (JIRA)]

Zoltan Chovan created HIVE-17310:
------------------------------------

             Summary: Regex column referencing in aggregate functions/group by
                 Key: HIVE-17310
                 URL: https://issues.apache.org/jira/browse/HIVE-17310
             Project: Hive
          Issue Type: New Feature
            Reporter: Zoltan Chovan
            Priority: Minor


The following works as expected:

{code:java}
set hive.support.quoted.identifiers=none;
SELECT `(id|created_at)?+.+`
FROM test_table
WHERE date between "2017-07-01" and "2017-08-01";
{code}

However the query fails when adding count/group by like as follows:


{code:java}
set hive.support.quoted.identifiers=none;

SELECT count(*), `(id|created_at)?+.+`
FROM test_table
WHERE date between "2017-07-01" and "2017-08-01"
GROUP BY `(id|created_at)?+.+` ;
{code}


Currently this fails with an error. Would it be feasible to implement this 
feature?



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)