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

          is a parent of

          New Feature - A new feature of the product, which has yet to be developed. FLINK-13734 Support DDL in SQL CLI

          • Major - Major loss of function.
          • Closed
          mentioned in

          Page Loading...

          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:
              35 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