8

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...

sudheer
  • 338
  • 1
  • 6
  • 17
  • possible duplicate of [Can OLAP be done in BigTable?](http://stackoverflow.com/questions/1424132/can-olap-be-done-in-bigtable) – Niels Basjes Aug 21 '13 at 10:41
  • I want to know how sas could be connected with hive and what would be the performance for reports an visualisation. – sudheer Aug 21 '13 at 13:29

2 Answers2

6

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

OneCricketeer
  • 179,855
  • 19
  • 132
  • 245
Tariq
  • 34,076
  • 8
  • 57
  • 79
  • Thanks for the information. I also want to know whether i can go with sas for reporting if i use hive cube dimensions. I can see that there is sas connectivity with hive. My doubt is, whether sas imports hive cubes into sas environment and queries there? or, It again hits hive for the purpose of reporting so that it runs MR which degrades my reporting performance to more than 2-4 secs. – sudheer Aug 21 '13 at 13:15
  • I am totally new to sas i want my reports generated with in 2-4 secs where my aggregated data is in Hive tables and then I have created cube dimensions over that. whether this can be achieved with sas/acess 9.3M2 interface? – sudheer Aug 21 '13 at 13:38
  • 1
    I don't think so(but get it confirmed to be 100% sure). It will just provide you an interface to your Hive data vis SAS. Importing all of your data from there to SAS doesn't make much sense. Have a look at SAS LASR, in case you haven't. – Tariq Aug 21 '13 at 16:40
  • Thanks I guess SAS Visual Analytics could do my job SAS LASR daemons run on each node of your Hadoop cluster. Based on administrative policies, data is loaded into LASR daemons from the HDFS filesystem. Soo I guess for reporting can be done over this.. Is there any gap in my understanding? – sudheer Aug 22 '13 at 05:43
3

You can look at Kylin from eBay. It enables you to build cubes from hive and saves the resulting data to hbase

OneCricketeer
  • 179,855
  • 19
  • 132
  • 245
Anuj J
  • 123
  • 2
  • 7