Cluster By, Order By, Sort By: When to use each one in Hive
Publish Date: 2026-07-13 7 min read
Four little clauses in Hive cause more confusion — and more accidental slow queries — than almost anything else in HiveQL: ORDER BY, SORT BY, DISTRIBUTE BY, and CLUSTER BY. On the surface they all sound like they “sort your data.” In reality they do very different things,...
Read moreElasticsearch: Terminology and Architecture
Publish Date: 2022-09-15 12 min read
How to Store data is what differentiates search engines databases from traditional databases, plus search engines store the index as well. if that so, then what makes the difference between indexing in databases like MongoDB or MySQL and search engines databases like Solr and Elasticsearch? Well,...
Read moreEssentials Data models in InfluxDB
Publish Date: 2022-09-11 5 min read
InfluxDB is an open source and popular time series database that was written in Go language, and it's first released in 2013 by Influxdata, to provide a platform optimized for fast, scalable and highly available storage and retrieval of time series data. As time series data is different than data...
Read moreAn Introduction to Graph Data Models
Publish Date: 2022-09-12 6 min read
If we have to think about our world, society, IT, business, and social communication between peoples, use of machines and interactions with outside world. it is clear that we are in a connected world, and the internet makes all resources tie together. Our world is full of relationships, and as a...
Read moreColumnar Databases: HBase Data Overview
Publish Date: 2022-09-13 5 min read
Hadoop was initially built for batch jobs in big data, it was not created (at least initially) for reading/writing of large datasets. that because all operations using the Map Reduce I/O framework classes, do the read/write in sequences. Hadoop lacks features for updating single records in large...
Read more