Querying ClickHouse data without duplicates

The resulting ClickHouse tables use the ReplacingMergeTree table engine in order to efficiently upsert changes. To properly query this data, the FINAL keyword must be used when selecting from these tables guarantee duplicates are removed. For example:

  SELECT  *  FROM schema.table FINAL
  WHERE
  foo = bar
 ORDER BY foo
 LIMIT 10;