Uploaded image for project: 'Apache Arrow'
  1. Apache Arrow
  2. ARROW-12037

[Rust] [DataFusion] Support catalogs and schemas for table namespacing

    XMLWordPrintableJSON

Details

    Description

      Proposal doc: https://docs.google.com/document/d/1_bCP_tjVRLJyOrMBOezSFNpF0hwPa1ZS_qMWv1uvtS4/edit?usp=sharing

       

      Summary from the doc:

      This is a particularly messy aspect of most SQL implementations, so let’s settle on some terms first:

      • Schema: a collection of named tables
      • Catalog: a collection of named schemas (also known as a database)

      This doc will attempt to describe a standards-compliant implementation for DataFusion, using Postgres’ design decisions as a guide where the standard is not prescriptive (due to our adoption of its query dialect).

      As an example of how this works in practice, given a default catalog of “db” and a default schema of “public”, all these table references would be equivalent:

      • db.public.my_table
      • public.my_table
      • my_table

      Attachments

        Issue Links

          Activity

            People

              ruan Ruan Pearce-Authers
              ruan Ruan Pearce-Authers
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 3h 20m
                  3h 20m