Apache Drill
SQL across varied data formats
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.