Apache Drill vs pgcli: What are the differences?
Developers describe Apache Drill as "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. On the other hand, pgcli is detailed as "Postgres CLI with autocompletion and syntax highlighting". This is a postgres client that does auto-completion and syntax highlighting.
Apache Drill and pgcli 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, pgcli 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.
pgcli is an open source tool with 8.01K GitHub stars and 365 GitHub forks. Here's a link to pgcli's open source repository on GitHub.