Reading XML in Oracle -1
As a first example on how to read an XML file, I show how an XML file can be read with a PLSQL programme. The logic is quite simple. We…
As a first example on how to read an XML file, I show how an XML file can be read with a PLSQL programme. The logic is quite simple. We…
This programme creates an Oracle procedure. This Oracle programme has a loop. Within that loop, one record is read from a table. The content of that record is used within…
I now work in an organisation where they often use SAS as a means to maintain Oracle tables. For some reason, people approach me to create such connection. Dunno why…
I regularly happens to me that I want to generate a random set of records in an Oracle table. That could happen if we want to assess performance of a…
It is possible to use Sqoop to directly load from a RDBMS into Hive. This opens interesting possibilities. Data that are stored in a RDBMS and that need to be…
It is good to realise that Hive is built upon a mapreduce framework. The idea is that Hive is developed by facebook to facilitate analysis on Hadoop files. It is…
In this blog, I will discuss the word count problem as done with Python. It is often used to show how map reduce works. In most examples, it is developed…
In my view, the new development that we see now is building links to a Hadoop platform. One such development is building ODBC drivers that allow windows tools to access…
Recently, I revisited Pig. Pig is a language that allows you to analyse data sets in a Hadoop environment. It is created at Yahoo to circumvent the technicalities of creating…
A few days ago, I was asked to load some tables in Oracle. A rather trivial question but I wasn’t sure if enough tablespace was left. From the table definition,…