DB-Tools.com - system comparision
4th December 2020, Friday
 
Home > System Comparision

Please Choose another system Click here

Editorial information provided by DB-Tools
Comparison Hadoop Hortonworks Amazon EMR
 Name Hortonworks AWS EMR
 Version HDP v3.0 Version 4.2.8
 Drawbacks -- NA
 Advantages -- Manage Hadoop Cluster as plug and play
 Languages Supported Java Python Java Python Scala
 Website www.hortonworks.com aws.amazon.com/rds/aurora/
 XML Support no no
 JSON Support yes yes
 Brief description Hortonworks has three interoperable product lines: HDP (based on Apache Hadoop Apache Hive Apache Spark) HDF (based on Apache NiFi Apache Storm, Apache Kafka), and Data Plane Services (based on Apache Atlas and Cloudbreak You can launch an Amazon EMR cluster in minutes. There is no need to worry about node provisioning cluster setup Hadoop configuration or cluster tuning. Amazon EMR takes care of these tasks so you can focus on analysis.
 Database Model Hadoop File System (HDFS) Relational Database
 Technical Documentation https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.5/index.html https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Overview.html
 License Commercial Commercial
 Cloud-based / SaaS Not Available SaaS Service from AWS
 Implementation Language NA NA
 Operating System Supported Linux Not Applicable as its managed by AWS
 Options for Integration / Access API Restful HTTP Restful HTTP
 Consistency NA NA
 Foreign Keys Not but you can join two files using Hive and Impala NA
 Streaming Support Yes Yes
 Analytics Support Using Mlib in Apache Spark NA
 Data Storage Schema Hadoop File System (HDFS) NA
 Notable Users hotels.com hilton.com NA
 Key Differentiator More suited for platforms based on windows. Azure has a big partnership with hortonworks. With EMR we can spin up a hadoop cluster in minutes
 Concurrency Yes Yes
 Partitioning Yes No
 Replication Yes Yes
 Secondary Indexes Yes in HBase. Datawarehouse using cloudera is generally built using Hbase. Hbase has secondary indexes Yes based on secondary indexes using Solr
 SchemaLess Yes Yes
 SQL Query No. HiveQL similar to SQL can be used withHive NA