Hi Vladimir, Thanks for the reply. Excuse my noob-ness, but "reproducer"? What do you need for that?
It appears the issue had to do with the multi-field index "CALENDAR_METRIC_PERIOD_DAYS_R_IDX". Considering the test query filters both on period and days_r I thought this index would be ideal, but for some reason it causes the query to hang. I'm not sure if that's a bug or a failure in my implementation somewhere. I changed the index to index just on days_r and the query executes properly. Related to indexes, I'm a little confused as to whether I need to add my Ignite table key as an actual field within the table. Ie. in postgres I have a table "city" with fields "id" and "name". In Ignite "id" is the key. If I want to do a join based on "id" on this table in Ignite do I also have to add "id" as an indexed field within the the table? Or is it considered "proper" to do a join using using "_key"? -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/odd-query-plan-with-joins-tp13680p13728.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.
