Latest Activity

code

Json array in data set - joining back to original data --- losing records when select * is used

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
  • answered 11-08-2021 06:58:14 -0400

select query flatten ARRAY missing records JSON join

code

Records missing in a derived view, but the data exists in those base views or the source tables even after applying the same join conditions which are being used in derived view.

Hi All, I am encountering this wierd scenario in denodo. 3 records are not displaying when I query based on the name, and 3 records are being displayed when I query based on the id from the derived view. Denodo version: denodo platform 5.5 I have ta...

  • Answers: 3
  • answered 07-07-2016 09:07:59 -0400

hash join missing records resultset derived view sort merge not same with different where conditions

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