Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Support Flink SQL DDL #3

Closed
knaufk opened this issue Jun 7, 2020 · 0 comments
Closed

Support Flink SQL DDL #3

knaufk opened this issue Jun 7, 2020 · 0 comments

Comments

@knaufk
Copy link
Contributor

knaufk commented Jun 7, 2020

I can execute a Flink SQL DDL statement in a Jupyter Notebook cell.

  • Supported

    • SHOW TABLES
    • SHOW FUNCTION
    • CREATE/ALTER/DROP FUNCTION
    • CREATE/ALTER DROP TABLE
    • DESCRIBE

  • Not supported (example)

    • CREATE TEMPORARY TABLE|VIEW

  • On success, the result is displayed in Jupyter Notebook.

  • On error, the error message is displayed in Jupyter Notebook.

Something like:

%%flink-sql

SHOW TABLES

Table Name
Test1
Test2
@knaufk knaufk changed the title Support DDL Support Flink DDL Jun 7, 2020
@knaufk knaufk changed the title Support Flink DDL Support Flink SQL DDL Jun 7, 2020
duresmeois added a commit that referenced this issue Jun 16, 2020
@duresmeois
#3 Make sessions easier to use.
4c7d32d
duresmeois added a commit that referenced this issue Jun 17, 2020
@duresmeois
#3 Moving SQL querying and handling to separate module.
f329a7d
duresmeois added a commit that referenced this issue Jun 17, 2020
@duresmeois
#3 Display meaningful feedback in magic; only raise the exception in …
e742a5c 
…flinksql.py.
@duresmeois duresmeois mentioned this issue Jun 18, 2020
Merged
duresmeois added a commit that referenced this issue Jun 18, 2020
@duresmeois
#3 Re-organise tests. Separate tests against backend into different c…
7bc9ac1 
…lass.
duresmeois added a commit that referenced this issue Jun 18, 2020
@duresmeois
#3 Remove remove superfluous tests from test_vvpmagics.py
0a99828
duresmeois added a commit that referenced this issue Jun 18, 2020
@duresmeois
#3 Remove unneeded functions.
3010cdd
duresmeois added a commit that referenced this issue Jun 18, 2020
@duresmeois
#3 Be more Pythonic in test.
2b625c5
duresmeois added a commit that referenced this issue Jun 18, 2020
@duresmeois
#3 Add missing __main__ check in tests.
0a02273
duresmeois added a commit that referenced this issue Jun 18, 2020
@duresmeois
#3 Making all tests runnable together: fixing path errors.
4df4225
duresmeois added a commit that referenced this issue Jun 18, 2020
@duresmeois
#3 Add notebook for flink_sql.
b18c805
duresmeois added a commit that referenced this issue Jun 18, 2020
@duresmeois
#3 Allow multiple notebooks to run in test_notebook.py
86f45fd
duresmeois added a commit that referenced this issue Jun 18, 2020
@duresmeois
#3 Move backend-dependent tests to integration tests folder.
780a9d2
duresmeois added a commit that referenced this issue Jun 18, 2020
@duresmeois
#3 Add missing calls to unittest.main()
c90842d
duresmeois added a commit that referenced this issue Jun 18, 2020
@duresmeois
#3 Return exception details for later processing.
8afbc11
duresmeois added a commit that referenced this issue Jun 18, 2020
@duresmeois
#3 Allow exceptions through so that IPython sees the errors.
e82d3c4
duresmeois added a commit that referenced this issue Jun 18, 2020
@duresmeois
#3 Make sure table name is random.
74cd81b
duresmeois added a commit that referenced this issue Jun 18, 2020
@duresmeois
#3 Remove variable table name: not being parsed correctly.
ef24d7d
duresmeois added a commit that referenced this issue Jun 18, 2020
@duresmeois
#3 Fix paths so that integration tests run from any working directory.
2b4d5e6
duresmeois added a commit that referenced this issue Jun 18, 2020
@duresmeois
#3 Format file
e40e2de
duresmeois added a commit that referenced this issue Jun 22, 2020
@duresmeois
#3 Updating README.md.
b268cd6
duresmeois added a commit that referenced this issue Jun 22, 2020
@duresmeois
#3 Fix integration tests to assert on the data frame.
4f7a05a
duresmeois added a commit that referenced this issue Jun 22, 2020
@duresmeois
Merge pull request #12 from dataArtisans/fix-integration-test-dataframe
d66fa98 
#3 Fix integration tests to assert on the data frame.
duresmeois added a commit that referenced this issue Jun 22, 2020
@duresmeois
#3 Move test notebooks to example_notebooks folder.
624f6e2
duresmeois added a commit that referenced this issue Jun 22, 2020
@duresmeois
#3 Add links to example notebooks.
dfcadba
duresmeois added a commit that referenced this issue Jun 22, 2020
@duresmeois
#3 Example error notebook.
a1a2cc0
michaelpisula pushed a commit that referenced this issue Jun 22, 2020
@pisulam
Merge pull request #11 from dataArtisans/fix-readme-flink-sql
e1d80a9 
#3 Updating README.md.
duresmeois added a commit that referenced this issue Jun 22, 2020
@duresmeois
#3 Add 400 as possible validation return type; update example errors …
12f68d5 
…notebook.
michaelpisula pushed a commit that referenced this issue Jun 22, 2020
@pisulam
Merge pull request #13 from dataArtisans/example-notebook-errors
fb1db32 
#3 Example error notebook.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@knaufk @duresmeois