Q&A BY TAG 'JOIN'
Dynamic Base View based on another Base view (not JOIN)
answered
04-01-2021 12:18:07 -0500
Hi, I need help with a very specific use case. I have 2 different data sources and I need to create a base view from source A filtered by some values from another base view coming from source B. This values in the second view would be a hole column, ...
Answers:
5
Join condition on delimited files
answered
26-11-2020 04:20:16 -0500
Hi Team, I want to join 2 views.First view is created from Json file and second view is created from delimited files(Text Files) I need to join both of them on basis of one coloumn. This column can be easily written by specifying view name and then ...
Answers:
1
Poor performance for jdbc and json array type join
answered
09-10-2020 08:19:14 -0400
Hi, I observered a poor performance for a join between a jdbc type view and json array. individually when queried they are running fast but when we do a join it's performance degrades. Can you suggest how to improve performance ? Also i see 347 subp...
Answers:
1
Denodo Disparat sources join without Cache.
answered
26-12-2019 14:12:56 -0500
Hi Guys, I am new to Denodo. I have installed Express edition on my laptop and running a sample task. I have two disparate data sources (Postgres and MySQL), Postgres has agents table while MySQL has Customer and Orders data. When I execute a join ...
Answers:
3
Different Hashes for same values hash()
answered
20-12-2019 08:53:17 -0500
Can anyone please help me understand how hash() function generates different results for same string input? Tables are different but the source is same, i.e. Postgres DB. because if this is the case, then join won't work on string columns, and it ...
Answers:
1
Join attributes of different (compatible) types across different data sources
answered
07-01-2019 07:40:30 -0500
Hallo Denodo Team, Suppose you need to join tables from different data sources (say Oracle and Teradata). Suppose the matching should happen between attributes that have different data types (say VARCHAR(N) on one side, NVARCHAR(m) on the other side, ...
Answers:
1
How do I concatenate two columns and use them in the join?
answered
20-12-2018 17:05:10 -0500
Hi Team, I would like to know, how would I perform the below join condiiton in VDP, how do I concatenate two columns to use them in the join operation. table_a a LEFT JOIN table_b b on a.column_a = concat(b.column_b1,b.column_b2) Regards, Shafeeq
Answers:
1
Meaning of the join arrow's direction in a join view
answered
08-03-2018 08:11:48 -0500
When joining two or more views (as source) together in a join view, Denodo will draw an arrow between the tables. The arrow's direction seems to depend on how you "draw" the line, i.e. from which table you start. Is there any "deeper" meaning to this ...
Answers:
1
Join type mismatch
answered
30-01-2018 17:07:59 -0500
We have an issue with database tables having different primary key types (numeric / character). There is a performance hit on the database side when these occur. is there any way for denodo to help identify when a type mismatch occurs when creating or ...
Answers:
3
Joining JDBC and ODBC base views, fail execution (ODBC error)
answered
21-11-2017 06:35:18 -0500
I am doing the first course of the Denodo Developer Certification. I am trying to join (inner join, any type of join method) bv_wo_customer table, from an Oracle-JDBC based source, with bb_cc_service_call, from an MS Access-ODBC based source, by commo...
Answers:
1