Support Questions
Find answers, ask questions, and share your expertise

kylin hbase table

Expert Contributor

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

1 REPLY 1

Re: kylin hbase table

Explorer

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.