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 am sorry, this is a pitfall RBQL should handle more gracefully, the problem is that RBQL JOIN is (currently) very rudimentary. It just compares strings in the left and right tables, so when you compare aNR with b.id it doesn't match any records because aNR has integer type while b.id is a string. I will need to add more checks to report an error for this kind of query explicitly.
As a workaround, you can first run Select aNR as nr_id, * with(headers) on the first table, and then use the output table to join a.nr_id == b.id
No worries and thank you! But can you maybe just cast NRs to strings in the JOIN expression? Seems to be a localized change.
I've implemented the workaround you suggested, but my table is rather large, and ideally I would like to avoid extra processing step. Especially since I have an unrelated design limitation that leads me to have to re-parse the data back from a string on each step. :-)
I'm trying to
JOIN
two tables, where theB
table has additional information for some rows in theA
. I can't get the query to work as I expect.a.csv:
b.csv:
Query:
Output:
Expected output:
What am I missing?
The text was updated successfully, but these errors were encountered: