Apache Drill vs HeidiSQL

Apache Drill is a schema-free SQL query engine for Hadoop, NoSQL databases, and cloud storage. It can query raw data where it resides without first loading it, defining schemas, or transforming it. Its JSON data model supports complex and nested structures, and a single query can join data across multiple datastores. Listed sources include HBase, MongoDB, HDFS, Amazon S3, Azure Blob Storage, Google Cloud Storage, Swift, NAS, and local files. JDBC and ODBC drivers connect Drill to tools including Tableau, Qlik, MicroStrategy, Spotfire, SAS, and Excel; developers can also use its REST API in custom applications. Drill can run embedded on a laptop or in distributed mode on a server cluster, and the homepage lists Mac, Windows, and Linux. Documented security options include Kerberos, username and password authentication, Digest, authorization, and impersonation. The software is free under Apache License 2.0. A compatibility limit: official support for Hadoop 2 and Java 8 was dropped with Drill 1.22.0.

HeidiSQL is free desktop database client software for connecting to databases and editing their data and structures. It supports MariaDB, MySQL, MS SQL, PostgreSQL, SQLite, Interbase, Firebird, ProxySQL, and Redshift, with multiple connections in one window. Connections can use SSH tunnels or SSL settings. Users can create and edit tables, views, stored routines, triggers, and scheduled events. The query editor provides customizable syntax highlighting, code completion, SQL reformatting, and query history. Text files can be imported, while table rows can be exported as CSV, HTML, XML, SQL, LaTeX, Textile, PHP, Markdown, or JSON. Data can also be exported directly between servers or databases. Builds are offered for Windows, Linux, and macOS, including Linux x64 and arm64 packages, a macOS arm64 app bundle, and a Windows x64 portable edition. HeidiSQL requires an available database server or SQLite file; the requirements page says running through Wine is currently unstable and suggests native Linux instead.