Re: Problem with SqlFieldsQuery

2021-10-27 Thread Maksim Timonin
; > > > *From:* Maksim Timonin > *Sent:* Tuesday, October 26, 2021 2:36 PM > *To:* user@ignite.apache.org; Prasad Kommoju > *Subject:* Re: Problem with SqlFieldsQuery > > > > Hi, Prasad! > > > > Looks like you missed the topic, and posted your code to another th

RE: Problem with SqlFieldsQuery

2021-10-26 Thread Prasad Kommoju
(PersonSQL). One of them seems to throw failed to set schema and the other empty results. - Regards, Prasad Kommoju From: Maksim Timonin Sent: Tuesday, October 26, 2021 2:36 PM To: user@ignite.apache.org; Prasad Kommoju Subject: Re: Problem with SqlFieldsQuery Hi, Pras

Re: Problem with SqlFieldsQuery

2021-10-26 Thread Maksim Timonin
Hi, Prasad! Looks like you missed the topic, and posted your code to another thread. But nevertheless, did you check the package name of PersonSQL class in the CacheConfiguration and in your insertion code? On Tue, Oct 26, 2021 at 10:15 AM Maksim Timonin wrote: > Hi, Prasad! > > Could you pleas

Re: Problem with SqlFieldsQuery

2021-10-26 Thread Maksim Timonin
Hi, Prasad! Could you please show how you insert data to the table? As I see you defined table with "com.*blah*.sfqx.SqlFieldQueryXML$PersonSQL" but cache scan returns objects with value type "com.*futurewei*.sfqx.SqlFieldQueryXML$PersonSQL". Can this misprint be a reason? On Tue, Oct 26, 2021 a

Problem with SqlFieldsQuery

2021-10-25 Thread Prasad Kommoju
I create a cache with QueryEntities (through ignite configuration file) and use SqlFieldsQuery to query it. I can see the cache in ignitevisor and it appears as table through sqlline interface. While ignitevisor shows the data sqlline tool does not. Here is the configuration: ...