为什么这是一个错误? [英] why is this a mistake?

问题描述

我正在做数据挖掘工作，但是有许多我不知道如何解决它们的错误.
首先，我创建了一个挖掘模型:决策树:

I am doing a data mining job, but there are many mistakes I don''t know how to solve them.
Firstly, I created a mining model: decision tree:

create mining model [DecisionTree_MemberLevelPredict]
(
	stu_ID text key,
	stu_gender text discrete,
	stu_birthyear text discrete,
	stu_education text discrete,
	stu_levels text discrete predict
)
using microsoft_decision_trees (complexity_penalty=0.5)

然后我尝试训练模型:

and then I try to train the model:

Insert into [DecisionTree_MemberLevelPredict]
(stu_ID,stu_gender,stu_birthyear,stu_education)
OPENQUERY([Bookstore],
   'SELECT ID,gender,birthyear,education,levels
    FROM dbo.customer')

最后，我想使用该模型来预测表客户中的新用户，
我遇到以下错误:
预测DMX代码

and at last I want to use the model to predict the new people in table customer,
and I face the mistakes below:
The predict DMX code

select T1.ID, DecisionTree_MemberLevelPredict.stu_levels, PredictProbability(DecisionTree_MemberLevelPredict) as Proba
from DecisionTree_MemberLevelPredict
prediction join 
OPENQUERY([Bookstore],
   'SELECT ID,gender,birthyear,education,levels
    FROM dbo.customer')as T1
on DecisionTree_MemberLevelPredict.stu_ID=T1.ID and DecisionTree_MemberLevelPredict.stu_gender=T1.gender and DecisionTree_MemberLevelPredict.stu_birthyear=T1.birthyear and DecisionTree_MemberLevelPredict.stu_education=T1.education

它说"T1.ID语法"不正确，但是ID是表客户和T1中的一列，这是怎么回事?我做错了什么?

非常感谢！

顺便说一句，创建挖掘模型后，它会自动生成一个挖掘结构，但我在我的bi dev中找不到该挖掘结构.

it says "T1.ID grammar" is not right, but ID is one column in my table customer and T1, how is that happen? What I did wrong?

Thank you very much !

BTW, after I have created the mining model, it automatically generate one mining structure, but I could not find the mining structure in my bi dev.

推荐答案

用于查询的逻辑:

logic for query :

SELECT T1.ID,T1.gender,T1.birthyear,T1.education,T1.levels
    FROM dbo.customer T1

不能用作表名:

例如:

not use as on table name:

exmp:

select T1.id as idname FROM dbo.customer T1

这篇关于为什么这是一个错误?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！