SQL doesn't find S20A photo-z catalog
dr-guangtou opened this issue · 0 comments
dr-guangtou commented
Issue found by Connor Bottrell:
I find that the SQL query tool in unagi doesn’t recognize the s20a_wide.photoz_mizuki table:
import unagi dr = unagi.hsc.Hsc(dr='dr3', rerun='s20a_wide') sql_cmd = [ 'SELECT f.object_id, f.ra, f.dec, z.photoz_median', 'FROM s20a_wide.forced as f', 'LEFT JOIN s20a_wide.photoz_mizuki as z', 'ON f.object_id = z.object_id', 'LIMIT 10' ] sql_cmd = ' '.join(sql_cmd) print(sql_cmd) result = dr.sql_query(sql_cmd, from_file=False, verbose=True)
Which gives:
Waiting for query to finish... [Failed] query error: - Query Error: relation "s20a_wide.photoz_mizuki" does not exist LINE 1: ..., z.photoz_median FROM s20a_wide.forced LEFT JOIN s20a_wide....