Apache Drill

SQL across varied data formats

Visit Apache Drill official site

What it does

Drill provides a distributed SQL engine that reads files and external systems through storage plugins, supporting queries over varied data structures and formats without requiring every source to follow a table representation before analytical processing begins.

When to use it

When exploring JSON and Parquet files, use storage-plugin settings and query examples to understand how fields and nested structures are exposed to SQL operations.