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';
Here's a screenshot:
> Note: It's not this specific query I'm looking to solve, I just want
> to get MINUS to work. Thanks.

Asked by Youcef Chihi
(131 rep)
Aug 9, 2017, 10:08 AM
Last activity: Oct 31, 2018, 03:17 PM
Last activity: Oct 31, 2018, 03:17 PM