Uploaded image for project: 'Flink'
  1. Flink
  2. FLINK-7594

Add a SQL client

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • None
    • Table SQL / Client
    • None

    Description

      At the moment a user can only specify queries within a Java/Scala program which is nice for integrating table programs or parts of it with DataSet or DataStream API. With more connectors coming up, it is time to also provide a programming-free SQL client. The SQL client should consist of a CLI interface and maybe also a REST API. The concrete design is still up for discussion.

      Attachments

        Issue Links

          1.
          Add a basic embedded SQL CLI client Sub-task Resolved Timo Walther  
          2.
          Improve basic embedded SQL client Sub-task Closed Unassigned  
          3.
          SQL Client does not support Event-time Sub-task Resolved Timo Walther  
          4.
          SQL Client does not work with new FLIP-6 mode Sub-task Resolved Timo Walther  
          5.
          SQL Client cannot emit query results that contain a rowtime attribute Sub-task Closed Timo Walther  
          6.
          Add support for batch queries in SQL Client Sub-task Resolved Xingcan Cui  
          7.
          Add user-defined function support in SQL Client Sub-task Resolved Xingcan Cui  
          8.
          Add CLI query history in SQL Client Sub-task Closed Kurt Young
          9.
          Add CLI query code completion in SQL Client Sub-task Resolved xueyu  
          10.
          Add support for INSERT INTO in SQL Client Sub-task Resolved Timo Walther  
          11.
          Validate configurations for SQL Client Sub-task Resolved Timo Walther  
          12.
          Escape control characters when outputting on SQL Client CLI Sub-task Closed Unassigned  
          13.
          Add SQL Client documentation page Sub-task Resolved Timo Walther  
          14.
          Changing refresh interval in changelog mode leads to exception Sub-task Resolved Timo Walther  
          15.
          Add a REST-based SQL Client Gateway Sub-task Closed Unassigned  
          16.
          Add documentation for UDF in SQL Client Sub-task Resolved Xingcan Cui  
          17.
          Allow passing multi-line input to SQL Client CLI Sub-task Closed Unassigned
          18.
          Document usage of INSERT INTO in SQL Client Sub-task Resolved Timo Walther  
          19.
          Support a traditional and scrolling view of result (non-interactive) Sub-task Closed Kurt Young
          20.
          Reuse TableEnvironment between different SQL statements Sub-task Closed Zhenghua Gao
          21.
          Execute multiple statements in command line or sql script file Sub-task Closed Unassigned
          22.
          Support -q option with a sql query statement as input Sub-task Closed Unassigned
          23.
          Refactor the SQL CLI parser to reuse flink-sql-parser Sub-task Closed Unassigned  
          24.
          Support database DDLs in SQL CLI Sub-task Closed Terry Wang
          25.
          Support alter table DDLs in SQL CLI Sub-task Closed Terry Wang
          26.
          Add create table support for SqlClient Sub-task Closed Zheng Hu
          27.
          Add doc to introduce ddls or dmls supported by sql cli Sub-task Closed Unassigned  

          Activity

            People

              twalthr Timo Walther
              twalthr Timo Walther
              Votes:
              6 Vote for this issue
              Watchers:
              38 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 3h 50m
                  3h 50m