Join operation Vs nested query
Xor
Spec:
Xor(<ROW_CALL>, [ROW_CALL ...])
Description:
Xor performs a logical XOR on the results of each ROW_CALL
query passed to it.
Result Type: object with attrs and columns
attrs will always be empty
Examples:
Query columns with a bit set in exactly one of two rows (repositories that are starred by only one of two users):
Xor(Row(stargazer=2), Row(stargazer=1))
{"results":[{"attrs":{},"columns":[20,30]}]}
- columns are repositories that were starred by user 1 XOR user 2 (user 1 or user 2, but not both)
Not
Spec:
Not(<ROW_CALL>)
Description:
Not returns the inverse of all of the bits from the ROW_CALL
argument. The Not query requires that trackExistence
has been enabled on the Index.
Result Type: object with attrs and columns
attrs will always be empty
Examples:
Query existing columns that do not have a bit set in the given row.
Not(Row(stargazer=1))
{"results":[{"attrs":{},"columns":[30]}]}
- columns are repositories that were not starred by user 1