I want to add two table using UNION ALL keyword.
I see lot of forum that hibernate is not supporting union all .
Is this still a bug or its solved in latest version .
Not yet, but I am working on it for Hibernate 6.0. In the meantime you could use Blaze-Persistence, a query builder library that works on top of JPA, which has support for this. See the documentation for more info and examples.