Apache Drill vs DB2 | TrustRadius

What users are saying about

Score 9 out of 10

Based on 4 reviews and ratings

Score 8.2 out of 10

Based on 84 reviews and ratings

Pros

queries multiple data sources with ease.
supports sql, so non technical users who know sql, can run query sets
3rd party tools, like tableau, zoom data and looker were able to connect with no issues

Read full review

Data Loard

Envisagenics, Inc.Marketing and Advertising, 51-200 employees

View all 1 answers on this topic

DB2 maintains itself very well. The Task Scheduler component of DB2 allows for statistics gathering and reorganization of indexes and tables without user interaction or without specific knowledge of cron or Windows Task Scheduler / Scheduled jobs.
Its use of ASYNC, NEARSYNC, and SYNC HADR (High Availability Disaster Recovery ) models gives you a range of options for maintaining a very high uptime ratio. Failover from PRIMARY to SECONDARY becomes very easy with just a single command or windowed mouse click.
Task Scheduler ( DB2 9.7 and earlier ) allows for jobs to be run within other jobs, and exit and error codes can define what other jobs are run. This allows for ease of maintenance without third party softwares.
Tablespace usage and automatic storage help keep your data segmented while at rest, making partitioning easier.
Ability to run commands via CLI (Command Line Interface) or via Control Center / Data Studio ( DB2 10.x+) makes administration a breeze.

Read full review

J.R. Bullington

Senior Infrastructure Engineer

Open Dealer Exchange, LLCInformation Technology and Services, 51-200 employees

View all 16 answers on this topic

Cons

deployment. Not as easy
configuration isn't as straight forward, especially with the documentation
Garbage collection could be improved upon

Read full review

Data Loard

Envisagenics, Inc.Marketing and Advertising, 51-200 employees

View all 1 answers on this topic

IBM is really behind in delivering developer tools. They pride themselves on Data Studio, but it is just frustrating.
Marketing. Horrible to do a Google search and get returns for a COMPLETELY different product, for z/os. Why they share the same name is beyond me. Better marketing would also increase the user base and help the product mature.
Slower than the competition to roll out next-generation features.

Read full review

Verified User

Employee in Information Technology

Financial Services Company, 1001-5000 employees

View all 16 answers on this topic

Likelihood to Renew

Apache Drill 7.0

Based on 1 answer

if Presto comes up with more support (ie hbase, s3), then its strongly possible that we'll move from apache drill to prestoDB. However, Apache drill needs more configuration ease, especially when it comes to garbage collection tuning. If apache drill could support also sparkSQL and Flume, then it does change drill into being something more valuable than prestoDB

Read full review

Data Loard

Envisagenics, Inc.Marketing and Advertising, 51-200 employees

View all 1 answers on this topic

DB2 8.0

Based on 2 answers

Because it is required to support our business unit

Read full review

Verified User

Engineer in Information Technology

Luxury Goods & Jewelry Company, 10,001+ employees

View all 2 answers on this topic

Usability

No score

No answers yet

No answers on this topic

DB2 5.0

Based on 1 answer

You have to be well versed in using the technology, not only from a GUI interface but from a command line interface to successfully use this software to its fullest.

Read full review

J.R. Bullington

Senior Infrastructure Engineer

Open Dealer Exchange, LLCInformation Technology and Services, 51-200 employees

View all 1 answers on this topic

Reliability and Availability

No score

No answers yet

No answers on this topic

DB2 10.0

Based on 20 answers

DB2 for i is extremely stable. I've experienced system slowdowns and performance issues on badly configured systems or badly configured system accessing the DB but that's it, never had a problem caused purely by the software. Support is also pretty good.

Read full review

Roberto Etcheverry

Solution Architect

ROER International SAComputer Hardware, 11-50 employees

View all 20 answers on this topic

Performance

No score

No answers yet

No answers on this topic

DB2 9.9

Based on 20 answers

The performances are exceptional if you take care to maintain the database. It is a very powerful tool and at the same time very easy to use. In our installation, we expect a DB machine on the mainframe with access to the database through ODBC connectors directly from branch servers, with fabulous end users experience.

Read full review

Verified User

Manager in Other

Banking Company, 10,001+ employees

View all 20 answers on this topic

Alternatives Considered

compared to presto, has more support than prestodb.Impala has limitations to what drill can supportapache phoenix only supports for hbase. no support for cassandra. Apache drill was chosen, because of the multiple data stores that it supports htat the other 3 do not support. Presto does not support hbase as of yet. Impala does not support query to cassandra

Read full review

Data Loard

Envisagenics, Inc.Marketing and Advertising, 51-200 employees

View all 1 answers on this topic

DB2 is a similar product that is most respected. Oracle might be supported in a broader context, but DB2 is superior on every platform where the choice is there. Licensing is also a factor in which DB2 is much better, which might offset any cost differences. DB2 support is also much better at all tiers.

Read full review

Verified User

Manager in Information Technology

Consumer Goods Company, 10,001+ employees

View all 16 answers on this topic

Scalability

No score

No answers yet

No answers on this topic

DB2 9.6

Based on 10 answers

It can grow as your company grows. It also plays well with Crystal Reports and other BI software once you create an ODBC connection for the DB. It can be managed with SQL management studio so no extra software is needed for that.

Read full review

Josh Rice, MBA, ACSP

IT Project Manager

Fort Financial Credit UnionBanking, 51-200 employees

View all 10 answers on this topic

Return on Investment

Configuration has taken some serious time out.
Garbage collection tuning. is a constant hassle. time and effort applied to it, vs dedicating resources elsewhere.
w/ sql support, reduces the need of devs to generate the resultset for analysts, when they can run queries themselves (if they know sql).

Read full review

Data Loard

Envisagenics, Inc.Marketing and Advertising, 51-200 employees

View all 1 answers on this topic

Positive - Very good performance as compared to other traditional DBs.
Positive - Transaction and query search are made easy from a DB level with good performance, also runs on top scape on AIX servers.
Negative - There is always room for improvement, such as Webex queries and the GUI base tool. Also the available support documentation should be improved.

Read full review

Sr. SAP Basis Consultant

Gauri Ltd. | Transforming Customer Engagement For The Digital AgeInformation Technology and Services, 51-200 employees

View all 16 answers on this topic

Pricing Details

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

—

Entry-level set up fee?

No

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

—

Entry-level set up fee?

No

Add comparison