1. I have MonetDB Database Server Toolkit v1.1 (Feb2013-SP3)
  (i install so: sudo apt-get install monetdb5-sql monetdb-client)
  shell> monetdbd create /path/to/mydbfarm
 shell> monetdbd start /path/to/mydbfarm
 shell> monetdb create voc
 shell> monetdb release voc
2. Ubuntu 12.04.3 LTS
3.  Schema and data:

Schema:

CREATE TABLE timedimension (
  id integer NOT NULL,
  yeart int DEFAULT NULL,
  quarter varchar(2) DEFAULT NULL,
  weekyear int DEFAULT NULL,
  dayt int DEFAULT NULL,
  namemonth varchar(10) DEFAULT NULL,
  nameday varchar(20) DEFAULT NULL,
  montht int DEFAULT NULL,
  day_of_week varchar(15) DEFAULT NULL,
  date date DEFAULT NULL,
  month2 char(2) DEFAULT NULL
) 

CREATE TABLE bi_con_cdr_diario
(
  ano INT
, facmesfac VARCHAR(6)
, comcodigo INT
, succodigo VARCHAR(3)
, procodigo INT
, pronombre VARCHAR(20)
, prycodigo VARCHAR(20)
, fecllamada  timestamp
, clicodigo INT
, clinombre VARCHAR(80)
, vencodigo INT
, vennombre VARCHAR(50)
, sercodigo VARCHAR(3)
, pryservicio VARCHAR(4)
, sertipo VARCHAR(3)
, serclase VARCHAR(4)
, trdtipotelefono CHAR(10)
, cfacodigo INT
, cfanombre VARCHAR(30)
, trddurllamada INT
, minutosreales DOUBLE
, minutosenteros INT
, minutosfacturados DOUBLE
, costo DOUBLE
, costohit DOUBLE
, valorbruto DOUBLE
, valorneto DOUBLE
, trdvalorlocalneto DOUBLE
, trdvalorlocalimpu DOUBLE
, valorlocal DOUBLE
, codpaisori INT
, nompaisori VARCHAR(80)
, codpaisdes INT
, nompaisdes VARCHAR(80)
, comnombre2 VARCHAR(15)
, linprnombre VARCHAR(40)
, trdcodciuori BIGINT
, trdnomciuori VARCHAR(80)
, sernombre VARCHAR(50)
, idtimedimension integer
, linprcodigo INT
, trdcodciudes INT
, trdnomciudes VARCHAR(80)
);

Timedimension data:20080101,2008,"1",1,1,"Ene","",1,"Martes","2008-01-01","01"
bi_con_cdr_diario data:2013,"092013",4,"CTA",4,"EMBRATEL","HITBRAEMB","2013-09-04 00:00:00",3608,"Air Liquide do Brasil Ltda - Canoas",420,"Flavio Eugenio/Caroline Carneiro","E-N","E-N","ddd","PSTN","Fijo",89,"Consumo",459,7.65,10,10,0.66924,0.66924,1.43199992,1.1456000328063967,3.437,0.471,3.9080000000000004,55,"Brasil",55,"Brazil","HitBrasil","HIT VOICE",0,"0","HIT CALLSERVICE  EMB NAL",20130904,1,0,"0",\N

But the error is when i do group by as (select sum(minutosfacturados),succodigo,montht,comnombre2 from bi_con_cdr_diario as cdr inner join timedimension as td on cdr.idtimedimension=td.id  where comcodigo=4 group by succodigo,comnombre2,montht;) and have 10.000.000 of rows. 

I appreciate very much your help. I believe this is one great product.

Best Regards,


Edgar Mejia