search

solliancenet / azure-synapse-analytics-day

190 stars 238 forks source link

Getting Error - Synapse Predict #11

Open msmahasm opened 4 years ago

msmahasm commented 4 years ago

Hi Team,

Getting below error while running predict query on Azure Synapse,

Failed to execute query. Error: Parse error at line: 6, column: 14: Incorrect syntax near 'MODEL'. Total execution time: 00:00:01.050 https://www.screencast.com/t/sB5nZAtDWav

Kindly help.

daronyondem commented 4 years ago

I'm moving the screenshot to Github. The link you shared didn't work in Github.

image

@ZoinerTejada Do you want me to repro this, or is this something we might know the root cause based on changes in the platform?

daronyondem commented 4 years ago

@msmahasm Let me know if this fixes the issue https://github.com/solliancenet/azure-synapse-analytics-day/commit/7d8783eb7bf8db26eba9f43de3ccb091f5916b7c

eerik47 commented 4 years ago

Hi, I am not able to run PREDICT function with your model.

When I scale Synapse to DWU100, it finishes with error: Failed to execute query. Error: Error occurred during execution of the builtin function 'PREDICT' with HRESULT 0x80070057. Model is corrupt or invalid.

When I scale Synapse to DWU500, it finishes with error: Failed to execute query. Error: Message(s) from 'PREDICT' engine: Input column 1 (1-based) has shape [1,2] which is not supported.

I used your pre-trained model in HEX format, and I tried to train new model too, but result is same.

Can you please advise, how to manage this error?