Q&A BY TAG 'Union All'

You must sign in to ask a question. If you do not have an account, you can register here

Query Regarding UNION ALL
answered 05-03-2020 20:55:42 -0500

Hi Team, I have created a multiple node in denodo connecting to Jethro Database. All these nodes are working fine and gives the proper result. Now when I am doing UNION of all these nodes, then denodo is not giving result. It says "java.sql.SQLExcept...

Answers: 1

Union All UNION

Union all fails and REST service corrupts
answered 17-05-2019 21:18:13 -0400

I am trying to union all my connection result form 5 different source sources. I am exporting the union result as REST service. if one data source fails the error message in the result corrupt the whole xml which result in crashing whole system. how ...

Answers: 1

Union all

Why denodo does union all by default ?
answered 31-10-2014 12:33:35 -0400

I tried to do a union between two tables and when I see the query plan it says UNION ALL. SO my question is if denodo is passing union all to source DB then I may get some duplicates. is there a way to explicitly specify just simple UNION or UNION ALL.

Answers: 1

Union All