DB-Tools.com - system comparision
20th September 2021, Monday
Home > System Comparision

Please Choose another system Click here

Editorial information provided by DB-Tools
System ElasticSearch Hive
 Name ElasticSearch --
 Version Version 6.4.1 (released in September 2018) 3.1.2
 Drawbacks Elasticsearch AMI not available Can run only on Hadoop with mapreduce
 Advantages Large number of drivers present for integration A file system can be loaded to a Hive data store AS-IS and can be queried using SQL
 Languages Supported .Net Groovy Java JavaScript Perl PHP Python Ruby --
 Website www.elastic.co/­products/­elasticsearch https://hive.apache.org
 XML Support no no
 JSON Support yes yes
 Brief description Elasticsearch is a search engine based on Lucene. It provides a distributed, multitenant-capable full-text search engine with an HTTP web interface and schema-free JSON documents. The Apache Hive ™ data warehouse software facilitates reading, writing, and managing large datasets residing in distributed storage using SQL. Structure can be projected onto data already in storage. A command line tool and JDBC driver are provided to connect users to Hive
 Database Model Key Value NoSQL Model Tabular Data Model
 Technical Documentation www.elastic.co/­guide/­en/­elasticsearch/­reference/­current/­index.html --
 License Open Source. Commercial version with HA available with redislabs.com --
 Cloud-based / SaaS ElasticSearch Cloud Cluster available from ElasticSearch --
 Implementation Language C,C++ C,C++
 Operating System Supported Linux OS X Solaris Windows Linux, OS X,
 Options for Integration / Access API Proprietary protocol using JSON -
 Consistency Highly Consistent Highly Consistent
 Foreign Keys No No
 Streaming Support Yes Yes
 Analytics Support NA --
 Data Storage Schema Inverted Index --
 Notable Users -- -
 Key Differentiator No known Enterprise Competitor apart from Amazaon Cloud Search Probably most Widely used reporting database in big data ecosystem . Has a web front end
 Concurrency Yes Yes
 Partitioning Yes Yes
 Replication Yes Yes
 Secondary Indexes Yes Yes
 SchemaLess Yes --
 SQL Query No No