Re: [teiid-users] Undivided Join Query to HIVE

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(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/teiid-users