这种方法可以在Postgre或Presto中获得成功,并在下面的片段中详细介绍如何在SparkSql文档中使用。CUBE|ROLLUP to GROUPINGSETS. group_expression can be treated as a single-groupGROUPINGSETS underFor example, GROUP BY warehouse, GROUPING
Of Students' FROM tblENROLLMENTGROUPBY ROLLUP (tblENROLLMENT.CourseId, tblCOURSE.CourseTitle)SELECTOf Students' FROM tblENROLLMENT
INNER JOIN tblCOURSE on tblENROLLME