question

HCLAZURECloudConnectedECOSystems-0579 avatar image
0 Votes"
HCLAZURECloudConnectedECOSystems-0579 asked YutongTie-MSFT answered

Model Predicted results vary if data is fed from sql trasnformation block

Hi,
I created a model to read training and testing data from 2 respective cosmos db tables and used an sql transformation block to rename the column names and used it for training and in score model as shown in snapshot (modela.jpg) . The Predicted parameter (scored label) is very much different and incorrect (refer onlysqltrans.jpg)
When I use a "convert to csv" block connected to output of sql transformation block (refer modelb.jpg for model diagram ) and then use it in training , I get expected results ( refer withcsvblock.jpg) .
The Mean Absolute error in first case was 51.2 while in modelb was only 0.09

I used a convert to dataset block after sql transform block and used that to connect to training model
but that too gave the same result as modela output

In case you want to see what sql transformation i used
123904-modelb.jpg123936-withcsvblock.jpg123945-modela.jpg123992-onlysqltrans.jpg


   select  "['CombiTimeTable.y[1]']" as av1 ,"['CombiTimeTable.y[2]']" as av2,"['CombiTimeTable.y[3]']" as av3,"['CombiTimeTable.y[4]']" as av4,"['CombiTimeTable.y[5]']" as av5,"['CombiTimeTable.y[6]']" as av6,"['CombiTimeTable.y[7]']" as av7,"['CombiTimeTable.y[8]']" as av8,"['CombiTimeTable.y[9]']"  as av9 from t1

Thanks


azure-machine-learning
modelb.jpg (29.2 KiB)
withcsvblock.jpg (55.7 KiB)
modela.jpg (29.5 KiB)
onlysqltrans.jpg (54.6 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi,

I am reproducing this issue and want to check if you have changed any parameters or not? Thanks.


Regards,
Yutong

0 Votes 0 ·

Hi,
iyou mean in the Linear regression block - no using default values
thanks

0 Votes 0 ·

1 Answer

YutongTie-MSFT avatar image
0 Votes"
YutongTie-MSFT answered

@HCLAZURECloudConnectedECOSystems-0579

Update for this thread, this issue has been forwarded to product team, I will let you know any news I get from them back. Thanks for the feedback again.

Regards,
Yutong

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.