Archive for September, 2011

muSOAing for 9/15/11 – Hive is buzzing

September 15, 2011

So there has always been a lot of buzz around Hive (no pun intended). Traditional DB users have always loved Hive, what with it’s SQL like language to perform DDL and DML operations. Now when it comes to features like updates and indexing, that is where things start to get a bit rough. Hive is certainly not contender for queries that involve low latency. When it runs map/reduce for pretty much every type of query. Updates are another big issue, it being an append only store. Some innovative solutions like partitioning data properly seems to be the way to go but there are a lot of other strategies being adopted to deal with this issue, not limited to hooking it up with HBase. Watch this space for more updates (again no pun intended).