Long story short: if you create cache via Java API or xml as in your
snippet, you should use <CACHE_NAME>.<VALUE_TYPE_NAME> to refer table from
SQL query. So if your cache named "mycache" has objects of type "Person" you
should "select * from "mycache".Person" with cache name escaped with quotes.