Basic information |
Connection name |
The name of the required connection. |
Database |
The name of the Hologres database. |
Table name |
The name of the Hologres internal table. |
Description |
The description of the Hologres internal table. |
Mode |
The name of the schema.
Default value: public. You can also select a custom schema.
|
Field |
Field name |
The name of the field in the internal table. |
Date type |
The data type of the field. |
Primary key |
Specifies whether to use the field as the primary key for the internal table. |
Nullable |
Specifies whether the field can be left empty. |
Array |
Specifies whether the field is an ordered array of elements. |
Description |
The description of the field. |
Operation |
You can click Delete to delete the field and click Move up or Move down to move the field up or down.
|
Attribute |
Storage mode |
Valid values: Column storage and Row deposit.
Default value: Column storage.
|
Life Cycle (seconds) |
If a record is not updated within the specified period, the system deletes the record.
By default, the system retains records permanently.
|
Clustered index |
The index that is used to sort columns.
The type of index determines the order of fields. By using clustered indexes, Hologres
can accelerate range and filter queries on index fields.
|
Segment Key |
The fields that is used for segmenting. If the specified fields are involved in the
query conditions, Hologres can find the storage location of data based on the fields.
|
Dictionary encoding column |
The fields based on whose values a dictionary mapping is built.
Dictionary encoding can convert string comparisons to numeric comparisons to accelerate
queries such as GROUP BY and FILTER.
By default, the system selects all the fields of the text type for this parameter.
|
Bitmap columns |
Hologres allows you to build bit codes on bit fields.
You can filter the data that meets the query conditions based on the specified fields
by using Hologres.
By default, the system selects all the fields of the text type for this parameter.
|
Partition Table |
N/A |
The partition fields of the internal table. |