Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-3309

Revisit INFORMATION_SCHEMA's SQL compliance.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • Storage - Information Schema
    • None

    Description

      At some point, review the compliance with the SQL specification of Drill's INFORMATION_SCHEMA schema (other than INFORMATION_SCHEMA.COLUMNS, which addressed in DRILL-3308).

      (For reference, see ISO 9075 (SQL spec.) Part 11: Information and Definition Schemas (SQL/Schemata).)

      Notes:

      • INFORMATION_SCHEMA.INFORMATION_SCHEMA_CATALOG_NAME does not exist.
      • Short-name views of existing tables (e.g., TABLES_S for TABLES) do not exist.
      • Most standard-specified tables/views do not exist (but many probably aren't relevant for Drill).

      Attachments

        Issue Links

          supercedes

          Bug - A problem which impairs or prevents the functions of the product. DRILL-2522 Implement INFORMATION_SCHEMA.* enough for relevant tools [bug]

          • Major - Major loss of function.
          • Closed

          Activity

            People

              Unassigned Unassigned
              dsbos Daniel Barclay
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated: