thanks Jing. there is a small mistake.useLike it means whether to enable like. e.g. SHOW TABLES from cat1.db1 not like 't%' // useLike is true, notLike is true SHOW TABLES from cat1.db1 like 't%' // useLike is true, notLike is false useLike both are true. I have updated the flip for this.
question2: i think currently we do not support 'ILIKE' in this flip. Because other statements are currently based on the implementation of LIKE, the implementation of this flip is compatible with other SQL syntax. also, in the doc in this flip you can find that some other engines only support LIKE. what do you think? Best Regards, Ran Tao https://github.com/chucheng92 Jing Ge <j...@ververica.com.invalid> 于2023年2月23日周四 00:50写道： > Hi Ran, > > Thanks for driving the FLIP. It looks overall good. Would you like to add > a description of useLike and notLike? I guess useLike true is for "LIKE" > and notLike true is for "NOT LIKE" but I am not sure if I understood it > correctly. Furthermore, does it make sense to support "ILIKE" too? > > Best regards, > Jing > > On Wed, Feb 22, 2023 at 1:17 PM Ran Tao <chucheng...@gmail.com> wrote: > > > Currently flink sql auxiliary statements has supported some good features > > such as catalog/databases/table support. > > > > But these features are not very complete compared with other popular > > engines such as spark, presto, hive and commercial engines such as > > snowflake. > > > > For example, many engines support show operation with filtering except > > flink, and support describe other object(flink only support describe > > table). > > > > I wonder can we add these useful features for flink? > > You can find details in this doc.[1] or FLIP.[2] > > > > Also, please let me know if there is a mistake. Looking forward to your > > reply. > > > > [1] > > > > > https://docs.google.com/document/d/1hAiOfPx14VTBTOlpyxG7FA2mB1k5M31VnKYad2XpJ1I/ > > [2] > > > > > https://cwiki.apache.org/confluence/display/FLINK/FLIP-297%3A+Improve+Auxiliary+Sql+Statements > > > > Best Regards, > > Ran Tao > > >
