Hello, I really need help. First, sorry but I can’t share code because of my boss.
I have two tables, normally partitioned, but I can’t collocate data (simply because other tables are related to using other columns). On these tables I have stetted my indexes, everything is done using create table and create index scripts. Then when I execute my request, a left join, on only one node, ignite say to me that my join do not use indexes while raising an exception, wich is wrong because I created them. The most strange thing is that if I set the second table as replicated instead of partitioned, it works ! I precise that my data are inserted using binary objects. Is anybody have an idea ? Thanks in advance.
