Data skipping and row group skipping in action with delta tables Posted on June 1, 2023, updated on June 1, 2023 by Yannick JaquierTable of contents Preamble Data skipping test case Data skipping and row chunk skipping testing References Continue reading
How to online refresh BI tables with minimum impact to end users Posted on May 10, 2023, updated on May 10, 2023 by Yannick JaquierTable of contents Preamble Preparation of the test environment The old legacy technique The alter table switch technique The view technique The synonym technique The schema transfer technique Conclusion References Continue reading
Polymorphic Table Functions (PTF) hands-on Posted on April 20, 2023, updated on April 20, 2023 by Yannick JaquierTable of contents Preamble Polymorphic Table Functions (PTF) basic example Polymorphic Table Functions (PTF) manipulating output Polymorphic Table Functions (PTF) debugging References Continue reading
Citus columnar storage hands-on Posted on March 28, 2023, updated on March 28, 2023 by Yannick JaquierTable of contents Preamble Citus installation Citus columnar storage testing preparation Citus columnar storage testing results References Continue reading
Table and scalar SQL macros hands-on Posted on March 3, 2023, updated on March 20, 2023 by Yannick JaquierTable of contents Preamble Table SQL Macros Scalar SQL Macros Conclusion References Continue reading
Galera Arbitrator as an odd node in Galera cluster Posted on February 14, 2023, updated on November 9, 2023 by Yannick JaquierTable of contents Preamble Galera Arbitrator installation Galera Cluster configuration Galera Arbitrator configuration Galera Cluster testing References Continue reading