You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by vkulichenko <va...@gmail.com> on 2016/07/28 22:07:20 UTC
Re: Issue with querying from cache
Hi,
First of all, please properly subscribe to the mailing list so that the
community can receive email notifications for your messages. Here is the
instruction:
http://apache-ignite-users.70518.x6.nabble.com/mailing_list/MailingListOptions.jtp?forum=1
chetanvyadav wrote
> I have 2 tables, one with 20,000 say table A and table B with >60,000
> rows of data. I am loading data from A to cache and able to query it. But
> when I load table B to cache, loading doesn't throw any error and says
> successful. But when I try to query from cache, it says:
*
> 'Failed to parse query: select str from B
> Table "B" not found; SQL statement: ...'
*
You must be doing something wrong. Please provide your test code and
configurations.
-Val
--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Issue-with-querying-from-cache-tp6588p6599.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.
Re: Issue with querying from cache
Posted by chevy <ch...@target.com>.
Regarding Payroll, I had changed Payroll to tableB but missed to change it
there. That is not an issue.
I tried querying using cache_name.table_name but still it is not working.
Please let me know if you need more inputs on this so that I can get some
resolution.
--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Issue-with-querying-from-cache-tp6588p6648.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.
Re: Issue with querying from cache
Posted by chevy <ch...@target.com>.
Issue got fixed. I have set Index type in my code which was not matching my
Class type. Thanks for the help.
--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Issue-with-querying-from-cache-tp6588p6658.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.
Re: Issue with querying from cache
Posted by vkulichenko <va...@gmail.com>.
Are you using the correct cache when executing the query? You can also try to
explicitly specify the cache name:
select * from "testCache".TableB ...
BTW, it seems weird to me that the cache type is Payroll, but the indexed
type is TableB. How are they related to each other?
-Val
--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Issue-with-querying-from-cache-tp6588p6630.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.