Watch Out for Data Induced “Cross” Joins
Jim Knicely, Vertica Principal Solution Architect
May 20, 2019
I recently worked with a client who reported that a query in Vertica would not return data. That is, the query ran forever. The query was pretty simple, joining two 100 billion+ tables together. After some investigation, we realized that the query could potentially return trillions and trillions of records! Why? Because the join keys...