Teradata中TD_SMOTE函数执行报错，请求排查语法问题

问题根源 #

你遇到的语法错误是因为Teradata要求调用**表值生成函数（Table-Valued Function）**时，必须用TABLE()语法包裹函数主体，否则解析器无法识别正确的函数调用格式，才会提示需要在td_smote和(之间添加符号。

修正后的完整代码 #

CREATE MULTISET TABLE iris_enc_sample ,FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL,
     CHECKSUM = DEFAULT,
     DEFAULT MERGEBLOCKRATIO,
     MAP = TD_MAP1
     (
      id INTEGER,
      sepal_length FLOAT,
      sepal_width FLOAT,
      petal_length FLOAT,
      petal_width FLOAT,
      species INTEGER)
PRIMARY INDEX ( id );

-- 插入数据（保持原语句不变）
INSERT INTO iris_enc_sample (id,sepal_length,sepal_width,petal_length,petal_width,species) VALUES (78,6.0,2.9,4.5,1.5,2);
INSERT INTO iris_enc_sample (id,sepal_length,sepal_width,petal_length,petal_width,species) VALUES (141,6.9,3.1,5.1,2.3,3);
INSERT INTO iris_enc_sample (id,sepal_length,sepal_width,petal_length,petal_width,species) VALUES (97,6.2,2.9,4.3,1.3,2);
INSERT INTO iris_enc_sample (id,sepal_length,sepal_width,petal_length,petal_width,species) VALUES (13,4.3,3.0,1.1,0.1,1);
INSERT INTO iris_enc_sample (id,sepal_length,sepal_width,petal_length,petal_width,species) VALUES (112,6.8,3.0,5.5,2.1,3);
INSERT INTO iris_enc_sample (id,sepal_length,sepal_width,petal_length,petal_width,species) VALUES (89,5.5,2.5,4.0,1.3,2);
INSERT INTO iris_enc_sample (id,sepal_length,sepal_width,petal_length,petal_width,species) VALUES (7,5.0,3.4,1.5,0.2,1);
INSERT INTO iris_enc_sample (id,sepal_length,sepal_width,petal_length,petal_width,species) VALUES (85,6.0,3.4,4.5,1.6,2);
INSERT INTO iris_enc_sample (id,sepal_length,sepal_width,petal_length,petal_width,species) VALUES (5,5.4,3.9,1.7,0.4,1);
INSERT INTO iris_enc_sample (id,sepal_length,sepal_width,petal_length,petal_width,species) VALUES (83,6.0,2.7,5.1,1.6,2);
INSERT INTO iris_enc_sample (id,sepal_length,sepal_width,petal_length,petal_width,species) VALUES (39,5.1,3.4,1.5,0.2,1);
INSERT INTO iris_enc_sample (id,sepal_length,sepal_width,petal_length,petal_width,species) VALUES (35,5.0,3.2,1.2,0.2,1);
INSERT INTO iris_enc_sample (id,sepal_length,sepal_width,petal_length,petal_width,species) VALUES (94,5.6,2.7,4.2,1.3,2);
INSERT INTO iris_enc_sample (id,sepal_length,sepal_width,petal_length,petal_width,species) VALUES (27,5.2,3.5,1.5,0.2,1);
INSERT INTO iris_enc_sample (id,sepal_length,sepal_width,petal_length,petal_width,species) VALUES (111,6.4,2.7,5.3,1.9,3);

-- 修正后的TD_SMOTE调用语句
SELECT * FROM TABLE(TD_SMOTE (
      ON iris_enc_sample AS InputTable PARTITION BY ANY
      USING
      NumberOfNeighbors(5)
      IDColumn('id')
      MinorityClass('3')
      ResponseColumn('species')
      InputColumns('sepal_length', 'sepal_width', 'petal_length', 'petal_width')
      OversamplingFactor(2)
      SamplingStrategy('smote')
)) AS dt;

关键修改说明 #

• 在TD_SMOTE(...)外层添加TABLE()包裹，这是Teradata调用表值函数的强制语法要求，解析器会将其识别为返回结果集的函数。
• 其他参数配置保持原语句不变，参数顺序和取值符合TD_SMOTE的官方规范。

内容的提问来源于stack exchange，提问作者Richard Grant