[teiid-users] Undivided Join Query to HIVE

[JUNGHO PARK]

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.