Attach filesAttach ScreenshotVotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    Description

      As we deprecates execute method and explain method because of buffering SQLs/Tables execution problem. This issue aims to introduce a new method named createStatementSet to support executing and explaining the batching queries.

      interface TableEnvironment {
      
       /**
          * Create a StatementSet instance which can add DML statements or Tables
          * to the set, the planner can optimize all added statements and Tables
          * together for better performance.
          */
          StatementSet createStatementSet();
      }
      
      interface StatementSet  {
          /**
           * add insert statement to the set.
           */
          StatementSet addInsertSql(String statement);
       
          /**
           * add Table with the given sink table name to the set.
           */
          StatementSet addInsert(String targetPath, Table table);
       
          /**
           * add Table with the given sink table name to the set.
           */
          StatementSet addInsert(String targetPath, Table table, boolean overwrite);
       
          /**
           * returns the AST and the execution plan to compute the result of the
           * all statements and Tables.
           *
           * @param extraDetails the extra details which the plan should contain.
           * e.g. estimated cost, uid
           */
          String explain(ExplainDetail... extraDetails);
       
          /**
           * execute all statements and Tables as a batch.
           *
           * The added statements and Tables will be cleared when executing
           * this method.
           */
          TableResult execute();
      }
      

      Attachments

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            godfreyhe godfrey he
            godfreyhe godfrey he
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment