[GitHub] [druid] albertojarabo opened a new issue, #13743: Problem with SELECT COUNT(DISTINCT __FIELD__))

[via GitHub]

albertojarabo opened a new issue, #13743:
URL: https://github.com/apache/druid/issues/13743

   I wonder why Apache Druid generates different results when executing two 
queries that apparently should return the same results. The queries have been 
executed with the same data in the table involved:
   
   Query 1: 
   <img width="311" alt="select_distinct_1_druid" 
src="https://user-images.githubusercontent.com/7034464/216316988-b2a23e75-dc7e-49d4-8e91-7d012164ac62.PNG";>
   
   
   Query 2:
   <img width="345" alt="select_distinct_2_druid" 
src="https://user-images.githubusercontent.com/7034464/216317044-be399b4a-3a7b-40f2-b0b2-ee8b8418adb3.PNG";>
   
   On HIVE tables with the same data, the result obtained with both queries is 
the same as Query 2 in Druid. I suspect that there is some problem when 
executing the query with COUNT(DISTINCT __FIELD__))


-- 
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.

To unsubscribe, e-mail: commits-unsubscr...@druid.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@druid.apache.org
For additional commands, e-mail: commits-h...@druid.apache.org