Apache Drill vs Mycli: What are the differences?

What is Apache Drill? Schema-Free SQL Query Engine for Hadoop and NoSQL. Apache Drill is a distributed MPP query layer that supports SQL and alternative query languages against NoSQL and Hadoop data storage systems. It was inspired in part by Google's Dremel.

What is Mycli? A CLI for MySQL with auto-completion and syntax highlighting. Mycli is a command line interface for MySQL, MariaDB, and Percona with auto-completion and syntax highlighting.

Apache Drill and Mycli can be categorized as "Database" tools.

Some of the features offered by Apache Drill are:

• Low-latency SQL queries
• Dynamic queries on self-describing data in files (such as JSON, Parquet, text) and MapR-DB/HBase tables, without requiring metadata definitions in the Hive metastore.
• ANSI SQL

On the other hand, Mycli provides the following key features:

• Auto-completion as you type for SQL keywords as well as tables and columns in the database.
• Syntax highlighting using Pygments.
• Smart-completion (enabled by default) will suggest context-sensitive completion.

Mycli is an open source tool with 7.75K GitHub stars and 475 GitHub forks. Here's a link to Mycli's open source repository on GitHub.