Receiving NullPointerException error joining 2 tables in DV
Issue
- Receiving a NullPointerException when trying to join 2 views, querying each individual table returns results
Environment
- Red Hat JBoss Data Virtualization (DV) 6.1
- View 1 transformation
SELECT *
FROM THE tbl_ONE pi
WHERE pi.prodCod IN (SELECT p.prodCod
FROM THE tbl_TWO p
WHERE NOT (EXISTS (SELECT 1
FROM THE tbl_ONE pi
WHERE (pi.prodCod = p.prodCod) AND (pi.sprodCod IN (1, 2, 3, 4, 7, 14, 15, 16, 17, 18, 19)))))
- View 2 transformation
SELECT *
FROM THE tbl_TWO p
WHERE NOT (EXISTS (SELECT 1
FROM THE tbl_ONE pi
WHERE (pi.prodCod = p.prodCod) AND (pi.sprodCod IN (1, 2, 3, 4, 7, 14, 15, 16, 17, 18, 19))))
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.
