CartoDB / bigmetadata

BSD 3-Clause "New" or "Revised" License
43 stars 11 forks source link

Workaround brazil SaoPaulo Domicilio02 table having wrong IDs #607

Closed javitonino closed 5 years ago

javitonino commented 5 years ago

Fixes Domicilio02 table. This table was updated in 2018 to delete some redundant columns (always NULL). However, when doing so, the ID's got broken as well. Instead of the proper IDs, all the rows contain 55031E+14, which looks like a configuration problem when generating the files.

Luckily, all files in the sector have the same rows in the same order, so we can recover them from another file. Furthermore, I have a 2017 backups of the older files (which have the correct IDs). A diff of the old file against the one generated by this patch shows no difference in data (just a change in the header row, removing some extra columns as mentioned above).