Database, Data Engineering, Dbms, Data Modeling, Data Management.
BIGINT SUM NOT NULL ) ENGINE=OLAP AGGREGATE KEY(`dim1`,`dim3`,`dim5`) DISTRIBUTED BY HASH(`dim1`) BUCKETS 32 PROPERTIES ( "replication_allocation" = "tag.location.default: 3" ); Load the aggregated results into the table: insert into dws_agg_tbl select dwd_dup_tbl.dim1, dwd_dup_tbl.dim3,