0 votes
22 views

Im doing the following xmatch with a mydb table I have uploaded called test.

query = "SELECT aw.designation, xm.id1, xm.distance, " \
              "des.ra, des.dec, des.mag_auto_g, des.mag_auto_r, " \
               "des.mag_auto_i, des.mag_auto_z, des.mag_auto_y " \
               "FROM mydb://test as aw, des_dr1.mag as des, des_dr1.x1p5__main__allwise__source as xm " \
               "WHERE aw.source_id=xm.id2 AND xm.id1=des.coadd_object_id"

qc.query(query, fmt='csv', out="vos://test.csv")

When running this query in sync mode it works. When its run in async mode:

qc.query(query, fmt='csv', out="vos://test.csv", async_=True, wait=True, poll=1, timeout=3000)

I get the following error:

Error: IllegalArgumentException: Table [ mydb."test_2916" AS aw ] is not found in TapSchema

As you can see test_2916 is not the name I specified in the query.

asked Oct 22 by dpallot (130 points) | 22 views

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.

282 questions

281 answers

315 comments

1,886 users

Welcome to Data Lab Help Desk, where you can ask questions and receive answers from other members of the community.