Hello.

I'm using Teiid 10.1.

I observed Teiid divide multiple DBs Join SQL into each DB SQLs. 

This spesification is OK but it is unconveninet when using Hive because Hive execute multiple DBs join SQL by 1 mapreduce.

Is there any way to avoid splitting multi DB Join SQL ?

(Example)

- Input to Teiid:

SELECT c.id, d.id FROM a.c, b.d WHERE c.id = d.id;

- Current Teiid output to Hive: 

1. SELECT c.id FROM a.c

2. SELECT d.id FROM b.d

- Expected output to Hive:

SELECT c.id, d.id FROM a.c, b.d WHERE c.id = d.id;

thanks.