Q&A BY TAG 'UNION'

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

Multiple Union statements with parameters are not working in VQL.
answered 03-08-2020 08:29:36 -0400

Hi There, We are trying to implement multi UNION. It is something like following: `CREATE VIEW iv_union_test as SELECT * FROM iv_derived_vw q1 WHERE q1.date = i_date AND q1.id = i_id AND q1.flg = 0 UNION SELECT * FROM iv_derived_vw q2 WHERE q2.date ...

Answers: 1

UNION

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

Denodo Union / Sort Merge Performance Issue
answered 07-02-2020 18:46:56 -0500

I currently have two derived views, say D1 and D2, that are unioned together to create D3. I originally had an issue with both D1 and D2 which involved a sort merge. Both D1 and D2 are a join of two base views; each ran very well when I had a date fil...

Answers: 1

performance sort merge UNION

Union View not working for Project Requirement
answered 13-04-2016 21:00:45 -0400

Team, I have 2 views - which is for different data source. View1 = institutional_fund_indicative_data View2 = comp_fund_details_prp Common columns are: fixed_comp_fund_code, investment_vehicle, broad_investment_capability Also it has its own ...

Answers: 2

UNION

How do I return all the valid data from a union view even if one of the underlying views fails?
answered 09-09-2015 12:43:03 -0400

Hi, I have a union view made up of 75 other views (I'm unioning 75 views together). Sometimes, one of the southbound databases is offline and the entire union fails when I access it over JDBC. I have noticed that when I run the same query via the VD...

Answers: 1

UNION

Unions and Dimensional Reporting
answered 13-07-2015 14:17:00 -0400

For the sake of this question, this example is significantly reduced in scope, so in any response please understand the tables are actually much larger and more dimensions are involved. Consider: Table 1 (Key_A, Key_B, Value_A, Value_B, Value_C) Table...

Answers: 2

UNION

UNION of Derived Views coming from a single query to the source data
answered 21-06-2015 22:21:47 -0400

I have a data source where due to it's hierarchical nature that I need to flatten it & output as a list (with hierarchy level no. being just another column) my approach is as follows. Say we have 3 levels of hierarchy, I would set the first view, view_...

Answers: 2

VQL UNION

Unparseable date in union
answered 07-05-2015 11:47:17 -0400

Denodo 5.0 release 20141023 - Windows Server 2008R2. I have three views that I am trying to union together. view1 and view2 have 10 fields in it, view3 only has 8 fields. view3 is missing 2 date fields so I created 2 new date fields in view3. The dat...

Answers: 1

Error UNION

Union View Error of Assert code: 1000 Help
answered 29-04-2015 14:22:22 -0400

I am using the 5.5 Community Edition. In there I create two new join views that each have two columns (email & touchpoint). Each of those views when executed pull back what is expected. Next I went to create a union view that uses those two previous...

Answers: 2

UNION

How many CASE statements are allowed in one view?
answered 24-11-2014 10:56:02 -0500

Hi I have a question regarding the CASE statement and how many can be used in creating a view. I have two views joined in a UNION. I have multiple fields where I have applied the following statement: Case WHEN (view1.field1 is null) THEN view2.fiel...

Answers: 1

UNION CASE