Tag

Function Index

1 views collected around this technical thread.

DataFunSummit
DataFunSummit
Oct 1, 2024 · Big Data

Apache Hudi from Zero to One: Highlighting Key Features of Version 1.0 (Part 10)

The article explains Apache Hudi’s three‑layer architecture and details four major 1.0 enhancements—LSM‑tree timeline, non‑blocking concurrency control, file‑group reader/writer APIs, and function indexes—while providing a brief review and links to the Hudi 1.x RFC.

Apache HudiFunction IndexLSM Tree
0 likes · 9 min read
Apache Hudi from Zero to One: Highlighting Key Features of Version 1.0 (Part 10)
DataFunTalk
DataFunTalk
Apr 25, 2024 · Big Data

Apache Hudi 1.0: Design Reconsiderations and Key New Features

This article provides a comprehensive overview of Apache Hudi 1.0, detailing its architectural redesign, five major development directions, and the most important new capabilities such as LSM‑tree timeline, function indexes, file‑group readers/writers, partial updates, and non‑blocking concurrency control, along with performance evaluations and resource links.

Apache HudiFunction IndexLSM Tree
0 likes · 14 min read
Apache Hudi 1.0: Design Reconsiderations and Key New Features
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 12, 2021 · Databases

Using CRC32/MD5 Hashes and Prefix Indexes for Efficient Long String Indexing in MySQL

The article explains how to improve indexing of long string columns in MySQL by using generated columns with CRC32/MD5 hashes, functional indexes introduced in MySQL 8.0.13, and prefix indexes, providing code examples and performance considerations.

CRC32Function IndexGenerated Column
0 likes · 4 min read
Using CRC32/MD5 Hashes and Prefix Indexes for Efficient Long String Indexing in MySQL
Aikesheng Open Source Community
Aikesheng Open Source Community
May 5, 2019 · Databases

MySQL Function Indexes: Scenarios, Implementation, and Performance Comparison

This article explains MySQL function indexes (implemented via virtual columns), demonstrates five common query scenarios—date filtering, arithmetic on two fields, substring extraction, suffix matching, and JSON value extraction—shows how to create the indexes, compares execution plans and performance with regular indexes, and highlights the strict syntax requirements for optimal use.

DatabaseFunction IndexPerformance
0 likes · 7 min read
MySQL Function Indexes: Scenarios, Implementation, and Performance Comparison