I think schema name is required:
SELECT * FROM "deptCache".DEPARTMENT
On Wed, Feb 16, 2022 at 11:55 AM Surinder Mehra <redni...@gmail.com> wrote:
> Hi,
> I tried to execute sql commands in control centre as per demo in ignite
> training on 15h feb
> I always get thai error " table not found"
> As you can see table name and schema is present on control centre. Same
> query works in java code.
> Am I missing something?
>
> Cache Config:
>
> CacheConfiguration<Integer, Department> deptCacheConfig = new
> CacheConfiguration<>(DEPT_CACHE);
> deptCacheConfig.setCacheMode(CacheMode.PARTITIONED);
> deptCacheConfig.setBackups(1);
> deptCacheConfig.setIndexedTypes(Integer.class, Department.class);
>
>
> Department class:
>
> public class Department implements Serializable{
> @QuerySqlField(index = true)
> private final int deptId;
> @QuerySqlField
> private final String deptName;
>
>
> [image: image.png]
>
>
