Is there a way to set horizon value with ML.FORECAST without using literal value
select value_type as movement_type , date(forecast_timestamp) as month_date, cast(forecast_value as INT64) as value_count from
ML.FORECAST(MODEL `model_name`, STRUCT( (select days_left from month_table) as horizon, .90 as confidence_level) )
I get the following error:
Query error: Invalid table-valued function ML.FORECAST Table Valued Function expects the settings struct to have literal constant
What documentation are you currently following?
Are there any updates on this?
Getting the same error when declaring a INT64 variable and using it in the settings struct of ML.EXPLAIN_FORECAST.
User | Count |
---|---|
2 | |
1 | |
1 | |
1 | |
1 |