Hi I have a simple query that uses countdistincthl...
# troubleshooting
s
Hi I have a simple query that uses countdistincthll with a where clause and group by. No rows are returned. Editing the query to use a regular count(distinct(column)) does return rows. Any idea why this is with the hll construct ?
m
Can you share the two queries?
s
I am querying a single denormalized table with patient_id (varchar), event_type (varchar), property_type (varchar) and property_value(varchar) columns Query 1: Works and returns rows
Copy code
SELECT property_value, count(distinct(patient_id)) AS distinct_patient_count 
FROM dev1_hypercube 
WHERE property_type IN ('Concept', 'Biomarker Tested') 
GROUP BY property_value;
Query 2: Executes fine but doesn't return any rows.
Copy code
SELECT property_value, DISTINCTCOUNTHLL(patient_id)
FROM dev1_hypercube
WHERE property_type IN ('Concept', 'Biomarker Tested')
GROUP BY property_value;
x
hmm, can you run the query without group By and if there is any return for the hll query?
Also which Pinot version are you running
Can you also paste the query response stats here