bcbilgin opened a new issue #12493: URL: https://github.com/apache/superset/issues/12493
Hi, It's version 0.36.0. I try to subtract two metric columns; like column1-column2. I need distinct counts here so my first number will be COUNT_DISTINCT(column1) and second one is COUNT_DISTINCT(column2). This works:  This does not work:  The error is: > druid error: Unknown exception (org.apache.calcite.tools.ValidationException): org.apache.calcite.runtime.CalciteContextException: From line 7, column 8 to line 7, column 30: No match found for function signature COUNT_DISTINCT(<CHARACTER>) Note that COUNT_DISTINCT() function -like COUNT() function- works for both column1 and column2. Is this intentional? What is the difference between subtraction on counts and subtraction on distinct counts? ---------------------------------------------------------------- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
