microsoft / microsoft/sql-server-samples
Warning message: In tempGetNumObs(numObs)
Nobody has claimed this yet.
- Dominant language
- PowerShell
- Stars
- 11.2k
- Forks
- 9.1k
- Avg merge
- 2d 7h
- Merged PRs (30d)
- 14
Description
Hi ZhouFang928,
I've tried to follow your example "Telco Customer Churn v1", but I found some difficulties.
If I could, I have two questions to ask you.
First of all, can you confirm that I can not enable external scripts R on Azure SQL Database?
The second question concerns the execution of the code:
I ran all the steps correctly, created the functions and uploaded the data on my SQL Server 2016, but when I execute the following statement
system.time({
trainModel(sqlSettings, trainTable)
})
content on telcoChurn-main.R script I get this wrong output:
Warning message:
In tempGetNumObs(numObs) :
Number of observations not available for this data source. 'numObs' set to 1e6.
And for this warning message, the function trainModel() does not create the object rx_forest_model
Do you have any suggestions on how to solve this problem?
Thank you very much
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with telcoChurn-main.R and the trainModel(sqlSettings, trainTable) call, then trace the tempGetNumObs(numObs) warning during the system.time run. Compare the execution result with whether rx_forest_model is created; the issue is resolved when the cause of the warning and missing object is identified for the stated SQL Server 2016 setup.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- azure, r, sql
- Domain
- cloud, databases, machine-learning
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100