SQL-MapReduce Call - Aster Analytics

This query conducts a principal component analysis on the normalized input data:

CREATE TABLE pca_health_ev_scaled DISTRIBUTE BY REPLICATION AS
  SELECT * FROM pca_reduce (
    ON pca_map (
      ON pca_scaled
      TargetColumns ('[1:8]')
    ) PARTITION BY 1
  ) ORDER BY component_rank;