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. >>> >>
