GENERATE COLUMNS
FOR entity_name
[ IN STORE store_name ];
Description
This command generates a list of DDL columns from an entity — for example, — that has corresponding . The command specially simplifies creating DDL for complex descriptors.
You can generate entity columns only if the current role has USAGE privileges on the Store.
Arguments
entity_name
Name of the entity for which to generate columns.
IN STORE store_name
Optionally, you can provide a store_name to search the corresponding entity_name within.
Examples
Generate columns for an entity in the current store
demodb.public/demostore# GENERATE COLUMNS FOR pageviews_pb;
+------------------------------------------+
| Template |
+==========================================+
| viewtime BIGINT NOT NULL, userid |
| VARCHAR NOT NULL, pageid VARCHAR NOT |
| NULL |
+------------------------------------------+
Generate columns for an entity in a specific store
demodb.public/demostore# GENERATE COLUMNS FOR employee IN STORE company;
+-------------------------------------------+
| Template |
+===========================================+
| id BIGINT NOT NULL, pager_id BIGINT NOT |
| NULL, laptop_id BIGINT NOT NULL, badge_id |
| BIGINT NOT NULL, insurance_id BIGINT NOT |
| NULL, office_number INTEGER NOT NULL, |
| salary INTEGER NOT NULL, age INTEGER NOT |
| NULL, device_number INTEGER NOT NULL, |
| desk_number INTEGER NOT NULL, full_time |
| BOOLEAN NOT NULL, bonus_rate DOUBLE NOT |
| NULL, increase_rate FLOAT NOT NULL, name |
| VARCHAR NOT NULL, department BYTES NOT |
| NULL, projects ARRAY<VARCHAR>, contacts |
| MAP<VARCHAR, BIGINT>, home_address |
| STRUCT<unit INTEGER, street VARCHAR, |
| city VARCHAR, state VARCHAR>, managers |
| ARRAY<STRUCT<name VARCHAR, title VARCHAR, |
| team STRUCT<id BIGINT, leaders |
| ARRAY<VARCHAR>, artifacts ARRAY<STRUCT<id |
| BIGINT, name VARCHAR>>>>>, leaders |
| MAP<VARCHAR, STRUCT<name VARCHAR, title |
| VARCHAR, team STRUCT<id BIGINT, leaders |
| ARRAY<VARCHAR>, artifacts ARRAY<STRUCT<id |
| BIGINT, name VARCHAR>>>>> |
+-------------------------------------------+
