[Mondrian] (on latest builds of) Mondrian 3.4: Mondrian Error:Internal error: Reading cardinality for column
Pedro Alves
pmgalves at gmail.com
Fri Apr 13 08:59:26 EDT 2012
Any drill on the date dimension. Here's the definition of it, a very
standard one:
<Dimension name="Date" foreignKey="utc_date_id"
type="TimeDimension">
<Hierarchy hasAll="true" allMemberName="All"
primaryKey="date_id">
<Table name="dates"/>
<Level name="Year" column="year"
uniqueMembers="true" levelType="TimeYears" type="Numeric" />
<Level name="Month" column="month"
uniqueMembers="false" levelType="TimeMonths" type="Numeric" />
<Level name="Day of month"
column="day_of_month" uniqueMembers="false" levelType="TimeDays"
type="Numeric" />
<Level name="Date" column="date"
type="String" uniqueMembers="true" levelType="TimeDays"
hideMemberIf="Never">
<Property name="dow"
column="day_of_week_desc">
</Property>
</Level>
</Hierarchy>
</Dimension>
Vertica dialect.
Something changed recently that could cause this?
-pedro
On Fri 13 Apr 2012 01:36:03 PM WEST, Luc Boudreau wrote:
> Can you give more details? Is there a particular MDX query that
> reproduces it? Which DB dialect is used?
>
> Luc
>
> On Apr 13, 2012 8:12 AM, "Pedro Alves" <pmgalves at gmail.com
> <mailto:pmgalves at gmail.com>> wrote:
>
>
> We started to get an error in our mozilla installation, where we're
> already using pentaho 4.5 branch that includes mondrian 3.4-SNAPSHOT
>
>
> Yesterday (+-) we started to get a nasty error - basically
> everything's
> failing. Here's the error:
>
>
> Mondrian Error:Internal error: Reading cardinality for column [null,
> null, dates, date]; sql=[select count(*) from (select distinct "date"
> from "dates") as ]
>
>
> On the logs we explicitly see:
>
> DEBUG [mondrian.rolap.RolapUtil]
> SqlStatisticsProvider.getColumnCardinality: executing sql
> [select count(*) from (select distinct "year" from
> "dates") as ], failed (com.vertica.util.PSQLException: ERROR: syntax
> error at end of input)
>
> Seems to be missing something next to the "AS".
>
>
> I'm very worried about this, since we're very close to the final
> builds
> of 4.5 / 3.4 :(
>
>
>
> -pedro
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org <mailto:Mondrian at pentaho.org>
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
>
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
More information about the Mondrian
mailing list