openstack
/
puppet-monasca
Code Issues Proposed changes

New vertica measurements projection for time based indexing 

Change-Id: Ic42d77614a5fb7b9177591640d216cf7ce2cc178
This commit is contained in:
Brad Klein 2016-08-01 08:36:40 -06:00
parent 4b36f0a080
commit ce5b5ae684
1 changed files with 17 additions and 0 deletions
Show Stats Download Patch File Download Diff File Expand all files Collapse all files

17
files/vertica/mon_metrics_schema.sql
View File

@ -52,6 +52,23 @@ AS
time_stamp
UNSEGMENTED ALL NODES;
CREATE PROJECTION Measurements_time_order_rep_MonMetrics /*+createtype(D)*/
(
definition_dimensions_id ENCODING RLE,
time_stamp ENCODING COMMONDELTA_COMP,
value ENCODING AUTO,
value_meta ENCODING AUTO
)
AS
SELECT definition_dimensions_id,
time_stamp,
value,
value_meta
FROM MonMetrics.Measurements
ORDER BY time_stamp,
definition_dimensions_id
UNSEGMENTED ALL NODES;
CREATE PROJECTION Definitions_DBD_2_rep_MonMetrics /*+createtype(D)*/
(
id ENCODING AUTO,