3406001 - Failed to preview the imported remote table in Datasphere and received SQL syntax - SAP HANA Smart Data Integration

• When trying to preview the imported remote table in Datasphere, received the following error message.
  • The error message: internal error: Camel excution failed.
• The framework.trc of DP agent may contain the following error message.
  • DatabaseSQLRewriter.rewrite [] - Rewritten SQL: SELECT TOP 1000  ***, "***" FROM "<Table_Name>", You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1000 "
  • DefaultErrorHandler | CamelLogger.log [] - Failed delivery for (MessageId: <Message_Id> on ExchangeId: <Exchange_ID>). Exhausted after delivery attempt: 1 caught: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 '1000  <table>.<column> ...' at line 1

• SAP HANA Smart Data Integration
• SAP DataSphere

Camel execution failed, SDI, Datasphere, check the manual that corresponds to your MariaDB server version for the right syntax to use near, TOP, LIMIT , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem