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