You need to enable JavaScript to run this app.
优惠活动
大模型
产品
解决方案
定价
更多

BigQuery ML ARIMA_PLUS模型训练成功但ML.EVALUATE全返回NULL

BigQuery ML ARIMA_PLUS Model Returns NULL Values in ML.EVALUATE Results

I'm using BigQuery ML to train an ARIMA_PLUS model for CPU usage prediction. The model trains successfully, but all result values are NULL when executing ML.EVALUATE.

Model Training Query

CREATE OR REPLACE MODEL `project.dataset.arima_model`
OPTIONS(
  MODEL_TYPE = 'ARIMA_PLUS',
  TIME_SERIES_TIMESTAMP_COL = 'timestamp_column',
  TIME_SERIES_ID_COL = ['id_column_1', 'id_column_2'],
  TIME_SERIES_DATA_COL = 'data_column',
  FORECAST_LIMIT_LOWER_BOUND = 0,
  FORECAST_LIMIT_UPPER_BOUND = 100
) AS
SELECT data_column, id_column_1, id_column_2, timestamp_column
FROM `project.dataset.source_table`
WHERE DATE(timestamp_column) BETWEEN '2025-02-5' AND '2025-02-12';

Evaluation Query

SELECT * 
FROM ML.EVALUATE(
  MODEL `project.dataset.arima_model`,
  (
    SELECT data_column, id_column_1, id_column_2, timestamp_column
    FROM `project.dataset.source_table`
    WHERE DATE(timestamp_column) BETWEEN '2025-02-13' AND '2025-02-20'
  ),
  STRUCT(
    TRUE AS perform_aggregation, 
    10 AS horizon, 
    0.9 AS confidence_level
  )
);

ML.EVALUATE executes successfully, but all results corresponding to each ID are NULL.


This question is from Stack Exchange, asked by Haidar Rasyid

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.06.14 04:24:59