dr-guangtou/unagi

SQL doesn't find S20A photo-z catalog

dr-guangtou opened this issue · 0 comments

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....