Hi, IN clause is supported, however, it doesn't use indexes for now. It's better to replace it with a join to the temporary table: https://apacheignite-sql.readme.io/docs/performance-and-debugging#sql-performance-and-usability-considerations - paragraph 2.
Evgenii ср, 14 нояб. 2018 г. в 23:26, Ramin Farajollah (BLOOMBERG/ 731 LEX) < [email protected]>: > Hi, > > > - Is "IN" predicate supported? > - If so, can we use a "?" to be replaced and how? > > > Example. I'd like to construct something like this for an integer property: > > "id IN (1, 6, 12)" > > Thanks > Ramin >
