When running the crossmatch service it gives me this: Error: relation "mydb.cows2" does not exist LINE 1: ... o.null, g.ra, g.dec)*3600.0) as dist_arcsec from mydb.cows2... ^

Question

The table I uploaded is in csv format. Is there something else wrong with it?

Answer 1

The table was uploaded and ingested correctly (2433 rows), however, it contains a column named 'references' which is an SQL reserved word.  This is causing the crossmatch query to fail parsing.  I've renamed the column 'refs' in the mydb table so the query should succeed if you try again.

We will add a check for reserved words in the future to avoid this, until then please let us know if you encounter the error again.