Dataphin:Configure logical aggregate table properties

Procedure

1. Navigate to the Dataphin home page and select the top menu bar Development. You will be taken to the Data Development page by default.

2. Use the following instructions to access the logical aggregate table Property configuration page.

   

3. In the Table Properties section, set the properties for the logical aggregate table.

   • Non-edit mode

     The following actions are available in non-edit mode:

     • To edit the properties of a logical aggregate table, simply single click on Edit to enter edit mode.

     • Unpublish: To unpublish the current logical aggregate table, refer to the steps outlined in the figure below.

       

   • Edit mode

     Edit mode supports the configuration of the following parameters:

     Parameter	Description
     Basic information
     Statistic granularity	Displays the statistic granularity of the table, which is not editable.
     English name	Shows the English name of the table, which is not editable.
     Chinese name	Set the Chinese name of the table, allowing Chinese characters, letters, numbers, underscores (_), and hyphens (-) up to 64 characters.
     Table owner	Displays the owner of the table as seen on the product page after a change owner operation. For more information, see change owner and .
     Development owner	Change the development owner of the table, selecting from users within the current project.
     Table description	Provide a brief description of the table, up to 1000 characters.
     Primary key information
     Primary key information	Shows the statistic object/role, field description, and field name of the primary key, which can be edited unless the table is submitted or published. Note The field name of a submitted or published aggregate table cannot be modified.
     Custom parameters
     Custom parameters	Custom parameters influence code generation rules, resource allocation, and runtime mechanisms for the table task, such as memory allocation and precedence. Examples include: Important Parameter settings must align with the compute engine attributes associated with the current Dataphin system. To set custom parameters for logical aggregate table properties, first activate the global switch for custom parameters in Management Center > Intelligent Engine > Custom Parameters. For more information, see configure custom node-specific parameters or . set oneservice.optimize.skewjoin = true/false; set hive.exec.dynamic.partition.mode=nonstrict; (enable/disable dynamic partition) set hive.vectorized.execution.enabled = false; (enable/disable vector query) set hive.vectorized.execution.reduce.enabled = false;

4. To finalize the configuration, single click Save.