Returns the approximate number of rows that contain distinct values in a column. Ignores rows that contain a null value for the column.
APPROX_COUNT_DISTINCT(column_name ANY) → INT or BIGINT
- column_name: The column can contain values of any data type.
SELECT APPROX_COUNT_DISTINCT(business_id) AS "number_of_businesses" FROM "restaurant_reviews.parquet"; -- 62
Was this page helpful?
Glad to hear it! Thank you for your feedback. Sorry to hear that. Thank you for your feedback.