User table upload to qserv

Support
#1

Continuing the discussion from Upload table and use in query:

Is there any update on being able to upload a table as a user table and then submitting an SQL query making use of that in a qserv query eg

select * from myUploadedTable as m, Object as o where m.objectId=o.objectId

I think the current approach is still to upload to the RSP and then form a WHERE IN query.
Apologies if I’ve missed development on this.
Thanks
Mike
@fritzm @george_beckett

1 Like
#2

This post relates to my use case.
I want to join a table I upload of catalogue objects to a native table on the platform. In this particular instance using a SQL JOIN clause as I have Gaia ids that are in one of the tables. I can imagine other use cases where an ADQL nearest neighbour match would be useful.
Thanks
Andy