[DRILL-4866] Provide TABLE and PARTITION information in INFORMATION_SCHEMA for parquet tables created by Drill

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Metadata, Storage - Parquet
• Assignee: Unassigned
• Reporter: Andries Engelbrecht
• Created: 30/Aug/16 20:43
• Updated: 03/Jul/17 15:35

Description

Provide the Table and Partition information on parquet tables created by Drill in INFORMATION_SCHEMA. This can be utilized by tools and users looking to optimize Drill queries by referencing the table and partition metadata from within Drill, as opposed to querying the parquet metadata underneath.

Potentially extend INFORMATION_SCHEMA with an additional PARTITIONS table similar to MySQL to provide information on column(s) used for partitioning.

Issue Links

• relates to: DRILL-3572 Provide a simple interface to append metadata to files and directories (.drill)