Create a script for Dremio reflection updates

1

Try to creating reflection using a query. Is that possible in community edition?

2

@RusiruDesilva

http://docs.dremio.com/sql-reference/sql-commands/acceleration/

alter dataset BI."p1_vds" CREATE AGGREGATE REFLECTION p1_vds_agg
  using dimensions (c1,c2) measures (p1(count, min),
  p2(sum, max,approximate count distinct))
PARTITION by (c1) localsort by (c2)
1 Like
3

This works. Thank you