BigQuery で COUNT(DISTINCT(X)) を使わない方が良い理由

f:id:shiyamaz:20141019090541p:plain BigQuery で COUNT(DISTINCT(X)) を使わない方が良い理由:

BigQuery で COUNT(DISTINCT(X)) を使わない方が良い理由
Returns the total number of non-NULL values in the scope of the function. If you use the DISTINCT keyword, the function returns the number of distinct values for the specified field. Note that the returned value for DISTINCT is a statistical approximation and is not guaranteed to be exact.
October 19, 2014 at 08:44AM


from Tumblr http://shiyamaz.tumblr.com/post/100362338253