[Mondrian] Re: Regression tests MonetDB

Stefan de Konink stefan at konink.de
Mon Feb 23 19:55:37 EST 2009


John V. Sichi wrote:
> Stefan de Konink wrote:
>> Maybe you are better than google, but do you by any chance know where 
>> we can find the syntax requirement for the following:
>>
>> select "store"."store_country" as "c0", "store"."store_state" as "c1", 
>> "store"."store_city" as "c2" from "store" as "store", 
>> "sales_fact_1997" as "sales_fact_1997", "time_by_day" as "time_by_day" 
>> where "sales_fact_1997"."store_id" = "store"."store_id" and 
>> "sales_fact_1997"."time_id" = "time_by_day"."time_id" and 
>> "time_by_day"."the_year" = 1997 group by "store"."store_country", 
>> "store"."store_state", "store"."store_city" order by
>>
>> count("sales_fact_1997"."product_id") DESC,
>>
>> "store"."store_country" ASC, "store....
>>
>>
>> It is the count part in the order by section.
> 
> I've never seen Mondrian generate an agg call inside the ORDER BY...what 
> MDX and schema did you use to make it do that?

5) queryTest_29ce2f3512f79d38_TOPCOUNT.xml

(Attached for your convenience)


If you really want to see some incredble weird stuff take a look in:

11) queryTest_aggregate_ffc012281623093.xml

  Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal 
error: while building member cache; sql=[select "store"."store_country" 
as "c0" from "store" as "store" where

UPPER("store"."store_country") = UPPER('20319')

group by "store"."store_country" order by "store"."store_country" ASC]

sql>select store_country from store;
+---------------+
| store_country |
+===============+
| USA           |
| Mexico        |
| USA           |
| USA           |
| Mexico        |
| Mexico        |
| USA           |
| USA           |
| Mexico        |
| Mexico        |
| Mexico        |
| USA           |
| Mexico        |
| USA           |
| USA           |
| USA           |
| USA           |
| USA           |
| Mexico        |
| Canada        |
| Canada        |
| Mexico        |
| USA           |
| USA           |
| USA           |
+---------------+


Stefan
-------------- next part --------------
A non-text attachment was scrubbed...
Name: queryTest_29ce2f3512f79d38_TOPCOUNT.xml
Type: text/xml
Size: 7420 bytes
Desc: not available
Url : http://lists.pentaho.org/pipermail/mondrian/attachments/20090224/739d9874/attachment.xml 


More information about the Mondrian mailing list