[FEATURE]: Unable to Convert Teradata MULTISET DDL Statements

[sriram251-code]

Is there an existing issue for this?

• I have searched the existing issues

Category of feature request

Transpile

Problem statement

There is an issue with converting Teradata DDL statements, specifically with the following example:

CREATE MULTISET TABLE TBL_NAME ,FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL,
     CHECKSUM = DEFAULT,
     DEFAULT MERGEBLOCKRATIO,
     MAP = TD_MAP1
     (
     COL1 DATE FORMAT 'YYYY-MM-DD' NOT NULL,
     COL2 INTEGER NOT NULL,
     COL3 CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL COMPRESS ('C','F','M'),
)
PRIMARY INDEX (COL1, COL2)
PARTITION BY RANGE_N(CAST((COL4) AS DATE FORMAT 'YYYY-MM-DD') BETWEEN CAST(('2018-01-01') AS DATE FORMAT 'YYYY-MM-DD') AND CAST(('2031-12-31') AS DATE FORMAT 'YYYY-MM-DD') EACH INTERVAL '1' DAY);

Proposed Solution

Need to generate equivalent DBSQL.

Additional Context

No response