You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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....
The text was updated successfully, but these errors were encountered:
Issue found by Connor Bottrell:
The text was updated successfully, but these errors were encountered: