Re: SQL Syntax error in cross-cache query

2017-07-21 Thread Bob Li
Thank Afedotov. This issue is solved, I got misunderstood some syntax before. -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Re-SQL-Syntax-error-in-cross-cache-query-tp15107p15231.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: SQL Syntax error in cross-cache query

2017-07-19 Thread afedotov
: Schema "PERSONCACHE" not found. The style > \"personCache\" can be separated from the Schema "personCache" in H2. > > -- > If you reply to this email, your message will be added to the discussion > below: > http://apache-ig

Re: SQL Syntax error in cross-cache query

2017-07-19 Thread afedotov
al -- 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 ml+s70518n1...@n6.nabble.com To

Re: SQL Syntax error in cross-cache query

2017-07-19 Thread vkulichenko
ge 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

2017-07-19 Thread Alexander Fedotov
x = true, name = "biz_date") > private Date bizDate; > ... > } > > > > > > > -- > View this message in context: http://apache-ignite-users. > 70518.x6.nabble.com/Re-SQL-Syntax-error-in-cross-cache- > query-tp15107p15115.html > Sent from the Apache Ignite Users mailing list archive at Nabble.com. >

Re: SQL Syntax error in cross-cache query

2017-07-19 Thread Bob Li
@Field("biz_date") @QuerySqlField(index = true, name = "biz_date") private Date bizDate; ... } -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Re-SQL-Syntax-error-in-cross-

Re: SQL Syntax error in cross-cache query

2017-07-19 Thread afedotov
l%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 conte

Re: SQL Syntax error in cross-cache query

2017-07-19 Thread howfree
Yes. It came up with the error: Schema "PERSONCACHE" not found. I guess it means the schema in H2 database. but this cache should be different from it. right? -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Re-SQL-Syntax-error-in-cross-c

Re: SQL Syntax error in cross-cache query

2017-07-19 Thread afedotov
ot; can be separated from the Schema "personCache" in H2. -- 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-tp15097p15102.html To start a

Re: SQL Syntax error in cross-cache query

2017-07-18 Thread howfree
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-tp

Re: SQL Syntax error in cross-cache query

2017-07-18 Thread afedotov
s. -- 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-tp15097.html To start a new topic under Apache Ignite Users, email ml+s70518n1...@n6.nabble.com To

Re: SQL Syntax error in cross-cache query

2017-07-18 Thread tuco.ramirez
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.

SQL Syntax error in cross-cache query

2017-07-18 Thread howfree
hat'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.