odd behavior of des_dr2.coverage

Question

Table des_dr2.coverage seems to have a different number of rows to what is reported both in DES DR2 paper and the same table at the NCSA server.

datalab: select count(*) from des_dr2.coverage --> 25499949

ncsa: SELECT count(*) FROM DR2_COVERAGE --> 25239595 (as reported in the paper)

Also this query, for example:

select hpix_4096 from des_dr2.coverage where hpix_4096 = 67108876

returns five entries (one per band?) when it should return only one (this is the expected behavior).

Answer 1

Hi, thank you for bringing this to our attention. It looks like there was an error during ingest of this table that caused some duplicate rows to appear. I'm in the process of correcting the table now.

Answer 2

Hi, thank you for bringing this to our attention. It looks like there was an error during ingest of this table that caused some duplicate rows. I'm in the process of correcting the table now.

Comments

Thanks. Please let me know when this is ready.