Loading Data to the Columnar Read-Only Analysis Engine
Baixar
Modo Foco
Tamanho da Fonte
This document describes how to load data into the columnar read-only analysis engine of TDSQL Boundless, enabling efficient data analytical queries using the columnar engine.
Note:
Currently, the columnar read-only analysis engine supports loading only databases and tables.
Prerequisites
The TDSQL Boundless instance has been created and is in a running state.
The columnar read-only analysis engine has been enabled.
Use Limits
Restriction Item | Description |
Supported object types | Only supports loading databases and tables. |
DDL compatibility | Adding an auto-increment primary key column to a loaded table triggers a full resynchronization of that table. |
Limitations
During data loading, the system pulls the full dataset from the read-write instance to the columnar read-only analysis engine. Slow SQL queries may occur during the initial load, which is a normal phenomenon.
Data loading method
When creating the analysis engine, you can choose from the following three data loading methods:
Loading Method | Description |
All objects | Automatically synchronizes all user tables that meet the loading conditions from the instance to the analysis engine. Tables that do not meet the conditions are automatically skipped. |
Partial objects | Specify the tables to be loaded when creating the analysis engine. Tables that do not meet the loading conditions are ignored. |
No objects | No tables are loaded when the analysis engine is created. Users manually specify the tables to be loaded later. |
Method 1: Loading All Objects Automatically
After you choose to load all objects, all user tables in the instance that meet the loading conditions are automatically synchronized to the analysis engine. For objects that do not meet the loading conditions, the system automatically skips them, which does not affect the loading of other tables.
In the full-load mode, newly created tables that meet the loading conditions are also automatically loaded into the analysis engine.
Method 2: Manual Loading
When the data loading method is set to Partial objects or No objects, or when you need to modify the object information loaded into the read-only analysis engine, you can perform manual loading through the console.
1. Log in to the TDSQL Boundless console. In the Instance List, click the Instance ID of the read-only analysis engine to go to the read-only analysis engine details page.
2. On the read-only analysis instance details page, go to the Data Object tab and click Modify Object.
3. In the Modify Object dialog box, select or deselect the objects to be loaded into the read-only analysis engine.
Ajuda e Suporte
Esta página foi útil?
Você também pode entrar em contato com a Equipe de vendas ou Enviar um tíquete em caso de ajuda.
comentários