Q&A BY TAG 'JOIN'

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

Json array in data set - joining back to original data --- losing records when select * is used
answered 11-08-2021 06:58:14 -0400

I am seeing some odd behavior with a derived view that is the result of a field with JSON data being turned into an array and joined back to the original data set and the flattened. if I do a select * (no where clause) of the resulting join (after th...

Answers: 2

select query flatten ARRAY missing records JSON join

Condition based Join of 3 tables
answered 10-08-2021 13:41:59 -0400

I am having 3 tables - A, B, C. I need 4 kinds of output Case 1 : If condition 1 and 2 both not satisfied : Sel from A Case 2 : If condition 1 satisfies : Sel A. from A Inner Join B Case 3 : If condition 2 satisfies : sel A. from A Inner Join C Case ...

Answers: 2

join switch CASE

Joins with Paginated Data
answered 29-04-2021 13:48:58 -0400

If we have a schenario where results from two paginated APIs are to be JOINED. e.g. We have 1 million customers, and an API that returns 100 at a time. And another API that reutrn All Customer Orders, again 100 at a time, with no guarantee about what p...

Answers: 1

Pagination join

Isolated query of a joint view
answered 16-04-2021 08:35:01 -0400

Hello, is it possible to solve the following scenario: I have two views with different sources, which I would like to join (a push-down is therefore not possible). I want to join these views and make them available for reporting. However, the reportin...

Answers: 1

Denodo 8.0 performance join

Merge search parameters for derived view to other 3 underlying views
answered 30-03-2021 08:46:37 -0400

Hello, I have following tree view: View / | \ View1 View2 View 3 | | | BV BV BV | | | DS DS DS The DS is a Web Service Datasource...

Answers: 1

Denodo 7.0 VQL search methods join Derived views

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

Dynamic Interpolation Variables Create Base View join

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

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