Undivided Join Query to HIVE
by 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.
2 years, 6 months
