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 of over 48,000 articles and solutions.
Close
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.