Hi Datalab team,
I have a query as below:
aquery = """
SELECT ra as RA, dec as DEC, dered_mag_g as mag_g, dered_mag_r as mag_r, dered_mag_z as mag_z,
dered_mag_w1 as mag_w1, dered_mag_w2 as mag_w2, dered_flux_g as flux_g, dered_flux_r as flux_r,
dered_flux_z as flux_z, dered_flux_w1 as flux_w1, dered_flux_w2 as flux_w2
WHERE snr_z>3 and dered_mag_w1 > 15.0 and dered_mag_w2 > 15.0
and dered_mag_g > 20. and dered_mag_r > 20. and dered_mag_z > 17.5
and dered_mag_w1 != 'NaN' and dered_mag_w2 != 'NaN'
and dered_mag_w1 != 'Infinity' and dered_mag_w2 != 'Infinity' and ra < 40
### divide ra in 60, 120, 240
### async mode returns jobid
jobid = qc.query(token, adql=aquery, format='pandas', async_=True)
status = ''
while (status != 'COMPLETED' and status != 'ERROR'):
status = qc.status(token,jobid)
print (status) # Python 2; for Python 3 instead use print(status)
df = convert(response,'pandas')
But it did not execute correctly. Each times it returns:
CPU times: user 76 ms, sys: 3 ms, total: 79 ms
Wall time: 4.33 s