kylin hbase table

[#1]

Hi All,

I set up Kylin2.0 on hdp2.5 - built the sample sales cube. I wanted to see the hbase table, which table does kylin stores data?

hbase(main):005:0> list_namespace_tables 'default'

TABLE

ATLAS_ENTITY_AUDIT_EVENTS

KYLIN_ANX1S4IYMZ

atlas_titan

kylin_metadata

kylin_metadata_acl

kylin_metadata_user

6 row(s) in 0.0190 seconds

Thanks,

Avijeet

[#2]

The tables with "KYLIN_" prefix are the tables for Cube. You can find the table when you expand the cube, in the "storage" tab. For example:

Segment: 20120101000000_20120401000000

• Start Time: 2012-01-01 00:00:00
• End Time: 2012-04-01 00:00:00
• Source Count: 1230
• HBase Table: KYLIN_46ZXODICFE
• Region Count: 1
• Size: 10 MB

Then you can scan this table with HBase shell. While as the Cube data is encoded (with dictionary or other encoding method), so it is not readable for human.