Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-29327

MariaDB to support Oracle like feature of External Tables

    XMLWordPrintable

Details

    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.

      Attachments

        Activity

          People

            ralf.gebhardt Ralf Gebhardt
            roger.eisentrager@mariadb.com Roger Eisentrager
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.