Parsing XML to Oracle. ODI vs Flexter Enterprise XML Parser

Maciek Kocon Flexter, Oracle, Oracle Data Integrator (ODI), SQL, XML, XSD

In some previous posts we demonstrated how to load XML data into an Oracle database using ODI. We first looked at some of the issues when reverse engineering an XSD in ODI. Next we looked at various issues when parsing and processing XML files in ODI. We also showed that Flexter parses XML files without creating a single data flow ...

Window Functions (aka Analytic Functions) in Spark.

Uli Bethke analytic functions, Big Data, MapR, Spark, SparkSQL, SQL

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. Spark SQL and Window Functions: The rationale I am a strong supporter ...

Hadoop User Group Ireland Meetup (24 June 2015): An Introduction to Spark

Uli Bethke Big Data, Hadoop, HUG Ireland, Spark, SparkSQL, SQL, Tableau, Uncategorized

Thanks again to everyone who attended the third Hadoop User Group Ireland meetup. Also thanks to Bank of Ireland Grand Canal Square for making the venue available. Participants in the event can send feedback to their Twitter and Facebook accounts: facebook.com/BOIGrandCanalSquare twitter.com/BOIGrandCanalSQ. Also thanks to Étienne from Idiro and Antonio from HP for their great presentations. We have all of ...

Tricks with SQL: Beware of the Predicate in the Outer Join

Uli Bethke SQL

Today we will have a look what happens when we place a filter condition into an outer join. We will also have a look at how this compares to placing the filter condition into the WHERE clause. Finally we'll have a look where this could be useful. Let's first create some sample data.

Let's run our first outer join ...