zhicwu opened a new issue, #15845: URL: https://github.com/apache/doris/issues/15845
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Description Hi, is there any plan to extend JDBC table function for passing arbitrary query instead of just table name? Or a URL table function like the one in ClickHouse? With that, we should be able to issue federated query against tailored datasets from multiple databases. ### Use case We have a home-grown ERP system evolved for decades. There are many databases deployed world-wide for different purposes. Most of them are for OLTP and can be considered as small(<500GB, with weekly/monthly archiving). There's CDC implemented for layered DW to serve most common queries, along with ClickHouse as a data platform to process near real-time query against multiple databases for integrity check, data operation, and adhoc reporting etc. As we have increasing needs for near real-time queries, we'd like to investigate more options and extend capability of the platform. ### Related issues _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
