SQL Syntax error in cross-cache query

[howfree <27...@qq.com>]

In ignite 2.0:
when I ran those codes: 
SqlFieldsQuery sql = new SqlFieldsQuery("select id from
\\\"personCache\\\".Person p limit 5");

I got it:
"Syntax error in SQL statement "SELECT ID FROM[*] \""personCache\"".PERSON P
LIMIT 5 ";

What's this mistake ? thanks.



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/SQL-Syntax-error-in-cross-cache-query-tp15097.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: SQL Syntax error in cross-cache query

[vkulichenko <va...@gmail.com>]

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



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/SQL-Syntax-error-in-cross-cache-query-tp15097p15139.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: SQL Syntax error in cross-cache query

[howfree <27...@qq.com>]

The following error  came up:Schema "PERSONCACHE" not found.The style
\"personCache\" can be separated from the Schema "personCache" in H2.



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/SQL-Syntax-error-in-cross-cache-query-tp15097p15102.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: SQL Syntax error in cross-cache query

["tuco.ramirez" <ra...@gmail.com>]

i think "select id from personCache.Person p limit 5" should work.



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/SQL-Syntax-error-in-cross-cache-query-tp15097p15099.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.