Serialise
tom
I encountered the term “serialise”. But what does it mean? I understood the term “serialise” when I read a comment that explained that data structures can be created inside, say,…
Avro in Java
Another example shows a similar idea. In this example a stream is created. This stream consists of 3 objects that contain a name and a number. Once the stream is…
Sending data via AVRO
I got a better understanding when I used AVRO to write data via PHP and to read them via Java. It demonstrated to me how data can be written in…
Avro – getting it work
When you read about Hadoop, you come across AVRO. This is a mechanism to exchange data via streams and it is named after the famous British aircraft industry that amongst…
How to find a file on Linux
There are zillions of small little Linux commands that make life easy. Those tiny little commands may save you hours of time and tons of frustration. Wheneever I look as…
Add data on Big Data in Hive and Impala
This post provides info on how data may be added on a Big Data platform with help of Hive and Impala. We start with a dataset that is stored on…
Dropping a table in Oracle
To drop a table is straightforward in Oracle. One might simply issue a drop table statement. Let us assume we have table HH. When “drop table HH” is fired, the…
transpose a record in Oracle
Transpose a record in Oracle isn’t easy. I had a small table with several records and one value in a record. I wanted to transpose that table into one record…
SQL Loader
The SQL Loader is a facility that allows you to load data files blazingly fast. It is able to do as data files are directly written to disk without any…
Calculate distances in Oracle
Oracle allows you to calculate a distance between two points. Such calculation is not trivial as one must take into account that distances are calculated over the globe and the…