I'm using Apache Phoenix to query Hbase. I tried to use a simple MINUS operator like we do in good old SQL but it produces an error that I couldn't wrap my head around.
Here's the query:
select * from NOTIFICATION MINUS select * from NOTIFICATION where SUBJECT = 'datanode';
Note: It's not this specific query I'm looking to solve, I just want to get MINUS to work. Thanks.