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.