[GitHub] [incubator-doris] qdore opened a new issue #794: Use funciton (count and HLL_UNION_AGG) in one column cause doris return wrong value

Fri, 22 Mar 2019 02:51:37 -0700 

qdore opened a new issue #794: Use funciton (count and HLL_UNION_AGG) in one 
column cause doris return wrong value
URL: https://github.com/apache/incubator-doris/issues/794
 
 
   **Describe the bug**
   
   The following sql cause doris return wrong value:
   ```
   SELECT DATE(event_day) AS __timestamp,
          if (true, HLL_UNION_AGG(uv),count(distinc(cuid)))
       FROM visd_novel_searchbox_operate_hll
       WHERE event_day >= STR_TO_DATE('2019-03-15 00:00:00', '%Y-%m-%d 
%H:%i:%s') AND 
             event_day <= STR_TO_DATE('2019-03-22 00:00:00', '%Y-%m-%d 
%H:%i:%s') AND 
             ((bdcloud_module_app_name = 'tcbox'     and bdcloud_cateid = 1     
 and evtType = 'show'     and evtName = 'novel-detail'))
    GROUP BY DATE(event_day)
    LIMIT 100;
   ```
   
   **To Reproduce**
   Steps to reproduce the behavior:
   1. Use COUNT and HLL_UNION_AGG in a column with function like IF or COALESCE.
   2. The function always return 1.
   
   **Expected behavior**
   return 
   
   **Screenshots**
   <img width="711" alt="MacHi 2019-03-22 17-47-57" 
src="https://user-images.githubusercontent.com/6831829/54814422-a95c1600-4cca-11e9-8f77-efa4cbd33dd0.png";>

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
[email protected]


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to