MonetDB icon indicating copy to clipboard operation
MonetDB copied to clipboard

Published 20 hours ago • verified publisher icon MonetDB

Enable grouping sets in Mondrian for MonetDB

Open llorieb opened this issue 3 years ago • 3 comments

I'm using MonetDB with Pentaho to analyze a very large fact table (around 200 millons rows and more than 50 columns). MonetDB Jun2020 release implemented grouping sets, and I think this feature would increase aggregates performance noticeably.

Today, using grouping sets in Pentaho Mondrian is a feature limited to a couple of databases (Oracle, DB2 and Greenplum), and it'd be great having MonetDB in such a selected group.

llorieb avatar May 07 '21 21:05 llorieb

Hello! Adding MonetDB support on Pentaho Mondrian is something we should do, or Pentaho?

PedroTadim avatar May 19 '21 14:05 PedroTadim

Hi, Pedro!

I don't know! If there's nothing to do in MonetDB in order to dialog with Mondrian, it's OK. I'm going to ask Pentaho if it's possible to support this functionality.

I truly appreciate your comment.

llorieb avatar May 19 '21 18:05 llorieb

One of our colleagues has started looking into if there's anything we need to do on the MonetDB side about this. We'll come back to this ticket once we know more.

yzchang avatar May 20 '21 08:05 yzchang