SQL Aggregation Reflection without Dimensions

Dremio University
1

Hey,
is there a way where I can create an Aggregation reflection with a SQL-Command without DIMENSIONS

These didn’t work for me:
ALTER DATASET “@dremio”.“Dataset” CREATE AGGREGATE REFLECTION Dataset_AGG USING DIMENSIONS () MEASURES (“Agencia_ID”);
ALTER DATASET “@dremio”.“Dataset” CREATE AGGREGATE REFLECTION Dataset_AGG USING MEASURES (“Agencia_ID”);

But the other way around with only Dimensions works fine:
ALTER DATASET “@dremio”.“Dataset” CREATE AGGREGATE REFLECTION Dataset USING DIMENSIONS (“Agencia_ID”) MEASURES();

Regards
Jonas

2

@Jonas

It seems like that, I am checking internally to see if there is any way out

As a workaround (which you may already know) is to create via the UI

Thanks
Bali