cancel
Turn on suggestions
Showing results for 
Search instead for 
Did you mean: 
Help
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Turn on suggestions
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Start a conversation
brickster_2018
by • Databricks Employee
  • 1494 Views
  • 1 replies
  • 0 kudos

Why do my queries involving Cartesian product run slowly

Data Engineering
Reply
  • 1494 Views
  • 1 replies
  • 0 kudos
View Replies
Latest Reply
amr
Databricks Employee
  • 0 kudos

Cartesian product is the worst type of join that you should always avoid, it tends to product N x M where N & M are the left and right table cardinality. unless you specifically want to use it, then you should avoid and opt for faster joins (inner, l...

  • 0 kudos
rlgarris
by • Databricks Employee
  • 8411 Views
  • 5 replies
  • 0 kudos

Resolved! How do I get a cartesian product of a huge dataset?

A cartesian product is a common operation to get the cross product of two tables. For example, say you have a list of customers and a list of your product catalog and want to get the cross product of all customer - product combinations. Cartesian pr...

Data Engineering
Reply
  • 8411 Views
  • 5 replies
  • 0 kudos
View Replies
Latest Reply
Forum_Admin
Contributor
  • 0 kudos

Hi buddies, it is great written piece entirely defined, continue the good work constantly.

  • 0 kudos
4 More Replies
Labels
Top