Hi Flavio, Since 1.11(master), Flink supports "CREATE CATALOG ..." [1], we can use this statement create catalog dynamically.
Currently, Catalog[2] dose not supports any operations on TRIGGER. Flink can't also use such info now. What's your user scenario? [1] https://issues.apache.org/jira/browse/FLINK-15349 [2] https://ci.apache.org/projects/flink/flink-docs-stable/dev/table/catalogs.html#catalog-api Best, Godfrey Flavio Pompermaier <pomperma...@okkam.it> 于2020年4月16日周四 下午6:16写道： > Hi Godfrey, > I'd like to use the SQL gateway as a data proxy in our architecture. > However, catalogs in our use case are not know at configuration time.. > is there a way to permit to register a JDBC catalog (for example when I > want to connect to a Postgres database)? > What if I want to add SHOW TRIGGERS? Do you think it could be interesting? > > On Thu, Apr 16, 2020 at 10:55 AM godfrey he <godfre...@gmail.com> wrote: > >> Hi Flavio, >> >> We prose FLIP-91[1] to support SQL Gateway at the beginning of this year. >> After a long discussion, we reached an agreement that >> SQL Gateway is an eco-system under ververia as first step.[2] >> Which could help SQL Gateway move forward faster. >> Now we almost finish first version development, some users are trying it >> out. >> Any suggestions are welcome! >> >> [1] >> https://docs.google.com/document/d/1DKpFdov1o_ObvrCmU-5xi-VrT6nR2gxq-BbswSSI9j8/edit?ts=5e4cd711#heading=h.sru3xzbt2i1k >> [2] https://github.com/ververica/flink-sql-gateway >> >> Best, >> Godfrey >> >> Flavio Pompermaier <pomperma...@okkam.it> 于2020年4月16日周四 下午4:42写道： >> >>> Hi Jeff, >>> FLIP-24 [1] proposed to develop a SQL gateway to query Flink via SQL but >>> since then no progress has been made on that point. Do you think that >>> Zeppelin could be used somehow as a SQL Gateway towards Flink for the >>> moment? >>> Any chance that a Flink SQL Gateway could ever be developed? Is there >>> anybody interested in this? >>> >>> Best, >>> Flavio >>> >>> [1] >>> https://cwiki.apache.org/confluence/display/FLINK/FLIP-24+-+SQL+Client >>> >> > > -- > Flavio Pompermaier > Development Department > > OKKAM S.r.l. > Tel. +(39) 0461 041809 >
