[MDEV-29327] MariaDB to support Oracle like feature of External Tables Created: 2022-08-18 Updated: 2022-08-23 |
|
| Status: | Needs Feedback |
| Project: | MariaDB Server |
| Component/s: | Data Definition - Create Table, Storage Engine - InnoDB |
| Fix Version/s: | None |
| Type: | Task | Priority: | Minor |
| Reporter: | Roger Eisentrager | Assignee: | Ralf Gebhardt |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | Compatibility | ||
| Description |
|
MariaDBs "LOAD DATA INFILE" command to be expanded to include the Oracle like feature of "external table". MariaDBs External Table feature would be outside of the database, and only Selects (reads) would be allowed on it. The Oracle external tables feature is a complement to existing Oracle SQL Loader functionality (similar to MariaDB's Load Data infile process). It enables you to access data in external sources as if it were in a table in the database using SQL selects. No updates, deletes, or inserts allowed. Why use Oracle External Tables ? What are the Benefits ? Oracle External table has been around for last 20+ years since Oracle release 9. https://oracle-base.com/articles/9i/external-tables-9i What is the LOE to have this same feature in MariaDB Server in future releases ? I get this question a great deal during discovery. |
| Comments |
| Comment by Sergei Golubchik [ 2022-08-23 ] |
|
it's CONNECT or CSV |