Top Rated Apache Drill Alternatives
The use of basic SQL on serialized files such as parquet and very easy to play around in a distributed cluster.(cloud-based) Review collected by and hosted on G2.com.
It works on all the files, however, for serialized it works faster on .parquet extension files. Review collected by and hosted on G2.com.
13 out of 14 Total Reviews for Apache Drill
Documentation is very easy to get started, Can we Used with Many NoSQL, and Cloud providers with minimal configuration, Also it can be coupled with HIVE or Hadoop for better performance Review collected by and hosted on G2.com.
Could have been better if there were caching layers available like trino or presto. performance on stand-alone mode could have been better Review collected by and hosted on G2.com.

I can use SQL with RDBMS and non RDBMS databases without the need to learn no SQL queries. Review collected by and hosted on G2.com.
Garbage collector needs to be improved faced issues while fetching big datasets. It can only read data in certain formats. Vice and versa file conversion support without any overhead would be great to have. Review collected by and hosted on G2.com.

Apache Drill's best feature is that it is open source means free of cost, easy to install tool. You can query a large amount of data from any source by just enabling the plugins. Review collected by and hosted on G2.com.
The feature I dislike is that we can only query things using view, select statements. We cannot create databases, tables using Apache Drill. Review collected by and hosted on G2.com.
Easy to use, developer friendly, Schema Free, code reusability Review collected by and hosted on G2.com.
It cannot read XML, No hierarchical query support, Not much aggregate function Review collected by and hosted on G2.com.
Easy way to write sql over non sql dbs. Creating view, Indexes etc Review collected by and hosted on G2.com.
Faced lot of weird issue with respect to index pick up , especially while loading of data in progress . That means both write and read operations are in progress. Review collected by and hosted on G2.com.
It is a quick query tool for any platform, be it csv , parquet files in hdfs .You just need to enavle plugins. Review collected by and hosted on G2.com.
In drill we can't create any database or table. Just we can see the basic results using select statements. Review collected by and hosted on G2.com.
It is easy to query a tool using apache drill, easy installation,open source tool having an interactive GUI. Review collected by and hosted on G2.com.
In Apache Drill , we can't create any database ,just can use select query .And it hangs showing us petabytes or terabytes of data. Review collected by and hosted on G2.com.
We can query many different data stores , which are completely different.
Like RDBMS And No sql Review collected by and hosted on G2.com.
Connections are little harder but not impossible Review collected by and hosted on G2.com.