У меня возникла проблема при обработке структуры майнинга...
Это моя структура майнинга
CREATE MINING
STRUCTURE [QUESTION1] (
[ownerReviewID] LONG KEY,
[makeName] TEXT DISCRETE,
[modelName] TEXT DISCRETE,
[price] LONG CONTINUOUS,
[priceDisc] LONG DISCRETIZED(AUTOMATIC),
[seriesYear] LONG CONTINUOUS,
[seriesYearDisc] LONG DISCRETIZED(AUTOMATIC),
[ownerName] TEXT DISCRETE,
[ownedSinceNew] BOOLEAN DISCRETE,
[ownedPeriod] LONG DISCRETE,
[feature_ratings] TABLE (
[transID] LONG KEY,
[ownerReviewID]
LONG DISCRETE,
[feature] TEXT DISCRETE,
[rating] LONG CONTINUOUS,
[ratingDisc] LONG DISCRETIZED(AUTOMATIC)
)
) WITH HOLDOUT
(30 PERCENT OR 10000 CASES);
Я создал модель майнинга с наивным байесовским алгоритмом:
ALTER MINING STRUCTURE [QUESTION1]
ADD MINING MODEL [PredictReBuy-NBayes]
(
[ownerReviewID],
[makeName],
[modelName],
[priceDisc] AS [price],
[seriesYearDisc] AS
[seriesYear],
[ownerName],
[ownedSinceNew],
feature_ratings(
transID,
feature,
[ratingDisc] AS
[rating] PREDICT )
)
USING Microsoft_Naive_Bayes
Пока что 2 кода выше работают нормально, все выполняются.
Ошибка, показанная внизу, появляется, когда я пытаюсь выполнить код обработки. Это мой код обработки:
INSERT INTO MINING STRUCTURE [QUESTION1]
(
[ownerReviewID],[makeName],[modelName],[price],[seriesYear],[ownerName],[ownedSinceNew],[ownedPeriod], feature_ratings(SKIP, [transID])
)
SHAPE {
OPENQUERY([Car Rating],'SELECT ownerReviewID, makeName, modelName, price, seriesYear, ownerName, ownedSinceNew, ownedPeriod FROM dbo.owner_reviews ORDER BY ownerReviewID')}
APPEND
(
{OPENQUERY([Car Rating],'SELECT transID, ownerReviewID, feature, rating FROM
dbo.feature_ratings ORDER BY transID')
}
RELATE ownerReviewID to ownerReviewID
) AS [feature_ratings]
В настоящее время я получаю эту ошибку, которую я не понимаю, как решить... есть идеи? Спасибо!!
Executing the query ...Error (Data mining): The count of the specified columns does not match the count of
the mining model columns or the input rowset columns.Execution complete