Hello! I don't understand what you are doing here. Why do you have two employee tables here? What is desired table structure?
Regards, -- Ilya Kasnacheev ср, 20 мар. 2019 г. в 16:44, Mike Needham <[email protected]>: > I have that part, what I dont understand is how I can create multiple > "Tables" within a Cache(Schema)? I have the following code that is using a > simple Employee Class. > > IgniteCache<Object, Object> testCache = > ignite.getOrCreateCache(new CacheConfiguration<>("MAIN") > .setIndexedTypes(Long.class, Employee.class) > .setQueryEntities(Collections.singleton( > new QueryEntity(Integer.class, > String.class).setTableName("EMPLOYEE")))); > Employee e = new Employee(1, "Test", 123.34f, 3); > try (IgniteDataStreamer<Long, Employee> ds = > ignite.dataStreamer("MAIN")) { > ds.addData(1l, e); > } > > how would one go about adding a second "Table" to the MAIN cache so that > it is queryable from DBeaver or other tools? > > > On Wed, Mar 20, 2019 at 4:29 AM Ilya Kasnacheev <[email protected]> > wrote: > >> Hello! >> >> Please take a look at >> https://apacheignite.readme.io/docs/cache-queries#section-query-configuration-by-annotations >> >> Regards, >> -- >> Ilya Kasnacheev >> >> >> вт, 19 мар. 2019 г. в 20:25, Mike Needham <[email protected]>: >> >>> Do you have an example of how that could be done. I am struggling to >>> figure out how to set this up. >>> >>> On Mon, Mar 18, 2019 at 2:00 AM Ilya Kasnacheev < >>> [email protected]> wrote: >>> >>>> Hello! >>>> >>>> The best approach is to use .setIndexedTypes() instead of >>>> setQueryEntities(), and annotate complex types in question with >>>> @QuerySqlField. >>>> This way you can then pour those types into cache and it will work >>>> transparently. >>>> >>>> Regards, >>>> -- >>>> Ilya Kasnacheev >>>> >>>> >>>> пт, 15 мар. 2019 г. в 18:28, Mike Needham <[email protected]>: >>>> >>>>> Perfect, now the next question is how would you do this for a more >>>>> complex object/table? Either one defined in a separate object or via SQL >>>>> DDL? >>>>> >>>>> On Fri, Mar 15, 2019 at 9:05 AM Ilya Kasnacheev < >>>>> [email protected]> wrote: >>>>> >>>>>> Hello! >>>>>> >>>>>> You will have to specify schema name (or cache name?) in ALLCAPS when >>>>>> creating cache. >>>>>> >>>>>> Regards, >>>>>> -- >>>>>> Ilya Kasnacheev >>>>>> >>>>>> >>>>>> пт, 15 мар. 2019 г. в 16:45, Mike Needham <[email protected]>: >>>>>> >>>>>>> I see. did not have the "person" for the schema. Is there a way to >>>>>>> not have the quotes around that? >>>>>>> >>>>>>> On Fri, Mar 15, 2019 at 7:59 AM ilya.kasnacheev < >>>>>>> [email protected]> wrote: >>>>>>> >>>>>>>> Hello! >>>>>>>> >>>>>>>> Definitely works for me in DBeaver with this exact code: >>>>>>>> >>>>>>>> < >>>>>>>> http://apache-ignite-users.70518.x6.nabble.com/file/t1312/dbeaver-tables.png> >>>>>>>> >>>>>>>> >>>>>>>> Some of DBeaver's introspection does not work but statements are >>>>>>>> solid. >>>>>>>> >>>>>>>> Regards, >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >>>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> *Some days it just not worth chewing through the restraints* >>>>>>> >>>>>> >>>>> >>>>> -- >>>>> *Some days it just not worth chewing through the restraints* >>>>> >>>> >>> >>> -- >>> *Some days it just not worth chewing through the restraints* >>> >> > > -- > *Some days it just not worth chewing through the restraints* >
