Add two additional projections for new api queries

Change-Id: I06217613e8f482e11e7b90996237b6955948d99b
This commit is contained in:
Brad Klein 2016-08-02 15:44:51 -06:00
parent be290f6535
commit 4be79627e9
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');