Q&A BY TAG 'UNION'
Add Column Description doesn't work with UNION
answered
31-05-2022 05:03:40 -0400
I am trying to append a specific record to a derived view with UNION. The view can be created without DESCRIPTION. But when I do CREATE OR REPLACE VIEW xxx DESCRIPTION = 'xxx' (columnname (DESCRIPTION = 'xxx')), it will give me an error saying the firl...
Answers:
1
Add Column Description doesn't work with UNION when appending record
answered
31-05-2022 05:01:43 -0400
I am trying to append a specific record to a derived view with UNION. The view can be created without DESCRIPTION. But when I do CREATE OR REPLACE VIEW xxx DESCRIPTION = ‘xxx’ (columnname (DESCRIPTION = ‘xxx’)), it will give me an error saying the firl...
Answers:
1
an alternative to UNION of three separate views
answered
16-03-2021 08:13:45 -0400
I am able to execute 3 different baseviews against our LDAP data. But when I try to union them together I am getting an exception error. exception = java.security.PrivilegedActionException LDAP URI = ldaps://<ldap url>:3269/DC=mycompany,DC=com?...
Answers:
1
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