0 votes
127 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.

by dpallot (150 points) | 127 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.

436 questions

452 answers

454 comments

651 users

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

Categories