IBM Analytics Ideas

Welcome to the idea forum for IBM Analytics Clients! 

 

IBM Employees:

The correct URL for entering your ideas is https://hybridcloudunit-internal.ideas.aha.io

 

Clients:

Our team welcomes any feedback  and suggestions you have for improving our offerings / products!  This forum allows us to connect your offering / product improvement ideas with IBM product and engineering teams.

 

If you have not registered on this portal please click on the following link and register.  To complete registration you will need to open the email you will receive from Aha to confirm your identity.  https://ibm.biz/AnalyticsIdeasPortalRegister

 

change the specification of SPSS Modeler 18.1 around the SQL statement syntax check while accessing to Azure SQL Data Warehouse.

  • Requirement

We’d like you to change the specification of SPSS Modeler 18.1 around the SQL statement syntax check while accessing to Azure SQL Data Warehouse. Currently  Modeler uses the stored procedure called “sp_prepare “ which has big overhead because of generating an execution plan on SQL Data Warehouse. So it is necessary to change to “SET PARSEONLY ON” + SQL statement that is only for syntax check.

 

  • Background

Tens of our staffs deeply use SPSS Modeler and most of SQL statements which it generates are commonly very large. When we did performance test using Modeler with Azure SQL Data Warehouse, we found “sp_prepare” was called several times before executing a SQL statement and it took a long time to call the stored procedure. So we asked Microsoft to suggest us and they said below.

--

You should not use “sp_prepare” only for syntax check because it makes an execution plan and should change to use “SET PARSEONLY ON” + SQL statement. This “SET PARSEONLY” statement has been supported since SQL Server 2008. And it is also supported to both Azure SQL Database and Azure SQL Data Warehouse.

--

This issue also impacts the performance of short SQL statements which Modeler generates. The overhead of “sp_prepare” stands out since those SQL statements perform quickly.

  • Guest
  • Mar 15 2018
Real Scenario + Problem Statement
Role Summary
Who would benefit from this IDEA?
Revenue Opportunity
Idea Priority High
How should it work?
Owning Tribe
Owning Segment
Submitter Tags
Customer
Geo - Use for OBDR Reporting only
Why is it useful?
  • Attach files

NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "anonymous@euprivacy.out" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions