Dropping a table in Oracle
tom
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…
Transpose in Oracle
Transposing data means changing data from a row into a column. Starting from version 11, this is possible in Oracle as well. It is possible to translate some values that…
Reading and writing in Java
Reading and writing from and to files is not easy in Java. This can already be seen if one simply googles on “Java Filereader problem”. This generated 477000 hits. Apparently,…
Another set of keys and values
Another example on how mapper and reducers are used in a Hadoop context is given below. This programme is created as three classes. One class is an overall class that…
Map and reduce – what happens?
In Big Data, the concept of mapping and reducing plays a huge role. The idea is that a a massive dataset is split over several servers. On each server, a…
Hive – connecting from SQL Developer
In my impression, the big development that takes place now in the world of Big Data is the creation of connectors. Such connectors enable us to continue using standard tools…
R – the shortest name possible
For some reason, short names are popular as computer languages. Think of “C”. Another example is “R”. R reminds me a bit of Matlab; it is an easy to learn…