[DRILL-3309] Revisit INFORMATION_SCHEMA's SQL compliance.

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Storage - Information Schema
• Assignee: Unassigned
• Reporter: Daniel Barclay
• Created: 18/Jun/15 05:27
• Updated: 18/Jun/15 05:32

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).

Issue Links

• supercedes: DRILL-2522 Implement INFORMATION_SCHEMA.* enough for relevant tools [bug]