...
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 |
show create table
Yes
Yes
or Not |
If it‘s a List function, does it support filtering |
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 |
show create function | No | Not Applicable |
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.
So we propose this flip, try to support these features.
...