Apache Phoenix VS Apache Hive

Apache Phoenix

We haven't tracked posts mentioning Apache Phoenix yet.
Tracking mentions began in Dec 2020.

Apache Hive

• Apache Iceberg as storage for on-premise data store (cluster)
  3 projects | /r/dataengineering | 16 Mar 2023

  Trino or Hive for SQL querying. Get Trino/Hive to talk to Nessie.

• In One Minute : Hadoop
  10 projects | dev.to | 21 Nov 2022

  Hive, A data warehouse infrastructure that provides data summarization and ad hoc querying.

• DeWitt Clause, or Can You Benchmark %DATABASE% and Get Away With It
  21 projects | dev.to | 2 Jun 2022

  Apache Drill, Druid, Flink, Hive, Kafka, Spark

• Apache Spark, Hive, and Spring Boot — Testing Guide
  6 projects | dev.to | 22 Apr 2022

  In this article, I'm showing you how to create a Spring Boot app that loads data from Apache Hive via Apache Spark to the Aerospike Database. More than that, I'm giving you a recipe for writing integration tests for such scenarios that can be run either locally or during the CI pipeline execution. The code examples are taken from this repository.

• Apache Hive in the vein!
  3 projects | dev.to | 22 Dec 2021
• Jinja2 not formatting my text correctly. Any advice?
  11 projects | /r/learnpython | 10 Dec 2021

  ListItem(name='Apache Hive', website='https://hive.apache.org/', category='Interactive Query', short_description='Apache Hive is a data warehouse software project built on top of Apache Hadoop for providing data query and analysis. Hive gives an SQL-like interface to query data stored in various databases and file systems that integrate with Hadoop.'),

• Understanding SQL Dialects
  2 projects | dev.to | 17 Nov 2021

  Apache Hive takes in a specific SQL dialect and converts it to map-reduce.

• The Data Engineer Roadmap 🗺
  11 projects | dev.to | 19 Oct 2021

  Apache Hive

• Open Source SQL Parsers
  17 projects | dev.to | 8 Oct 2021

  Apache Calcite is a popular parser/optimizer that is used in popular databases and query engines like Apache Hive, BlazingSQL and many others.

• Word-Aligned Bloom Filters
  5 projects | news.ycombinator.com | 3 Oct 2021

  > whether this would really work out in most workloads

  > just because it keeps the cache-lines hotter and less likely to be evicted.

  Okay, so keeping cache for a bloom filter problem is real - but the real force evicting memory out of the cache line is the next row-group you read + all the other stuff you have to do when you implement this in a database product.

  So the two things I work with, Apache Hive and Apache Impala switched to a blocked bloom filter at different points in time.

  Hive BloomKFilter - https://github.com/apache/hive/blob/master/storage-api/src/j...

  Impala/Kudu one - https://github.com/apache/impala/blob/master/be/src/kudu/uti...

  The C++ one also has an AVX specialization, while the Java one relies on the JVM to do it (not always) - https://github.com/apache/impala/blob/master/be/src/kudu/uti...

  We ran a lot of trivial benchmarks and several benchmarks where the shuffle-join (not sort-merge, this is just a partitioned hash join) generates a bloom filter (a semijoin) before sending rows out and the 1-cache line version won out when the bloom filter went slightly over the 1 Million + 5% rate [1].

  The regular bloom filter went from (38ns -> 108ns for 1k -> 1m items), while the BloomK stuck at (27ns) despite making room for a million times more items in the bloom. The bloom-1 (which is the 64bit version) underperformed on accuracy (was ~2x faster at 16ns per op, but worse at filtering out items).

  [1] - https://github.com/prasanthj/bloomfilter/tree/master/benchma...