GigaOm Structure Highlights

The GigaOM Stucture conference a couple of weeks ago addressed many areas of cloud computing. One of the key themes of the event was the emergence of new data architectures. Throughout the panels, interviews, and presentations many speakers identified significant…

Read More

SQL Window Functions in Hive

One of the powerful capabilities of SQL 2003 is the ability to use window functions, e.g., this query computes the ratio of a score to the average score of lower scores, for each product select score/(sum(score)/row_number()), product over (partition by product…

Read More