[ 
https://issues.apache.org/jira/browse/CHUKWA-667?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14395966#comment-14395966
 ] 

Eric Yang commented on CHUKWA-667:
----------------------------------

For managing meta data of primary key composition, a tertiary table would be a 
good idea to track of the meta data.  The structure of the table could look 
like this:

Table: chukwa_meta
Row Key: [primary group]
Column Family: k
Column: [primary key]
Value: { "unit": "kb", "type": "gauge", "sig": [first 6 digit of md5 signature] 
}



> Optimize the HBase schema for Ganglia queris
> --------------------------------------------
>
>                 Key: CHUKWA-667
>                 URL: https://issues.apache.org/jira/browse/CHUKWA-667
>             Project: Chukwa
>          Issue Type: Sub-task
>          Components: Data Processors
>    Affects Versions: 0.6.0
>            Reporter: Saisai Shao
>
> Chukwa HBase table schema is designed for HICC, it cannot be fully adapted to 
> Ganglia web frontend for several reasons:
> (1) cannot fastly retrieve all the cluster and related host names.
> (2) system metrics have no attributes, like type, unit, so it is hard to 
> explain the collected metrics by code.
> (3) lack of data cosolidate function, choosing metric for a large time range 
> (like 30 days) will fetch all the data and draw graph, which will largely 
> lose performance.
> We will redesign the table schema that will be better adapted to Ganglia web 
> frontend queries.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to