What kind of exception? Do you have a stacktrace? Do you observe any
errors/messages in server logs? Anyway Ignite might not support this
feature yet.
Feel free to submit a Jira with feature request.
13.01.2023 14:34, Biraj Deb пишет:
I have tried
CREATE INDEX title_idx ON books (lower(title));
but getting SQLException.
Basically I want to configure the index in my Ignite XML Configuration.
<property name="indexes">
<list>
<bean class="org.apache.ignite.cache.QueryIndex">
<constructor-arg>
<list>
<value>referenceId</value>
<value>customerId</value>
</list>
</constructor-arg>
<constructor-arg value="SORTED" />
</bean>
</list>
</property>
In above in have define one index and now need to create one more
index on name field which should be case-insensitive
On Thu, Jan 12, 2023 at 9:46 PM Ilya Korol <[email protected]> wrote:
Hi, usually this can be achieved by using lower() function in index
definition. I guess it should be something like:
CREATE INDEX title_idx ON books (lower(title));
I'm not sure whether Ignite supports such feature, but you can
give it a
try.
Btw, to exploit this index you also would have to use lower()
function
in you queries as well.
Useful link:
https://use-the-index-luke.com/sql/where-clause/functions/case-insensitive-search
12.01.2023 17:56, Biraj Deb пишет:
> Hello,
> I am writing to inquire about creating a case-insensitive index in
> Ignite's XML Configuration. I have been trying to implement this
> feature in my current project, but I am having some difficulty.
> I understand that ignite supports case-sensitive indexing by
default,
> but I would like to know if there is a way to configure it for
> case-insensitive indexing. If anyone has experience with this or
can
> point me in the right direction, it would be greatly appreciated.
> Thank you for your time and expertise.
> Best regards
> Biraj Deb
