XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 2.2.0
    • SQL
    • None

    Description

      On CREATE/ALTER a view, it's no longer needed to generate a SQL text string from the LogicalPlan, instead we store the SQL query text、the output schema of the LogicalPlan, and current database to CatalogTable. The new view resolution approach will be able to resolve the view.
      The main advantage includes:
      1. If you update an underlying view, the current view also gets updated;
      2. That gives us a change to get ride of SQL generation for operators.

      Should bring in the following changes:
      1. Add new params to `CatalogTable`, that represents the SQL query text、 the output schema of the LogicalPlan, and current database, on the time when the view is created;
      2. Update the commands `CreateViewCommand` and `AlterViewAsCommand`, get rid of SQL generation in them.

      Attachments

        Activity

          People

            jiangxb1987 Xingbo Jiang
            jiangxb1987 Xingbo Jiang
            Herman van Hövell Herman van Hövell
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: