--- description: Tudo sobre Apache Hive: preço, alternativas, vantagens e desvantagens, funcionalidades e avaliações de outros usuários. Saiba mais! image: https://gdm-localsites-assets-gfprod.imgix.net/images/capterra/og_logo-e5a8c001ed0bd1bb922639230fcea71a.png?auto=format%2Cenhance%2Ccompress title: Apache Hive - Preço, avaliações e classificação - Capterra Brasil 2026 --- Breadcrumb: [Home](/) > [Ferramentas ETL](/directory/31099/etl/software) > [Apache Hive](/software/170238/apache-hive) # Apache Hive Canonical: https://www.capterra.com.br/software/170238/apache-hive Página: 1 / 2\ Próximo: [Próxima página](https://www.capterra.com.br/software/170238/apache-hive?page=2) > Solução de ETL que permite aos usuários executar consultas a grandes conjuntos de dados, localizados no Hadoop, agregá-los e fornecer análise de dados. > > Conclusão: 17 usuários atribuíram a nota **4.2/5**. Melhor classificado para **Probabilidade de recomendação**. ----- ## Estatísticas e notas | Métrica | Classificação | Detalhes | | **Geral** | **4.2/5** | 17 Avaliações | | Praticidade | 4.1/5 | Com base em avaliações gerais | | Suporte ao cliente | 4.2/5 | Com base em avaliações gerais | | Relação qualidade/preço | 4.5/5 | Com base em avaliações gerais | | Recursos | 4.0/5 | Com base em avaliações gerais | | Porcentagem de recomendação | 70% | (7/10 Probabilidade de recomendação) | ## Sobre o fornecedor - **Empresa**: Apache Software Foundation - **Fundada**: 2011 ## Contexto comercial - **Público-alvo**: 1.001–5.000, 5.001–10.000, 10.000+ - **Países disponíveis**: Alemanha ## Category - [Ferramentas ETL](https://www.capterra.com.br/directory/31099/etl/software) ## Alternativas 1. [Kdetools](https://www.capterra.com.br/software/179670/kdetools) — 1.0/5 (1 reviews) ## Avaliações ### "SQL approach of processing data from a distributed file system" — 4.0/5 > **Monish** | *20 de abril de 2020* | Software | Taxa de recomendação: 8.0/10 > > **Vantagens**: 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 ... > > **Desvantagens**: 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 de abril de 2025* | Serviços e tecnologia da informação | Taxa de recomendação: 9.0/10 > > **Vantagens**: Hive is a great capable data warehouse tool for data analysis and performing etl transformations at large scale > > **Desvantagens**: 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 de setembro de 2020* | Serviços e tecnologia da informação | Taxa de recomendação: 2.0/10 > > **Vantagens**: 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 > > **Desvantagens**: 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 > **Avaliador Verificado** | *14 de fevereiro de 2023* | Serviços e tecnologia da informação | Taxa de recomendação: 7.0/10 > > **Vantagens**: 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. > > **Desvantagens**: 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 de junho de 2021* | Publicidade e marketing | Taxa de recomendação: 10.0/10 > > **Vantagens**: 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\!\! > > **Desvantagens**: 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\!\! ----- Página: 1 / 2\ Próximo: [Próxima página](https://www.capterra.com.br/software/170238/apache-hive?page=2) ## Links - [Ver em Capterra](https://www.capterra.com.br/software/170238/apache-hive) ## Esta página está disponível nos seguintes idiomas | Localidade | 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 | | ----- ## Dados estruturados