I want to cross-match with ls_dr8.photoz, but that table doesn't have RA,Dec columns.
I therefore used the cross-match tool with my uploaded csv file to match to the ls_dr8.tractor table, saving to "mydb.matchmg".
Then I want to join that with the photoz table. But I'm getting an error that is not very helpful:
My query is
SELECT * FROM mydb.matchmg AS mg
JOIN ls_dr8.photoz AS p
ON mg.ls_id = p.ls_id;
and error is
"Error: IllegalArgumentException: Table [ mydb.matchmg AS mg ] is not found in TapSchema"
I've tried a number of other variants, but not having any luck.
Thanks for any tips...