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
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
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
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
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
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
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
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
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
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