hpix_4092 is given as float [closed]

Question

in des_dr2.coverage, hpix_4092 is provided as float, though it should be bigint as shown in the schema browser.
Any way to retrieve hpix_4092 correctly?

Answer 1

Hi, thanks for reporting this. I'm assuming you're referring to the hpix_4096 column in the des_dr2.coverage table? It does look like this column was being stored as type REAL (or float), even though all of the values were actually BIGINT. I've gone ahead and converted the column to type BIGINT.

Comments

Hi ajacques, Thanks for this quick response. Yes, I meant hpix_4096, and now I found it is correctly pointing the healpix index.