Merge "Add two additional projections for new api queries"

This commit is contained in:
Jenkins 2016-08-04 13:25:12 +00:00 committed by Gerrit Code Review
commit 16edf3ad1e
1 changed files with 31 additions and 0 deletions

View File

@ -103,6 +103,22 @@ AS
value
UNSEGMENTED ALL NODES;
CREATE PROJECTION MonMetrics.Dimensions_rep_set_id /*+createtype(D)*/
(
dimension_set_id,
name ENCODING RLE,
value
)
AS
SELECT Dimensions.dimension_set_id,
Dimensions.name,
Dimensions.value
FROM MonMetrics.Dimensions
ORDER BY Dimensions.dimension_set_id,
Dimensions.name,
Dimensions.value
UNSEGMENTED ALL NODES;
CREATE PROJECTION DefinitionDimensions_DBD_4_rep_MonMetrics /*+createtype(D)*/
(
id ENCODING AUTO,
@ -118,4 +134,19 @@ AS
dimension_set_id
UNSEGMENTED ALL NODES;
CREATE PROJECTION MonMetrics.DefinitionDimensions_rep_set_id /*+createtype(D)*/
(
id ENCODING AUTO,
definition_id ENCODING AUTO,
dimension_set_id ENCODING RLE
)
AS
SELECT id,
definition_id,
dimension_set_id
FROM MonMetrics.DefinitionDimensions
ORDER BY dimension_set_id,
definition_id
UNSEGMENTED ALL NODES;
select refresh('MonMetrics.Measurements, MonMetrics.Definitions, MonMetrics.Dimensions, MonMetrics.DefinitionDimensions');