0 votes
93 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, 2021 by dpallot (150 points) | 93 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.

359 questions

372 answers

385 comments

2,427 users

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