Hi Bob, Due to some reason my answer has got in another conversation, so duplicating it here. Hi,
You need either adjust entity/table name to the upper case like *select ID from "personCache".PERSON p limit 5* or add a config option <propertyname="sqlEscapeAll" value="true"/>, in this case you will be able to perform the query in the following way *select \"id\" from \"personCache\".\"Person\" p limit 5* (note the escaping is mandatory for all the parts: schema, table, field). Kind regards, Alex. Kind regards, Alex 19 июля 2017 г. 11:12 PM пользователь "vkulichenko [via Apache Ignite Users]" <[email protected]> написал: Bob, Original query is wrong for sure. \\\" means that you actually have a slash in SQL string which is obviously wrong. As for the second error, it looks like a misconfiguration. Please provide more information on what exactly you did, your configuration, etc. -Val ------------------------------ If you reply to this email, your message will be added to the discussion below: http://apache-ignite-users.70518.x6.nabble.com/SQL- Syntax-error-in-cross-cache-query-tp15097p15139.html To start a new topic under Apache Ignite Users, email [email protected] To unsubscribe from Apache Ignite Users, click here <http://apache-ignite-users.70518.x6.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=1&code=YWxleGFuZGVyLmZlZG90b2ZmQGdtYWlsLmNvbXwxfC0xMzYxNTU0NTg=> . NAML <http://apache-ignite-users.70518.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Re-SQL-Syntax-error-in-cross-cache-query-tp15157.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.
