{{ variable.name }}
Introduction: SQL is one of the most popular languages in the field of programming. In the current environment of multi-data sources and multi-data computing engines, Apache Calcite, as an open-source data management tool, provides a broader and more flexible application scenario for SQL. This course will explore the Calcite framework together with you, understand the architecture of Calcite, and practice the parsing and optimization of SQL.
Chapter 1: Overview of Calcite: A Powerful Tool for Unified Data Management
This chapter will introduce you to Calcite, a powerful open-source data management tool. Explore its core principles and functions, and understand how Calcite serves as an SQL parser and query optimizer to unify different data sources and provide a convenient and unified interface for data processing.
1-1 SQL in Big Data
1-2 Pain Points in Using the Sql on Hadoop Engine Platform
1-3 Service Introduction for Unified Execution
1-4 Introduction to Calcite
1-5 Diagrams of Calcite Architecture and Integration Scenarios
Chapter 2: Parsing Mysteries: Parsing and Constructing SQL Query Statements
This chapter will provide an in-depth understanding of the fundamental concepts and principles of SQL parsing. Explore how Calcite parses SQL query statements, builds query trees, and converts them into executable data operation steps. Through the study of this part, you will master the core skills for handling SQL statements
2-1 Introduction to SQL Parsing
2-2 Practical Analysis of calcite
2-3 Practical calcite Custom Syntax (Part 1)
2-4 Practical calcite Custom Syntax (Part 2)
2-5 In Practice , calcite supports custom csv data sources
Chapter 3 Optimization Exploration: Techniques and Practices for Enhancing SQL Query Performance
This chapter will focus on the optimization process of SQL queries. You will learn how to optimize queries through Calcite, including rewriting queries, generating efficient execution plans, and optimizing query performance. The content of this section will help you utilize Calcite to enhance query efficiency and optimize data processing procedures.
3-1 Introduction to SQL Optimization
3-2 Common SQL Optimization Rules
3-3 Core Steps of SQL Optimization
3-4 Practical calcite for CBO optimization
3-5 Course Summary