What users are saying about
81 Ratings
8 Ratings
81 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.9 out of 100
8 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 9.5 out of 100

Likelihood to Recommend

Apache Hive

Apache Hive shines for ad-hoc analysis and plugging into BI tools. Its SQL-like syntax allows for ease of use not for only for engineers but also for data analysts. Through our experience, there are probably more desirable tools to use if you are planning on integrating Hive into your processing pipeline.
Anonymous | TrustRadius Reviewer

ClicData

We used ClicData dashboards in a somewhat unorthodox way: we used "Indicators", or icons within tables to represent data, and the results looked great. The ability to integrate 3rd party HTML into dashboards was valuable (although Clic Data correctly warns that response time may suffer).The ability to start small and release dashboards incrementally suited our needs very well. We also valued the responsive account team getting us quickly pointed in the right direction.
Ben Warren | TrustRadius Reviewer

Feature Rating Comparison

BI Standard Reporting

Apache Hive
ClicData
9.4
Pixel Perfect reports
Apache Hive
ClicData
10.0
Customizable dashboards
Apache Hive
ClicData
8.8

Ad-hoc Reporting

Apache Hive
ClicData
7.5
Drill-down analysis
Apache Hive
ClicData
7.4
Formatting capabilities
Apache Hive
ClicData
7.8
Report sharing and collaboration
Apache Hive
ClicData
7.4

Report Output and Scheduling

Apache Hive
ClicData
8.5
Publish to Web
Apache Hive
ClicData
10.0
Publish to PDF
Apache Hive
ClicData
9.0
Report Versioning
Apache Hive
ClicData
7.0
Report Delivery Scheduling
Apache Hive
ClicData
8.0

Data Discovery and Visualization

Apache Hive
ClicData
7.6
Pre-built visualization formats (heatmaps, scatter plots etc.)
Apache Hive
ClicData
8.3
Location Analytics / Geographic Visualization
Apache Hive
ClicData
7.0

Access Control and Security

Apache Hive
ClicData
9.4
Multi-User Support (named login)
Apache Hive
ClicData
9.1
Multiple Access Permission Levels (Create, Read, Delete)
Apache Hive
ClicData
9.7

Mobile Capabilities

Apache Hive
ClicData
4.5
Responsive Design for Web Access
Apache Hive
ClicData
5.3
Dedicated iOS Application
Apache Hive
ClicData
1.0
Dashboard / Report / Visualization Interactivity on Mobile
Apache Hive
ClicData
7.4

Application Program Interfaces (APIs) / Embedding

Apache Hive
ClicData
10.0
iFrames
Apache Hive
ClicData
10.0
Themeable User Interface (UI)
Apache Hive
ClicData
10.0

Pros

Apache Hive

  • Hive syntax is almost like SQL, so for someone already familiar with SQL it takes almost no effort to pick up Hive.
  • To be able to run map reduce jobs using json parsing and generate dynamic partitions in parquet file format.
  • Simplifies your experience with Hadoop especially for non-technical/coding partners.
Bharadwaj (Brad) Chivukula | TrustRadius Reviewer

ClicData

  • Ease of use, I can put together a dashboard in about an hour that is used by daily.
  • Support, their support team is super helpful and always has detailed insight.
  • Connectors, they have a huge number of connectors that allow easy integration of your data sources.
Anonymous | TrustRadius Reviewer

Cons

Apache Hive

  • Use Hive for analytical work loads. Write once and read many scenarios. Do not prefer updates and deletes.
  • Behind scenes Hive creates map reduce jobs. Hive performance is slow compared to Apache Spark.
  • Map reduce writes the intermediate outputs to dial whereas Spark operates in in-memory and uses DAG.
Anonymous | TrustRadius Reviewer

ClicData

  • More widgets.
  • Sometimes it takes a while to refresh.
Anonymous | TrustRadius Reviewer

Likelihood to Renew

Apache Hive

Apache Hive 10.0
Based on 1 answer
Since I do not know the second data warehouse solution that integrate with HDFS as well as Hive.
Yinghua Hu | TrustRadius Reviewer

ClicData

No score
No answers yet
No answers on this topic

Usability

Apache Hive

Apache Hive 8.5
Based on 9 answers
Thanks to its high usability Apache Hive enables users to craft extensive queries really efficiently and at the same time to how to hold response times very low. HiveQL simplicity makes it super easy to manage large datasets, what was almost an impossible task before introduction of Apache Hive data warehousing platform in our company.
Anonymous | TrustRadius Reviewer

ClicData

ClicData 10.0
Based on 1 answer
Like I mentioned before, the ease of use means we not only get very quick results and beautiful dashboards in minutes, it means my team is actually using it because they aren't frustrated in the learning curve or wasting time trying to accomplish simple tasks.
Anonymous | TrustRadius Reviewer

Support Rating

Apache Hive

Apache Hive 7.1
Based on 8 answers
Hive also has a community platform of its own just like other Hadoop frameworks. Most of the queries/problems are resolved in the community itself. We can just post our problems or get in touch with a specific user and get the issue resolved. Otherwise there is always the product support team for any resolution.
Partha Protim Pegu | TrustRadius Reviewer

ClicData

ClicData 10.0
Based on 1 answer
We've only needed support a couple times in the beginning as we were learning the system and how to display our data in interesting ways. Every time we reached out we got very detailed responses and were connected to someone that you could tell was very interested in making sure we were happy with how things were going.
Anonymous | TrustRadius Reviewer

Alternatives Considered

Apache Hive

Besides Hive, I have used Google BigQuery, which is costly but have very high computation speed.Amazon Redshift is the another product, I used in my recent organisation.Both Redshift and BigQuery are managed solution whereas Hive needs to be managed
Manjeet Singh | TrustRadius Reviewer

ClicData

ClicData was the most flexible. It is cloud-based and even has WebService access. You can publish your data for access from other applications. The sheer number of data connectors is amazing. The ability to not only create dashboards, but you can schedule them to be delivered to specific recipients on a scheduled basis via PDF or a static HTML page.
Ben Warren | TrustRadius Reviewer

Return on Investment

Apache Hive

  • It exposes the distributed calculation world (Hadoop) to the users but doesn't require the user to have the in-depth understanding of boilerplate details, it reduces the time of learning and let the data analyst can focus their efforts on the core business.
Anonymous | TrustRadius Reviewer

ClicData

  • ClicData was by far the most reasonable cost-wise, and we were able to get ROI within just minutes of using it.
Anonymous | TrustRadius Reviewer

Screenshots

Apache Hive

Pricing Details

Apache Hive

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Apache Hive Editions & Modules

Additional Pricing Details

ClicData

General

Free Trial
Yes
Free/Freemium Version
Premium Consulting/Integration Services
Yes
Entry-level set up fee?
Optional
$71*

* data volume, type of data source and level of automation

ClicData Editions & Modules

Edition
Premium$791
Team$2591
Enterprise$4991
Dedicated$8901
  1. per month
Additional Pricing Details
All plans include multiple users licenses but dashboards can be shared with external users via live links, no license needed. Plans and pricing vary based on the data connectors, refreshes, and the level of automation needed. A few hours of Expert Service are including in all plans but more hours can be purchased. A white label option is also available for consultants and agencies.

Rating Summary

Likelihood to Recommend

Apache Hive
8.0
ClicData
9.1

Likelihood to Renew

Apache Hive
10.0
ClicData

Usability

Apache Hive
8.5
ClicData
10.0

Support Rating

Apache Hive
7.1
ClicData
10.0

Add comparison