flink-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jark Wu <imj...@gmail.com>
Subject Re: JDBC table api questions
Date Sat, 25 Apr 2020 14:08:16 GMT

I think views in a JDBC database is not the same thing of views in Flink
Catalog, but something like a read-only table as Flavio said.
Maybe we can provide a way to register a table only as a source even the
connector factory supports both source and sink.

cc @Bowen Li <bowenli86@gmail.com> , do you have some thoughts on this?


On Fri, 24 Apr 2020 at 15:13, Flavio Pompermaier <pompermaier@okkam.it>

> Ok, but how can view then retrieved via table API? If they are returned as
> Table objects, is there a way to mark them read only?
> Because VIEWS in Flink SQL are Flink Views, so how can I query JDBC views?
> On Fri, Apr 24, 2020 at 4:22 AM Zhenghua Gao <docete@gmail.com> wrote:
>> FLINK-16471 introduce a JDBCCatalog, which implements Catalog interface.
>> Currently we only support PostgresCatalog and listTables().
>> If you want to get the list of views, you can implement listViews()
>> (currently return an empty list).
>> *Best Regards,*
>> *Zhenghua Gao*
>> On Thu, Apr 23, 2020 at 8:48 PM Flavio Pompermaier <pompermaier@okkam.it>
>> wrote:
>>> Hi all,
>>> is there a way to get the list of existing views in a JDBC database?
>>> Is this something that could be supported somehow?
>>> Moreover, it would be interesting for us to also know the original field
>>> type of a table..is there a way to get it (without implementing a dedicated
>>> API)? Do you think it makes sense to expose it in the Table API?
>>> Best,
>>> Flavio

View raw message