Can OLAP CUBE be done in HBase?

hadoop hbase ssas hive olap-cube
sudheer picture sudheer · Aug 20, 2013 · Viewed 7.5k times · Source

Is there any way to create CUBE DIMENSIONS in HBase or OLAP with it? I want to create CUBE DIMENSIONS kind of application with my HBASE or HIVE and connect that with SSAS for reporting purpose, is that possible? If soo please guide me with some links and codes.

I have tried to create cube views in hive and i want to know whether that is possible with HBase.

Thanks...

Answer

Tariq picture Tariq · Aug 20, 2013

It is quite possible. In fact several attempts have been made in recent past towards the same. See HBase-Lattice and urbanairship datacube, for example.

You might also find this presentation helpful, which talks about Low Latency “OLAP” with HBase.

HTH

Related questions

When to use Hadoop, HBase, Hive and Pig?

What are the benefits of using either Hadoop or HBase or Hive ? From my understanding, HBase avoids using map-reduce and has a column oriented storage on top of HDFS. Hive is a sql-like interface for Hadoop and HBase. I would …

Read More
Hbase quickly count number of rows

Right now I implement row count over ResultScanner like this for (Result rs = scanner.next(); rs != null; rs = scanner.next()) { number++; } If data reaching millions time computing is large.I want to compute in real time that i don't want …

Read More
Hive load CSV with commas in quoted fields

I am trying to load a CSV file into a Hive table like so: CREATE TABLE mytable ( num1 INT, text1 STRING, num2 INT, text2 STRING ) ROW FORMAT DELIMITED FIELDS TERMINATED BY ","; LOAD DATA LOCAL INPATH '/data.csv' OVERWRITE INTO …

Read More