I'm trying to get a batch prediction from a time series forecasting model trained with AutoML. I'm seeing the following error in the BigQuery "errors_validation" table:
"There are rows with non-empty target values after this row. The time series has been excluded from predictions."
(There are 7 such error messages, one for each time series. Each error message indicates "01/01/2023" as the timestamp.†)
I just can't see how what the error message is saying could possibly be true.
- The granularity is weekly, and the forecast horizon is 26 weeks.
- For the batch prediction, I'm using a CSV file which consists of all the data used in training, plus an additional 26 weeks of future timestamps appended to it. (To be precise, each of the 26 future timestamps appears 7 times - once for each time series.)
- For each row with a future timestamp, the target column is empty (i.e., in the CSV there is nothing in the column whatsoever).
- I also tried a batch prediction sourced from a BigQuery table. I created the table from the CSV file described above. I examined the table and confirmed that there are null values in the target column wherever there is a future timestamp. I got the same errors.
I'm at a loss. Any help would be greatly appreciated.
† I'm not sure if this is significant in any way, but the forecast horizon actually starts on 12/04/2022 (earlier than the timestamp indicated by the errors). In any case, there is no data in the forecast horizon with a non-empty/non-null target value.
Solved! Go to Solution.
I was able to get batch predictions after making the following changes to the data and training a new model: