Q&A BY TAG 'UNION'
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
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
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
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
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
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 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
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
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
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