Likelihood to Recommend We are running it to perform preparation which takes a few hours on EC2 to be running on a spark-based EMR cluster to total the preparation inside minutes rather than a few hours. Ease of utilization and capacity to select from either Hadoop or spark. Processing time diminishes from 5-8 hours to 25-30 minutes compared with the Ec2 occurrence and more in a few cases.
Read full review Software work execution is on a large scale, it is good to use for new projects or organizational changes, data lineage mapping has always been dubious but this one has had good results. You can store and synchronize data from different departments, the storage process can be manual but it is best automated.
Read full review Pros Amazon Elastic MapReduce works well for managing analyses that use multiple tools, such as Hadoop and Spark. If it were not for the fact that we use multiple tools, there would be less need for MapReduce. MapReduce is always on. I've never had a problem getting data analyses to run on the system. It's simple to set up data mining projects. Amazon Elastic MapReduce has no problems dealing with very large data sets. It processes them just fine. With that said, the outputs don't come instantaneously. It takes time. Read full review Apache Hive allows use to write expressive solutions to complex problems thanks to its SQL-like syntax. Relatively easy to set up and start using. Very little ramp-up to start using the actual product, documentation is very thorough, there is an active community, and the code base is constantly being improved. Read full review Cons Sometimes bootstrapping certain tools comes with debugging costs. The tools provided by some of the enterprise editions are great compared to EMR. Like some of the enterprise editions EMR does not provide on premises options. No UI client for saving the workbooks or code snippets. Everything has to go through submitting process. Not really convenient for tracking the job as well. Read full review Some queries, particularly complex joins, are still quite slow and can take hours Previous jobs and queries are not stored sometimes Switching to Impala can sometimes be time-consuming (i.e. the system hangs, or is slow to respond). Sometimes, directories and tables don't load properly which causes confusion Read full review Likelihood to Renew Since I do not know the second data warehouse solution that integrate with HDFS as well as Hive.
Read full review Usability I give Amazon EMR this rating because while it is great at simplifying running big data frameworks, providing the Amazon EMR highlights, product details, and pricing information, and analyzing vast amounts of data, it can be run slow, freeze and glitch sometimes. So overall Amazon EMR is pretty good to use other than some basic issues.
Read full review Hive is a very good big data analysis and ad-hoc query platform, which supports scaling also. The BI processes can be easily integrated with Hadoop via the Hive. It can deal with a much larger data set that traditional RDBMS can not. It is a "must-have" component of the big data domain.
Read full review Support Rating There's a vast group of trained and certified (by AWS) professionals ready to work for anyone that needs to implement, configure or fix EMR. There's also a great amount of documentation that is accessible to anyone who's trying to learn this. And there's also always the help of AWS itself. They have people ready to help you analyze your needs and then make a recommendation.
Read full review Apache Hive is a FOSS project and its open source. We need not definitely comment on anything about the support of open source and its developer community. But, it has got tremendous developer support, awesome documentation. I would justify the fact that much support can be gathered from the community backup.
Read full review Alternatives Considered Snowflake is a lot easier to get started with than the other options.
Snowflake 's data lake building capabilities are far more powerful. Although Amazon EMR isn't our first pick, we've had an excellent experience with EC2 and S3. Because of our current API interfaces, it made more sense for us to continue with Hadoop rather than explore other options.
Read full review 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 Return on Investment Positive: Helped process the jobs amazingly fast. Positive: Did not have to spend much time to learn the system, therefore, saving valuable research time. Negative: Not flexible for some scenarios, like when some plugins are required, or when the project has to be moved in-house. Read full review Apache hive is secured and scalable solution that helps in increasing the overall organization productivity. Apache hive can handle and process large amount of data in a sufficient time manner. It simplifies writing SQL queries, hence helping the organization as most companies use SQL for all query jobs. Read full review ScreenShots