[MonetDB-users] MonetDB - Mondrian connection
Hi guys! I have been trying MonetDB and it's awesome. I tried to connect MonetDB to Mondrian using olap4j. I managed to establish the connection using the MonetDB JDBC, but I have a problem: There are no errors, but it presents the wrong results. Every MDX query returns the right tables, but with all values "zeroed", something like this: ------------------------ Unit Sales ========== 0 ------------------------ I tried to make a simple JDBC connection, and it worked out ok. I am using the following connection string: String connectionProperties = "jdbc:mondrian:JdbcDrivers=nl.cwi.monetdb.jdbc.MonetDriver;" + "Jdbc=jdbc:monetdb://localhost/foodmart;" + "JdbcUser=monetdb;" + "JdbcPassword=monetdb;" + "Catalog=FoodMart.xml;"; Does anyone knows if I am doing anything wrong? Has anyone managed to make a working connection between Mondrian and Monet? If so, did you have to make something special? It would be great to have a working connection between Mondrian and MonetDB, since its much faster than MySQL or LucidDB, which I have already tried. Best regards, Pedro
On Thu, 29 Mar 2012, Pedro Salgueiro wrote:
Has anyone managed to make a working connection between Mondrian and Monet? If so, did you have to make something special?
Years ago I have done some tests using Mondrian, but it did require some changes to allow the Mondrian queries to work such as row id functionality. If you debug the JDBC/ODBC connection, you might get the query that is actually executed. I would suggest to run the test suite of Mondrian. Stefan
I have already debugged Mondrian to see all the SQL queries generated by Mondrian. I tried them all in MonetDB and they all worked ok. Here is a dump of the debug: http://pastebin.com/TnTfzmdM The in the end of the debug is not the problem, since the same error also appears when using MySql instead of MonetDB. If there is really the need to change something in Mondrian, wouldn’t that cause other errors? I will look into the test suit of Mondrian. Pedro On 03/29/2012 01:01 PM, Stefan de Konink wrote:
On Thu, 29 Mar 2012, Pedro Salgueiro wrote:
Has anyone managed to make a working connection between Mondrian and Monet? If so, did you have to make something special? Years ago I have done some tests using Mondrian, but it did require some changes to allow the Mondrian queries to work such as row id functionality. If you debug the JDBC/ODBC connection, you might get the query that is actually executed.
I would suggest to run the test suite of Mondrian.
Stefan
------------------------------------------------------------------------------ This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
Made some more advances. I found out that if I use a column of type INTEGER, the query works and gives the right results. On the other hand, if I use a column of type DECIMAL(10,4), the result is 0(zero)... Any ideas of what might be the problem? On 03/29/2012 02:14 PM, Pedro Salgueiro wrote:
I have already debugged Mondrian to see all the SQL queries generated by Mondrian. I tried them all in MonetDB and they all worked ok.
Here is a dump of the debug: http://pastebin.com/TnTfzmdM
The in the end of the debug is not the problem, since the same error also appears when using MySql instead of MonetDB.
If there is really the need to change something in Mondrian, wouldn’t that cause other errors?
I will look into the test suit of Mondrian.
Pedro
On 03/29/2012 01:01 PM, Stefan de Konink wrote:
On Thu, 29 Mar 2012, Pedro Salgueiro wrote:
Has anyone managed to make a working connection between Mondrian and Monet? If so, did you have to make something special? Years ago I have done some tests using Mondrian, but it did require some changes to allow the Mondrian queries to work such as row id functionality. If you debug the JDBC/ODBC connection, you might get the query that is actually executed.
I would suggest to run the test suite of Mondrian.
Stefan
------------------------------------------------------------------------------
This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
On 30-03-12 19:12, Pedro Salgueiro wrote:
Made some more advances.
I found out that if I use a column of type INTEGER, the query works and gives the right results. On the other hand, if I use a column of type DECIMAL(10,4), the result is 0(zero)...
Any ideas of what might be the problem?
Could you make an example query where this happens? Might be an overflow. Stefan
A simple query like the following one is enough to cause the problem
SELECT
[Measures].[Unit Sales] ON COLUMNS
FROM [Sales]
Thanks,
Pedro
On Fri, Mar 30, 2012 at 6:48 PM, Stefan de Konink
On 30-03-12 19:12, Pedro Salgueiro wrote:
Made some more advances.
I found out that if I use a column of type INTEGER, the query works and gives the right results. On the other hand, if I use a column of type DECIMAL(10,4), the result is 0(zero)...
Any ideas of what might be the problem?
Could you make an example query where this happens? Might be an overflow.
Stefan
------------------------------------------------------------------------------ This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
participants (2)
-
Pedro Salgueiro -
Stefan de Konink