Q&A BY TAG 'join'

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

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

join

Dynamic Base View based on another Base view (not JOIN)
answered 18-11-2020 06:09:39 -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: 4

Dynamic Interpolation Variables Create Base View join

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

performance JSON join

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

join Cache

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 hash

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

join datatypes

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

join

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

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

join

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

ODBC Access JDBC join