SHOW CREATE PROJECTION
On this page
Note
This is a Preview feature.
Shows the CREATE PROJECTION statement that was used to create the projection.
Syntax
SHOW CREATE PROJECTION <projection_name> FOR TABLE [database_name.]<table_name>;
Arguments
projection_
The name of the projection created in the CREATE PROJECTION command.
database_
The database where the projection's base table is located.
table_
The name of the table the projection is created on.
Remarks
-
If
SELECT *is used in the project list of yourCREATE PROJECTIONstatement, the project list expands atCREATE PROJECTIONtime andSHOW CREATE PROJECTIONlists out all the columns.Therefore, this expanded list does not change if the base table is altered to add new columns.
Example
The following example displays the output of SHOW CREATE PROJECTION.
CREATE PROJECTION IF NOT EXISTS lineitem_sort_shipdate(SHARD KEY(l_orderkey), SORT KEY(l_shipdate))AS SELECT l_shipdate, l_orderkey FROM lineitem;
SHOW CREATE PROJECTION lineitem_sort_shipdate FOR TABLE lineitem;
+------------------------+---------------------------------------------+
| Projection | Create Projection |
+------------------------+---------------------------------------------+
| lineitem_sort_shipdate | CREATE PROJECTION `lineitem_sort_shipdate`( |
| | SHARD KEY `__SHARDKEY` (`l_orderkey`), |
| | SORT KEY `l_shipdate` (`l_shipdate`) |
| | ) AS SELECT `l_shipdate`, `l_orderkey` |
| | FROM `lineitem` |
+------------------------+---------------------------------------------+Database names can be referenced in the SHOW CREATE PROJECTION command.
SHOW CREATE PROJECTION lineitem_sort_shipdate FOR TABLE testdb1.lineitem;
Last modified: April 2, 2024