Details
-
Task
-
Status: Needs Feedback (View Workflow)
-
Minor
-
Resolution: Unresolved
-
None
Description
MariaDBs "LOAD DATA INFILE" command to be expanded to include the Oracle like feature of "external table".
Unsure what MariaDB could call it.
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 ?
https://its-all-about-oracle.blogspot.com/2013/09/advantages-of-external-table-over.html
Oracle External table has been around for last 20+ years since Oracle release 9.
https://oracle-base.com/articles/9i/external-tables-9i
https://docs.oracle.com/en/database/oracle/oracle-database/21/sutil/oracle-external-tables-concepts.html#GUID-ACF1D3AA-1D61-4682-AEC5-42C944756E12
What is the LOE to have this same feature in MariaDB Server in future releases ? I get this question a great deal during discovery.