Sudhir Srinivas
03/25/2025, 9:33 PMMayank
Sudhir Srinivas
03/26/2025, 4:13 AMSELECT 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.
SELECT property_value, DISTINCTCOUNTHLL(patient_id)
FROM dev1_hypercube
WHERE property_type IN ('Concept', 'Biomarker Tested')
GROUP BY property_value;Xiang Fu
Xiang Fu
Xiang Fu