Apache Hive vs ClicData

Likelihood to Recommend

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.

Read full review

Verified User

Engineer in Engineering

Computer Software Company, 51-200 employees

View all 25 answers on this topic

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.

Read full review

Ben Warren

Operations Manager Service USA

Atlas Copco USAMachinery, 10,001+ employees

View all 3 answers on this topic

Feature Rating Comparison

Apache Hive

ClicData

Pixel Perfect reports

Customizable dashboards

Apache Hive

ClicData

Drill-down analysis

Formatting capabilities

Report sharing and collaboration

Apache Hive

ClicData

Publish to Web

Publish to PDF

Report Versioning

Report Delivery Scheduling

Apache Hive

ClicData

Pre-built visualization formats (heatmaps, scatter plots etc.)

Location Analytics / Geographic Visualization

Apache Hive

ClicData

Multi-User Support (named login)

Multiple Access Permission Levels (Create, Read, Delete)

Apache Hive

ClicData

Responsive Design for Web Access

Dedicated iOS Application

Dashboard / Report / Visualization Interactivity on Mobile

Apache Hive

ClicData

iFrames

Themeable User Interface (UI)

Pros

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.

Read full review

Bharadwaj (Brad) Chivukula

Sr.Technical Manager/Delivery Manager

Nisum Technologies, Inc.Retail, 10,001+ employees

View all 25 answers on this topic

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.

Read full review

Verified User

Executive in Product Management

Information Technology & Services Company, 11-50 employees

View all 3 answers on this topic

Cons

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.

Read full review

Verified User

Analyst in Engineering

Hospital & Health Care Company, 501-1000 employees

View all 25 answers on this topic

More widgets.
Sometimes it takes a while to refresh.

Read full review

Verified User

C-Level Executive in Finance and Accounting

Education Management Company, 1001-5000 employees

View all 3 answers on this topic

Likelihood to Renew

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.

Read full review

Yinghua Hu

Senior Data Scientist

CARD.comFinancial Services, 11-50 employees

View all 1 answers on this topic

No score

No answers yet

No answers on this topic

Usability

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.

Read full review

Verified User

Team Lead in Information Technology

Internet Company, 10,001+ employees

View all 9 answers on this topic

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.

Read full review

Verified User

Executive in Product Management

Information Technology & Services Company, 11-50 employees

View all 1 answers on this topic

Support Rating

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.

Read full review

Partha Protim Pegu

Domain Consultant

InfosysInformation Technology & Services, 10,001+ employees

View all 8 answers on this topic

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.

Read full review

Verified User

Executive in Product Management

Information Technology & Services Company, 11-50 employees

View all 1 answers on this topic

Alternatives Considered

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

Read full review

Manjeet Singh

Senior Manager - Engineering

Hike MessengerInternet, 51-200 employees

View all 25 answers on this topic

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.

Read full review

Ben Warren

Operations Manager Service USA

Atlas Copco USAMachinery, 10,001+ employees

View all 3 answers on this topic

Return on Investment

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.

Read full review

Verified User

Strategist in Information Technology

Package/Freight Delivery Company, 10,001+ employees

View all 25 answers on this topic

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

Read full review

Verified User

Executive in Product Management

Information Technology & Services Company, 11-50 employees

View all 3 answers on this topic

Pricing Details

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

—

Entry-level set up fee?

No

Apache Hive Editions & Modules

—

Additional Pricing Details

—

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	$79¹
Team	$259¹
Enterprise	$499¹
Dedicated	$890¹

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

Apache Hive

ClicData

Apache Hive

ClicData

Apache Hive

ClicData

Apache Hive

ClicData

Likelihood to Recommend

Apache Hive

ClicData

Feature Rating Comparison

Pixel Perfect reports

Customizable dashboards

Drill-down analysis

Formatting capabilities

Report sharing and collaboration

Publish to Web

Publish to PDF

Report Versioning

Report Delivery Scheduling

Pre-built visualization formats (heatmaps, scatter plots etc.)

Location Analytics / Geographic Visualization

Multi-User Support (named login)

Multiple Access Permission Levels (Create, Read, Delete)

Responsive Design for Web Access

Dedicated iOS Application

Dashboard / Report / Visualization Interactivity on Mobile

iFrames

Themeable User Interface (UI)

Pros

Apache Hive

ClicData

Cons

Apache Hive

ClicData

Likelihood to Renew

Apache Hive

ClicData

Usability

Apache Hive

ClicData

Support Rating

Apache Hive

ClicData

Alternatives Considered

Apache Hive

ClicData

Return on Investment

Apache Hive

ClicData

Screenshots

Apache Hive

ClicData

Pricing Details

General

Free Trial

Free/Freemium Version

Premium Consulting/Integration Services

Entry-level set up fee?

Apache Hive Editions & Modules

Additional Pricing Details

General

Free Trial

Free/Freemium Version

Premium Consulting/Integration Services

Entry-level set up fee?

ClicData Editions & Modules

Edition

Additional Pricing Details

Rating Summary

Add comparison