HQL in which involves with join between txt and orc tables returns incorrect result

We have the scenario of ORC with ACID joining with TXT table and it can't retrieve that ID based row which should.

Here is the HQL:

select a.id a_id,b.id b_id from txtdb.order a, orcdb.order_cln b where a.id = b.id and b.id = '8a708a864faf8ef6014fb70426d62a67';

Table txtdb.order is TXT format and orcdb.order_cln is ORC format. Both of tables have this ID based row. But the result is empty.

Surprisingly, if I switch the position of TXT and ORC as follows,

select a.id a_id,b.id b_id from orcdb.order_cln a, txtdb.order b where a.id = b.id and b.id = '8a708a864faf8ef6014fb70426d62a67';

Then this ID based row returns correctly.,