SHOW

Purpose

Use the SHOW statement to list the objects including modeltypes, models, and synopses.

show

showFilterCondition

MODELTYPES

Specify MODELTYPES to list the modeltypes.

MODELS

Specify MODELS to list the trained models.

HYPERPARAMETERS

Specify HYPERPARAMETERS to list the hyperparameters used in modeltypes.

SYNOPSES

Specify SYNOPSES to list the generated synopses.

SCHEMAS

Specify SCHEMAS to list the schemas in the connected data source.

TABLES

Specify TABLES to list the tables in the current schema.

+**COLUMNS**

Specify COLUMNS to list the table columns in the current schema.

PARTITIONS

Specify PARTITIONS to list the table partitions in the partioned tables in the current schema.

QUERYLOGS

Specify QUERYLOGS to list the queries that have been executed. It works only if it is set to record the query logs in the configuration.

TASKS

Specify TASKS to list the tasks of the queries that have been executed. It works only if it is set to record the task traces in the configuration.

TRAININGS

Specify TRAININGS to list the model training status.

showFilterCondition

Specifies filter conditions to retrieve only the rows which satisfy the conditions.

The following statement lists the modeltypes.

SHOW MODELTYPES;

The following statement lists the trained models.

SHOW MODELS;

The following statement lists the hyperparameters of the modeltype ctgan.

SHOW HYPERPARAMETERS WHERE modeltype_name = 'ctgan';

The following statement lists the hyperparameters of the modeltypes whose names contain gan.

SHOW HYPERPARAMETERS WHERE modeltype_name LIKE '%gan%';

The following statement lists the generated synopses.

SHOW SYNOPSES;