I'm currently trying to code a crossmatch in a Jupyter notebook and keep getting the mentioned error. I have seen it mentioned in two or three other discussions sadly without any solution. The code reads as follows:
from dl import queryClient as qc
query = """
SELECT c.*, v.japermag3
FROM mydb://catwxvhs AS c, vhs_dr5.vhs_cat_v3 AS v
WHERE q3c_radial_query(c.ra, c.dec, v.ra2000, v.dec2000, 0.0014)
AND (v.mergedclass=-1 OR v.mergedclass=-2)
AND v.japermag3 between 18 and 19
result = qc.query(sql=query, fmt='csv',
I've limited the query to just one result (LIMIT 1) for testing purposes but no matter what I do, it always says:
Status = ERROR; elapsed time: 5, timeout in 595
Error: IllegalArgumentException: Table [ mydb."catwxvhs_3718" AS c ] is not found in TapSchema
Does anyone know what I'm doing wrong?