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"."
Read more...
Environment
SAP Analytics Cloud
Product
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.