Sending Avro file via HTTP
tom
It is possible to send an AVRO file via HTTP. The idea is that one sets up a server process. Once the server process runs, a client call is made.…
Show content of an AVRO file with Python
This note describes how we can show the content of an AVRO file with Python. We use python3 as tool here. We use this from an Anaconda framework. I checked…
What is inside an AVRO file?
In the Hadoop world, one may encounter AVRO files quite often. AVRO file can be used in more or less the same way as text files. They can be read,…
mounting drives
Today, I played a bit with mounting external drives. Boy, that was more difficult than I thought. The situation was a follows. I had a linux desktop and I wanted…
Sqoop
Sqoop is used in an Hadoop environment to load data from a relational database upon an Hadoop platform. I have installed an Oracle 12.2 database. I tried to load data…
Installing Cloudera Manager
Cloudera Manager is a great tool to install a Big Data platform. I worked with this tool and let me share some findings. I realise that we have only a…
the Oracle Tuning Advisor
Oracle has now included an Oracle tuning advisor. Its purpose is to advise on a SQL statement. For me, it provides an answer on whether to add an index or…
SCD-2 and the Oracle Merge statement
Yesterday I found a very nice script that allows processing records in a target table with a SCD-2 mechanism. The script is very elegant. It contains several logical steps that…
Explain plan in Oracle
I want to show the usage of an explain plan in Oracle. This will be shown in Oracle 12c. I will create a table and a sql statement. This sql…
Installing on new versions of an OS
I regularly install Oracle. In most cases, such installation is straightforward. Start the setup, provide a few data and click next, next, and next. Half an hour later, one has…