0
votes
1answer
37 views

MySQL Rows to Columns to HBase (using Sqoop)

I have a table that looks like this in MySQL: id | date | num | avg I have found that I can use this for rows to columns and it works so far: SELECT CONCAT(id, '-', date), MAX(IF(`num` = ...
-1
votes
0answers
13 views

Best way to create a messaging system in terms of perfomance

I plan on creating a messaging system (1 user to 1 user) as an educational experience. I am in the design and research phase trying to find the right technologies. The database will have have about a ...
0
votes
1answer
215 views

Storing 5TB web server access log vs OLAP DB

We have over 5TB compressed web server log in a HDFS and we often analyse using Hadoop. It is painful to run map reduce on 5TB of data and most importantly, not many developer are familiar with it. ...