I dint see the full query in your description. Are you aggregating (SUM) delta column based on customer_id ? I did the following simple repro without aggregates & able to get the results as expected. create external table Customer(customer_id string, money_spent bigint) stored as textfile; insert into customer values("0001", 500), ("0002", 250), ("0003", 100); create external table sales(customer_id string, order_id string, amount bigint) stored as textfile; insert into sales values("0001", "5005", 500), ("0002", "5006", 250), ("0003", "5007", 50); select "Sales Check" as rule, (a.money_spent - b.amount) as delta from customer a join sales b on a.customer_id = b.customer_id; +--------------+--------+ | rule | delta | +--------------+--------+ | Sales Check | 0 | | Sales Check | 0 | | Sales Check | 50 | +--------------+--------+ 3 rows selected (15.186 seconds) Let me know if this helps.
... View more
