--- description: Apache Hive : qu'en pensent les utilisateurs ? Lisez les avis clients sur Apache Hive, consultez les prix, tarifs, abonnements et découvrez ses fonctionnalités grâce à Capterra Luxembourg. image: https://gdm-localsites-assets-gfprod.imgix.net/images/capterra/og_logo-e5a8c001ed0bd1bb922639230fcea71a.png?auto=format%2Cenhance%2Ccompress title: Apache Hive - Avis, notes, prix et abonnements - Capterra Luxembourg 2026 --- Breadcrumb: [Accueil](/) > [ETL (Extract Transform Load)](/directory/31099/etl/software) > [Apache Hive](/software/170238/apache-hive) # Apache Hive Canonical: https://www.capterra.lu/software/170238/apache-hive Page : 1/2\ Suivant: [Page suivante](https://www.capterra.lu/software/170238/apache-hive?page=2) > Solution ETL (Extract Transform Load) qui permet aux utilisateurs d'exécuter des requêtes sur de grands ensembles de données, situés dans Hadoop, de les agréger et d'obtenir une analyse de ces données. > > Conclusion : 17 utilisateurs lui ont donné la note de **4.2/5**. Figure au meilleur classement pour **Probabilité de recommander le produit**. ----- ## Statistiques et notes | Métrique | Notation | En détail | | **Note globale** | **4.2/5** | 17 Avis | | Simplicité | 4.1/5 | D'après l'ensemble des avis | | Support client | 4.2/5 | D'après l'ensemble des avis | | Rapport qualité-prix | 4.5/5 | D'après l'ensemble des avis | | Fonctionnalités | 4.0/5 | D'après l'ensemble des avis | | Pourcentage de recommandation | 70% | (7/10 Probabilité de recommander le produit) | ## À propos de l'éditeur - **Société**: Apache Software Foundation - **Fondé**: 2011 ## Contexte commercial - **Public cible**: 1.001–5.000, 5.001–10.000, 10.000+ - **Pays disponibles**: Allemagne ## Category - [ETL (Extract Transform Load)](https://www.capterra.lu/directory/31099/etl/software) ## Logiciels similaires 1. [Cloudiway](https://www.capterra.lu/software/172428/cloudiway) — 4.8/5 (125 reviews) 2. [Kdetools](https://www.capterra.lu/software/179670/kdetools) — 1.0/5 (1 reviews) 3. [Ab Initio](https://www.capterra.lu/software/1016838/ab-initio) — 5.0/5 (1 reviews) ## Avis ### "SQL approach of processing data from a distributed file system" — 4.0/5 > **Monish** | *20 avril 2020* | Logiciels | Taux de recommandation : 8.0/10 > > **Avantages**: Data on a distributed filesystem such as HDFS or S3 can be used directly for processing and modified using SQL with the help of HIVE, No need for writing complex java programs for executing map reduce, HIVE as implemented a SQL way of executing Map Reduce job's Hive has many configuration queries which increases the scope of optimisation for the under ling MR jobs, example sort mb , parallelism, number of reducers, size per reducer etc ... Hive tables data are always stores on files, even if its not a external table, these files can be directly used as a input for a MR job HIVE sql syntaxes are quit similar to that of mysql, HIVE provides good java libraries, such as sqoop which helps data table schema and data transfer from DB to HIVE etc ... > > **Inconvénients**: HIVE queries are comparatively slower than the native DB's such as mysql, snowflake or psql, meta data's and caching can be maintained to improve the performances > > I am having a Good Experience, Hive Has been a great help to the big data world, performance is the only problem which is reasonable since it has to deal with distributed file system ----- ### "Hive is the goldmine for data enthusiasts" — 5.0/5 > **Vidya** | *27 avril 2025* | Services et technologies de l'information | Taux de recommandation : 9.0/10 > > **Avantages**: Hive is a great capable data warehouse tool for data analysis and performing etl transformations at large scale > > **Inconvénients**: Hive processing is not very efficient in producing faster runs in line with other emerging tools like spark > > Overall Hive emerged as a great query engine with distributed processing and very capable for data analytics ----- ### "Review on Apache Hive" — 3.0/5 > **Mallikarjuna** | *12 septembre 2020* | Services et technologies de l'information | Taux de recommandation : 2.0/10 > > **Avantages**: As a user I would pass some good things about hive it’s interface for Hadoop and it’s interfaces to different databases along with file system and we can integrate relation between file to file too > > **Inconvénients**: It’s very flexible and good at performance while load data from larger files and it’s good interface between homo and heterogeneous databases > > I would strongly recommend to all to use and get an experience with this software ----- ### "A useful Data Warehouse for all the BigData enthusiasts" — 4.0/5 > **Utilisateur vérifié** | *14 février 2023* | Services et technologies de l'information | Taux de recommandation : 7.0/10 > > **Avantages**: It is simple to use as it really feels like a Database with its SQL like framework that easily parses queries behind the scenes into Mapreduce capable of supporting both internal and external data tables. It assins data to the machines in a cluster for faster performance with fault-tolerant capability to protect data at all cost. > > **Inconvénients**: Hive looks for data in the local machine and not HDFS, so there is no direct way to transfer files/data from local machine to HDFS (need to use external application). Execution time is not so fast as it takes a long time especially when there is a usage of joins in the queries as it relies on external disc space compared to Spark that uses in-memory space leading it to be more faster than hive. When hive is restarted, all the metadata gets erased. > > Basically you can store all the data that is structured in Hive built on top of Hadoop, that enables to store data easily and query them using SQL ----- ### "The Bigdata DatawareHouse that works seamlessly with Spark\!\!" — 5.0/5 > **Diego** | *21 juin 2021* | Marketing et publicité | Taux de recommandation : 10.0/10 > > **Avantages**: I love how easy is to integrate Apache Hive with Spark and perform SQL queries as if the tables were stored on Hadoop or S3 or GCP buckets. It is also very familiar to Spark users of tables stored on other file systems since it is based on the same storage (Hadoop HDFS) as regular Spark. And the best feature is that it is open source\!\! So, no extra cost for licensing\!\! > > **Inconvénients**: One thing is regarding its limitation of only being able to work with structured data and only being able to query tables, but for the regular use we do on our company it is more than enough (we do not have much unstructured data anyways). > > Apache Hive has solved us the need of doing repetitive transformation over the final clean tables processed by our ETL process for all our analytical and business analytics tasks, now that we have the Data Warehouse in place we no longer have to extract summary extracts or perform any repetitive queries we did in the past, now we have designed a robust star schema with the main KPIs and calculations with all the look up tables we need and all without switching from technology or framework all in the same Apache Spark project\!\! ----- Page : 1/2\ Suivant: [Page suivante](https://www.capterra.lu/software/170238/apache-hive?page=2) ## Liens - [Afficher sur Capterra](https://www.capterra.lu/software/170238/apache-hive) ## Cette page est disponible dans les langues suivantes. | Langue | URL | | de | | | de-AT | | | de-CH | | | en | | | en-AE | | | en-AU | | | en-CA | | | en-GB | | | en-IE | | | en-IL | | | en-IN | | | en-NZ | | | en-SG | | | en-ZA | | | es | | | es-AR | | | es-CL | | | es-CO | | | es-CR | | | es-DO | | | es-EC | | | es-MX | | | es-PA | | | es-PE | | | fr | | | fr-BE | | | fr-CA | | | fr-LU | | | nl | | | nl-BE | | | pt | | | pt-PT | | ----- ## Données structurées