Scratch Table has triple the records

When creating a $scratch table, the results list the correct number of records, but when I do a select count(id_field) from the table, it retrieves triple that number. But if I do a select(distinct id_field) I get the correct amount.

@sgoldsmith Where is your dist store? Is it NAS? in your dremio.conf, have you given file:/// or pdfs:///

Do you have 3 executors?

Right now we have the dist store commented out but the location of it is on an NAS. And yes, we have 3 executors.


That explains why you have 3 times, add file:/// and path to NAS instead of the dist:///