Outer Join

Dbase3tate

I am trying to convert a HIVE SQL that includes a left outer join. I don't see that in a JOIN recipe. How do I add it?

Operating system used: Windows

Yasmine_T

Hi!

I hope that you are doing well.

In the join recipe we offer:

• Left Join which keeps all rows of the left dataset and adds information of matched records from the right dataset.
• Outer Join which keeps all rows from both datasets, combining rows where there is a match. This is useful when you need to retain all the information in both datasets.

(You can find all available join here: https://knowledge.dataiku.com/latest/data-preparation/visual-recipes/concept-join-recipe.html#types-of-joins) )

Here i believe that the best match to a Left outer join would be to use Left join.

What is your exact need? Is there any limitation encountered using left join here? If so let me know so we can find the best way to cover your use case.

Best,

Yasmine

Dbase3tate

Using the left join worked. Now I am trying to delete records from a dataset where there are four conditions that match. Kind of like a DELETE query in SQL. Any suggestions?

Yasmine_T

Yes! You can use a prepare recipe with the Filter rows/cells with formula processor: https://doc.dataiku.com/dss/latest/preparation/processors/filter-on-formula.html

There are a few approach you can take here but this processor would be the easiest option i believe:)

Best,

Yasmine

Yasmine_T

You can also do a SQL recipe if that is easier/familiar to you:

See: https://knowledge.dataiku.com/latest/code/sql/concept-sql-code-recipes.html https://doc.dataiku.com/dss/latest/code_recipes/sql.html

Best,

Yasmine