V3.0 Removal of Previously Deprecated Features

TigerGraph 2.x contained some features which were labeled as deprecated. These features are no longer necessary because they have been superseded already by improved approaches for using the TigerGraph platform. The new approaches were developed because they use more consistent grammar, are more extensible, or offer higher performance. Therefore, TigerGraph 3.0 has streamlined the product by removing support for some of these deprecated features, listed below:

Data Types

See Data Types in GSQL Language Reference

Deprecated Type	Alternate Approach
REAL	Use FLOAT or DOUBLE
INT_SET	Use SET<INT>
INT_LIST	Use LIST<INT>
STRING_SET_COMPRESS	Use SET<STRING COMPRESS>
STRING_LIST_CONPRESS	Use LIST<STRING COMPRESS>
UINT_SET	Use SET<INT>
UINT32_UINT32_KV_LIST	Use MAP<UINT, UINT>
INT32_INT32_KV_LIST	Use MAP<INT, INT>
UINT32_UDT_KV_LIST	Use MAP<UINT, UDT_type>, where UDT_type is a user-defined tuple type
INT32_UDT_KV_LIST	Use MAP<INT, UDT_type>, where UDT_type is a user-defined tuple type

Syntax for Control Flow Statements

See Control Flow Statements in GSQL Language Reference

Deprecated Statement	Alternate Statement
FOREACH ... DO ... DONE	FOREACH... DO... END
FOREACH (condition) { body }	FOREACH condition DO body END
IF (condition) { body1 } else { body2 }	IF condition THEN body1 ELSE body2 END
WHILE (condition) { body }	WHILE condition DO body END

Vertex Set Variable Declaration

See Vertex Set Variable Declaration and Assignment

If a vertex type is specified, the vertex type must be within parentheses.

Deprecated Statement	Alternate Statement
MySet Person = ...	MySet (Person) = ...

Query, Job, and Token Management

These are documented in several places throughout the GSQL Language Reference:

• CREATE QUERY Statement

• Creating a Loading Job and Running a Loading Job

• RUN SCHEMA_CHANGE JOB, and RUN GLOBAL SCHEMA_CHANGE JOB

• CREATE / SHOW / DROP / REFRESH Token

• offline2online in 'Creating a Loading Job'

Deprecated Operation	Alternate Operation
CREATE JOB [loading job definition]	CREATE LOADING JOB [loading job definition]
RUN JOB [for loading and schema change jobs]	Specify the job type: RUN LOADING JOB RUN SCHEMA_CHANGE JOB RUN GLOBAL SCHEMA_CHANGE JOB
CREATE / SHOW/ REFRESH TOKEN	To create a token, use the REST endpoint GET /requesttoken
offline2online	The offline loading job mode was discontinued in v2.0. Do not write loading jobs using this syntax.

Output

See PRINT Statement in 'Output Statements and File Objects'

Deprecated Syntax	Alternate Syntax
JSON API v1	v2 has been the default JSON format since TigerGraph 1.1. No alternate JSON version will be available.
PRINT ... TO_CSV [filepath]	Define a file object, then PRINT ... TO_CSV [file_object]

Built-in Queries

See Run Built-in Queries in 'GSQL 101'

Deprecated Statement	Alternate Statement
SELECT count() FROM ... // count may be out of date	SELECT approx_count(*) FROM ... // same behavior as count(); may not include all the latest data updates SELECT count(*) FROM ... // exact, but slower than approx_count(*)