Join does not returns result

1

A simple join of this format does not return expected result. Whereas individually, each table returns rows when queried.

QRY-01
SELECT a.item_id ,
b.item_id
FROM src_a
JOIN src_b b ON a.item_id = b.item_id
WHERE a.item_id = 51551446;

2

@HLNA it is hard to diagnose your problem without further details. Could you please share:

  • Query profile for this query.
  • Brief explanation of expected vs. observed results.
3

@can Thanks, it seems the issue was related to jdbc connection failures… on restart it worked fine.