I have two very large tables that both have a SUPPID column. Want to find SUPPIDs that exist only in the first table, but not in the second. Would normally use a MINUS operation but that is not feasible given the size of these tables. Can I do this in Xcalar?
Please give an example, as your question is not very clear.
Also, have you tried a LEFT OUTER JOIN and then Filter on rows that contain an FNF for field values that are not on the RIGHT SIDE?