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:///
https://docs.dremio.com/software/deployment/dist-store-config/#nas