I´m trying to create a mining structure with the next dmx code:
CREATE MINING MODEL [Cassandra]
[CompanyNK] TEXT KEY,
[Date] Date KEY TIME,
[Total Value Mes] Double Continuous Predict,
[New Items Month] Long Continuous,
[Number Branches] Long Continuous,
[Number Clients] Long Continuous,
[Number Salesman] Long Continuous
USING Microsoft_Time_Series(AUTO_DETECT_PERIODICITY = 0.8, FORECAST_METHOD = 'MIXED')
And i get the following error: Error (Data mining): Usage of all non-key columns in the 'Cassandra' mining model must be set to PredictOnly.
This works because i already used this structure in SSDT, and it worked without having anything as predict only.
Can someone help?
Thanks in advance