You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by Biraj Deb <bi...@decisionmanagementsolutions.com> on 2023/01/12 14:56:16 UTC
How to Create a Case-Insensitive Index
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
Re: How to Create a Case-Insensitive Index
Posted by Ilya Korol <ll...@gmail.com>.
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 <ll...@gmail.com> 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
>
Re: How to Create a Case-Insensitive Index
Posted by Biraj Deb <bi...@decisionmanagementsolutions.com>.
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 <ll...@gmail.com> 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
>
Re: How to Create a Case-Insensitive Index
Posted by Ilya Korol <ll...@gmail.com>.
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