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.

_______________________________________________
teiid-users mailing list
teiid-users@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/teiid-users