Problems with "SHOW"

TigerGraph Platform
#1

Hi,
I’ve noticed that “SHOW VERTEX foo” sometimes doesn’t show the newly created schemas and sometimes doesn’t show the complex type options like integer size. Is there some way around this?

EG not showing a newly created vertex:

GSQL-Dev > BEGIN

GSQL-Dev > CREATE VERTEX fooo (

GSQL-Dev >     PRIMARY_ID aa STRING,

GSQL-Dev >     bb STRING,

GSQL-Dev >     cc INT (1)

GSQL-Dev > )

GSQL-Dev > END

The vertex type fooo is created.

GSQL-Dev > show vertex fooo

Semantic Check Fails: The vertex fooo doesn't exist!


eg not showing INT(1)

GSQL-Dev > alter vertex sz add attribute (zo INT (1))

GSQL-Dev > show vertex sz

- VERTEX system_zone(PRIMARY_ID szid STRING, sid STRING, zo INT) WITH STATS="OUTDEGREE_BY_EDGETYPE"
#2

Hi Rene,

When creating the vertex, are you currently using a graph?

If so, go back to the global scope : use global , and try to show the vertex again.

The alter statement is meant to be used within a schema change job : https://docs.tigergraph.com/dev/gsql-ref/ddl-and-loading/modifying-a-graph-schema#global-vs-local-schema-changes

Thanks,
Kevin