All Products
Search

This Product

    Dataphin:Encoding specification

    Document Center

    Dataphin:Encoding specification

    Last Updated:Jan 21, 2025

    This topic outlines the supported configuration items for the encoding specification within the intelligent engine, along with detailed descriptions for each.

    Procedure

    1. On the Dataphin home page, single click the Management Center in the top menu bar.

    2. Navigate to the Code Specifications tab as shown in the figure below and configure the encoding specification settings accordingly.

      image..png

      Configuration item

      Description

      Prohibit The Use Of "select *" Syntax In Ad Hoc Queries On Logical Aggregate Tables

      By default, the setting is Yes. This causes the system to generate multiple materialized tables from the source table and statistical period defined in the logical aggregate table. Utilizing the select * syntax for querying the logical aggregate table will prompt the SQL to incorporate all materialized tables, leading to unnecessary resource consumption. Opting for Yes in this configuration item helps prevent such resource wastage.

      Important

      Because disabling the permission to use the select * syntax may cause production tasks that already use the select * and SELECT * syntax to fail, ensure that no production tasks use the select * and SELECT * syntax. You can enter select * and SELECT * in the global code search entry for queries. For more information, see the referenced document.

      Prohibit Full Table Scan

      The default setting is No. Full table scans are resource-intensive. Enabling this feature is recommended to enhance processing efficiency. If this check is disabled, ensure that no full table scan queries exist within the tasks.

      Prohibit The Use Of Native Flink DDL Statements

      This setting is applicable only when the system calculation settings are linked to the real-time computing engine. The default is No. If set to Yes, native Flink DDL statements are not permitted in Flink SQL computing tasks.

      Note

      Native Flink DDL statements expose passwords in plaintext, which could lead to data breaches. Exercise caution when operating.

      Prohibit Publishing Tasks Using Native Flink DDL To The Production Environment

      This setting is relevant only when the system calculation settings are tied to the real-time computing engine and native Flink DDL statements are permitted. The default is No. If set to Yes, tasks containing Native Flink DDL statements in Flink SQL computing tasks cannot be published to the production environment.

      Note

      In Basic mode projects, native Flink DDL statements are not allowed.

    3. Single click OK to finalize the encoding specification configurations.

      To revert all encoding specification configuration items to their default values, single click Restore Defaults.