Sample Header Ad - 728x90

Apache Phoenix: Using MINUS throws an error

3 votes
1 answer
372 views
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: enter image description here > 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