RE: Joining three tables with data frames

ven or endorsed by Peridale Technology Ltd, its subsidiaries or their employees, unless expressly so stated. It is the responsibility of the recipient to ensure that this email is virus free, therefore neither Peridale Technology Ltd, its subsidiaries nor their employees accept any responsibil

Re: Joining three tables with data frames

What do you mean "does not work" ? What's the error message ? BTW would it be simpler that register the 3 data frames as temporary table and then use the sql query you used before in hive and oracle ? On Sun, Feb 14, 2016 at 9:28 AM, Mich Talebzadeh wrote: > Hi, > > > > I

Joining three tables with data frames

Hi, I have created DFs on three Oracle tables. The join in Hive and Oracle are pretty simple SELECT t.calendar_month_desc, c.channel_desc, SUM(s.amount_sold) AS TotalSales FROM sales s, times t, channels c WHERE s.time_id = t.time_id AND s.channel_id = c.channel_id GROUP BY