[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".
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.



 Comments   
Comment by Sergei Golubchik [ 2022-08-23 ]

it's CONNECT or CSV

Generated at Thu Feb 08 10:07:40 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.