...
But these features are not very complete compared with other popular engines such as spark, presto. And these improved features are very useful for users or developers.
show | Support or Not |
Support filter or Not | ||
show tables | Yes | Yes |
show columns | Yes | Yes |
show catalogs | Yes | No |
show databases | Yes | No |
show functions | Yes | No |
show views | Yes | No |
show modules | Yes | No |
show jars | Yes | No |
show jobs | Yes |
No
show create table
No
Not Applicable
show create view
No
Not Applicable
No |
We can see current flink many sql statements only support showing with full datas, without 'FROM/IN' or 'LIKE' filter clause. And current flink lack some abilities such as `show create table`, `show create view`, `show create function`.
describe | Support or Not |
describe database | No |
describe table | Yes |
describe function | No |
describe query | No |
current flink only supports describing tables.
...