How to create, edit, or delete internal tables using HoloWeb - Hologres

Prerequisites

Before you manage internal tables, make sure the following requirements are met:

You have logged on to a Hologres instance. For more information, see Log on to an instance.

Navigate to HoloWeb

All operations in this topic are performed on the HoloWeb developer page. To open HoloWeb, perform the following steps:

Log on to the Hologres Management Console.
In the navigation pane on the left of the top menu bar, select the desired region.
You can click Go to HoloWeb to go to the HoloWeb development page.

Navigate to an existing table

The edit, delete, preview, and DDL operations in this topic require you to locate an existing internal table. Use the following steps each time you need to navigate to a table:

In the left-side navigation pane, click Instances Connected to display all connected instance names.
Click Database under the target instance to display all created databases.
Click Schema under the target database, then click Tables to display all created internal tables.

Create an internal table

On the HoloWeb developer page, in the top menu bar, click Metadata Management.
Use one of the following methods to create an internal table:
- Method 1: Click Create Table to create an internal table directly.
- Method 2: Right-click the target schema or Table under the schema, then select Create Internal Table.
On the Create Internal Table page, configure the parameters described in the following sections, then click Submit in the upper-right corner.
After submission, refresh the corresponding schema in the left-side navigation pane to display the new internal table.

Note

Tip: Click Query Table in the upper-right corner of the table editing page to open the SQL query window and query the table using SQL statements.

Basic properties

Parameter	Description
Mode	The schema name. You can select the default public schema or a new schema name.
Table Name	The name of the new Hologres internal table.
Description	The description of the new Hologres internal table.

Fields

Parameter	Description
Field Name	The identifier for each column in the table.
Data Type	The data type of the field.
Primary Key	The unique identifier for each data entry in the table.
Nullable	Indicates whether the field can be set to null.
Array	An ordered sequence of elements.
Default Value	The default value for the field.
Description	The description of the field.
Actions	Includes Delete.

Attributes

Parameter	Description
Storage Mode	The storage layout for the table. Options include Column-oriented Storage, Row-oriented Storage, and Row-column Storage. The default is Column-oriented Storage.
Data Lifecycle	The retention period for table data, calculated from the first data write. After the time to live expires, the table data is purged within a certain period (no fixed timeframe). The default value is Permanent.
Binlog	Indicates whether binary logging (Binlog) is enabled for the table. For more information, see Subscribe to Hologres Binlog.
Lifecycle of Binary Logs	The time to live for Binlog. The default value is Permanent. For more information, see Subscribe to Hologres Binlog.
Distribution Column	The distribution_key for the table. For more information, see Distribution Key.
Event Time Column	The event_time_column for the table. For more information, see Event Time Column (Segment Key).
Clustering Key	The clustering_key for the table. For more information, see Clustering Key.
Dictionary Encoding Columns	The dictionary_encoding_columns for the table. For more information, see Dictionary Encoding.
Bitmap Column	The bitmap_columns for the table. For more information, see Bitmap Index.

Partitioning

Parameter	Description
Partitioned Tables	Select a partition field.

Edit an internal table

You can add fields to an existing internal table. Deleting existing table fields is not supported in Edit Table mode.

Navigate to an existing table.
Right-click the target internal table, then select Open Table.
In the upper-right corner of the page, click Edit Table.
At the bottom of the page, click Add Field to add table fields visually.
Click Submit to complete editing the current internal table.

Delete an internal table

Navigate to an existing table.
Right-click the target internal table, then select Delete Table.
Click OK.

Preview table data

Navigate to an existing table.
Double-click the target internal table. On the table editing page, click Data Preview.

The following image shows an example of internal table data preview.

View DDL statements

Navigate to an existing table.
Double-click the target internal table. On the table editing page, click DDL Statements.

The following image shows an example of a DDL statement preview.

Hologres:Manage internal tables