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

kylin hbase table

Highlighted

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
Highlighted

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.

Don't have an account?