Then can you please explain what the option collocated=true for JDBC url is for? Should I assume that if the table is defined with affinity set, then compute collocation, including sql execution will happen automatically? I am sorry if this is just a basic question.
On Wed, Jun 17, 2020 at 12:57 PM Denis Magda <[email protected]> wrote: > If the data is already co-located you don't need to pass in any other > parameters. > > - > Denis > > > On Wed, Jun 17, 2020 at 10:13 AM narges saleh <[email protected]> > wrote: > >> Hi Denis. The tables are defined with affinity keys specified. What I am >> asking whether to set the collection option when I insert or query the data >> via SQL line. >> >> thanks >> >> On Wed, Jun 17, 2020 at 11:39 AM Denis Magda <[email protected]> wrote: >> >>> Hi, >>> >>> You need to pass the required parameters to the JDBC driver's connection >>> URL: >>> https://apacheignite-sql.readme.io/docs/jdbc-driver#parameters >>> >>> However, I'm not quite sure what you mean under the "collocation" in the >>> following context. All your data needs to be co-located beforehand (ensure >>> you have affinity keys configured) and then just send your queries with >>> joins with no additional connection parameters. >>> >>> - >>> Denis >>> >>> >>> On Wed, Jun 17, 2020 at 9:33 AM narges saleh <[email protected]> >>> wrote: >>> >>>> Hi All, >>>> >>>> Is collocation enforced when SQL is issues in sqline command line or do >>>> I need to give the option when I start sqlline? >>>> >>>> thanks. >>>> >>>
