Pentaho Analysis - Mondrian
  1. Pentaho Analysis - Mondrian
  2. MONDRIAN-887

Allow Mondrian to not quote tables and columns when generating SQL

    Details

    • Type: Improvement Improvement
    • Status: Resolved
    • Priority: Severe Severe
    • Resolution: Fixed
    • Affects Version/s: 3.2.1 GA (3.7.0 GA Suite Release)
    • Component/s: None
    • Labels:
      None

      Description

      Pentaho Metadata and Pentaho Data Integration allow the user to specify whether objects in the database are quoted. Allowing this option in Mondrian will make it easier for folks using Agile BI.

        Issue Links

          Activity

          Hide
          Julian Hyde added a comment -
          Makes sense.

          To implement this, we will probably need to add a MondrianMetaData (new interface) as a parameter to the constructor of a Dialect object. Then we can add metadata to the connection that is about the preferences of the user, not about the capabilities of the database. Then Mondrian is run inside the platform, the MondrianMetaData object will be implemented under the covers by Kettle's database metadata object.
          Show
          Julian Hyde added a comment - Makes sense. To implement this, we will probably need to add a MondrianMetaData (new interface) as a parameter to the constructor of a Dialect object. Then we can add metadata to the connection that is about the preferences of the user, not about the capabilities of the database. Then Mondrian is run inside the platform, the MondrianMetaData object will be implemented under the covers by Kettle's database metadata object.
          Hide
          Julian Hyde added a comment -
          I removed "On a per connection or schema basis, ..." prefix to this case's description. It is not easy to change SQL generation preferences per connection. I prefer that they are a property of the schema. You need to set the quoteSql attribute of the Schema XML element.
          Show
          Julian Hyde added a comment - I removed "On a per connection or schema basis, ..." prefix to this case's description. It is not easy to change SQL generation preferences per connection. I prefer that they are a property of the schema. You need to set the quoteSql attribute of the Schema XML element.
          Show
          Julian Hyde added a comment - Fixed on lagunitas branch in https://github.com/pentaho/mondrian/commit/d4c5da437882ff94d44737fbbb7e95f669753c10

            People

            • Assignee:
              Julian Hyde
              Reporter:
              Will Gorman
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: