Multi-Stage Materialized Views

CREATE MATERIALIZED VIEW factDimView (
  ts      LONG DATETIME FORMAT '1:MILLISECONDS:EPOCH' GRANULARITY '1:DAYS',
  country STRING,
  amountSum DOUBLE METRIC
)
REFRESH EVERY '1d'
PROPERTIES (
  'timeColumnName'      = 'ts',
  'useMultiStageEngine' = 'true',
  'bucketTimePeriod'    = '1d',
  'bufferTimePeriod'    = '0d'
)
AS
SELECT f.ts AS ts, d.country AS country, SUM(f.amount) AS amountSum
FROM salesFact f JOIN countryDim d ON f.userId = d.userId
GROUP BY f.ts, d.country;

{
  "isMaterializedView": true,
  "segmentsConfig": { "timeColumnName": "ts" },
  "task": {
    "taskTypeConfigsMap": {
      "MaterializedViewGenerationTask": {
        "definedSQL": "SELECT f.ts AS ts, d.country AS country, SUM(f.amount) AS amountSum FROM salesFact f JOIN countryDim d ON f.userId = d.userId GROUP BY f.ts, d.country",
        "bucketTimePeriod": "1d",
        "bufferTimePeriod": "0d",
        "maxTasksPerBatch": "10"
      }
    }
  }
}