BigQuery ML - 语法错误:未关闭的注释.创建模型时

Question

我遇到了一个问题。我想从涉及 4 个不同表的查询创建一个模型。 但是，我看到以下错误：语法错误 - 未关闭的注释

标准 SQL 中的代码：

CREATE MODEL `project.test1`
Options
(model_type='logistic_reg', labels = ['days_between_dates']) AS
WITH all_dates AS (SELECT ID, ARRAY_AGG(STRUCT(date)))
, info AS (SELECT ID, info)
, first_date AS (SELECT ID, date)
, second_date AS(SELECT ID, date)
SELECT * , DATE_DIFF(first_date.date, second_date.date) AS days_between_dates
FROM all_dates 
JOIN first_date USING (ID)
JOIN second_date USING (ID)
LEFT JOIN info USING (ID)
WHERE days_between_dates > 1

代码按预期工作，无需添加 CREATE MODEL 语句(前三行代码(即可运行。

任何帮助将不胜感激，为我指出正确的方向。

谢谢

Answer 1

使用以下代码解决了问题：

CREATE MODEL `project.test1`
Options
(model_type='logistic_reg', labels = ['days_between_dates']) AS
SELECT * , DATE_DIFF(first_date.date, second_date.date) AS days_between_dates
FROM (SELECT ID, ARRAY_AGG(STRUCT(date)))
JOIN (SELECT ID, date) first_date USING (ID)
JOIN (SELECT ID, date) second_date USING (ID)
LEFT JOIN (SELECT ID, info) USING (ID)
WHERE days_between_dates > 1

但是"数据类型 ARRAY<结构不支持训练...">