Window Functions (aka Analytic Functions) in Spark.

Uli Bethke July 3, 2015

As of Spark 1.4.0 we now have support for window functions (aka analytic functions) in SparkSQL. At Sonra we are heavy users of SparkSQL to handle data transformations for structured data. We also use it in combination with cached RDDs and Tableau for business intelligence and visual analytics. [big_data_promotion] Spark SQL and Window Functions: The ...

Read More

Time series in OBIEE. Analytic functions and range window as an alternative to OBIEE AGO function.

Uli Bethke June 1, 2011

All intellectual credit for this post goes to my colleague Maciek Kocon. I am simply documenting this. We had some performance issues recently using the OBIEE AGO function for time series and month ago reporting. While there are solutions out there using the lag functionality we had two issues with these (1) They don’t cater ...

Read More

ODI and analytic functions (again???)

Uli Bethke May 20, 2010

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes My friend and colleague Maciej Kocon has come up with the following trick. Rather than use a user defined function to implement an analytic function such as MAX() OVER or SUM() OVER as suggested by note ...

Read More

10 Reasons you really need predictive analytics

Uli Bethke February 4, 2010

SPSS have recently posted and article called “10 Reasons you really need predictive analytics“. I thought it would be interesting to post the main points from this article to illustrate that not all predictive analytic projects involve Data Mining, but involve a number of different techniques and looking the the business data in a different ...

Read More
1 2