gaia-dpci / GaiaXPy

Gaia BP/RP spectra package
BSD 3-Clause "New" or "Revised" License
36 stars 9 forks source link

Incompatibility: Retrieval Error in GaiaXPy v2.1.0 for ADQL queries #91

Closed druzm closed 4 months ago

druzm commented 4 months ago

In GaiaXPy version 2.1.0, users are unable to retrieve the output of the different GaiaXPy tools (convert, calibrate, etc.) when ADQL queries are passed as input.

For example in

from gaiaxpy import convert

query = "select TOP 1 source_id from gaiadr3.gaia_source where has_xp_continuous = 'True'"
convert(query)

the call to convert will raise an error. This was initially reported in issue #89.

Users should be able to correctly retrieve the output of every existing input type in the latest release of the package. This implies that a new patch release will need to be created.

The problem is due to a change in the tables retrieved from the Archive in which the column 'source_id' has been replaced by 'SOURCE_ID'.