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

Aggregate tables don't work in Vertica - patch provided

    XMLWordPrintable

    Details

    • 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:
      None
    • 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.

      Description

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

      Quoting:

      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

      {"TABLE"}

      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

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: