HappenLee opened a new issue #5031: URL: https://github.com/apache/incubator-doris/issues/5031
## Motivation Currently, Doris support query External Table of ODBC table. It is extremely necessary for us to be able to write the results of this external query in ODBC. For example, we can use Doris to process data and write the results back to the RDMS online to provide results for external queries ### It can bring us the following benefits: 1. We can regard Doris as a data federation, all kinds of data sources can access Doris. Which can use Doris's powerful analysis ability and write the analysis results to any place we want to place. 2. Using Doris for data free migration, for example, it can be very simple to use ` insert into odbc_pg from odbc_oracle` Oracle table data migration to PostgreSQL, which sounds like a cool thing. ## Implementation 1. First, we should refactor the code of ODBC scanner, renaming ODBC scanner to ODBC connector, supporting reading and writing at the same object. 2. Use ODBC transaction API to support the atomicity of insert into ODBC table, which is to prevent the possibility of data inserting into part ---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
