You are viewing the documentation for version
9.0 of DSS, which is outdated
An up to date version might be available
for the latest version
Grouping: aggregating data
The “grouping” recipe allows you to perform aggregations on any dataset in DSS, whether it’s a SQL dataset or not. This is the equivalent of a SQL “group by” statement. The recipe offers visual tools to setup the (custom) aggregations and aliases.
Depending on the input dataset types, DSS will adjust the engine it uses to execute the recipe, and choose between Hive, Impala, SparkSQL, plain SQL, and internal DSS. The available engines can be seen and selected by clicking on the cog below the “Run” button.