Uploaded image for project: 'Pentaho Analysis - Mondrian'
  1. Pentaho Analysis - Mondrian
  2. MONDRIAN-562

Aggregate tables don't work in Vertica - patch provided



    • Type: Bug
    • Status: Closed
    • Severity: Unknown
    • Resolution: Fixed
    • Affects Version/s: 3.1 GA
    • Fix Version/s: 3.1.2 GA
    • Component/s: Aggregation Tables
    • Labels:
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.


      I just hit this problem: http://forums.pentaho.org/showthread.php?t=65499


      I am using Mondrian connected to a Vertica database and I recently had a problem where my aggregation tables were not being picked up. I was also getting the warning "No Table found for fact name", which is raised in mondrian.rolap.aggmatcher.AggTableManager.loadRola pStarAggregates()

      The problem occurs in the JdbcSchema.loadTables() method (mondrian.rolap.aggmatcher package). This method queries the database to get a list of all tables. It uses the java.sql.DatabaseMetaData.getTables method, passing the following value

      { "TABLE", "VIEW" }

      as the 'types' parameter. As the "VIEW" table type is not available in Vertica, this getTables() call returns nothing. However, changing the types parameter to


      leads to the getTables method returning all tables in the Vertica database. I confirmed this and the change also leads to aggregate tables working in my Vertica installation.

      I changed JdbcSchema.java to make 2 separate calls, one for TABLE and one for VIEW, and it works. We'll also report this to Vertica, as I don't think this is a mondrian bug, but more of a incoherence in vertica.

      However, it solved my problem




            • Assignee:
              jhyde Julian Hyde (Inactive)
              pmalves Pedro Alves
            • Votes:
              0 Vote for this issue
              1 Start watching this issue


              • Created: