3337934 - Error: "You have an error in your SQL syntax .. right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1"" when using freehand SQL from SAC

Symptom

When running a freehand SQL query containing "OPTION SQL_SELECT_LIMIT=DEFAULT" to MySQL database from SAC, the below error message appears:

"Error occurred in the SAP Analytics Cloud agent Service: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1"."

Environment

SAP Analytics Cloud

Product

SAP Analytics Cloud 1.0

Keywords

Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, Issue, sapanalyticscloud, sap analytical cloud, sap analytical cloud, limit rows, cannot, execute , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Known Error

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.