You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by the_palakkaran <ji...@suntecsbs.com> on 2018/05/23 09:27:40 UTC
LIKE operator in Apache ignite SQL
Hi, will like operator work in Apache ignite in the same way as in Oracle? I
saw somewhere it should be uses as key=%value%.
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: LIKE operator in Apache ignite SQL
Posted by the_palakkaran <ji...@suntecsbs.com>.
Yes, it is working. Thanks, Ilya
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: LIKE operator in Apache ignite SQL
Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello!
I believe this is the case! Have you checked?
Regards,
--
Ilya Kasnacheev
2018-05-23 12:38 GMT+03:00 the_palakkaran <ji...@suntecsbs.com>:
> @ilya So does this mean an SQL field query executed on a cache as "select
> custNo from Customer where custId like '%SAM%'" will work and return values
> ?
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>
Re: LIKE operator in Apache ignite SQL
Posted by the_palakkaran <ji...@suntecsbs.com>.
@ilya So does this mean an SQL field query executed on a cache as "select
custNo from Customer where custId like '%SAM%'" will work and return values
?
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: LIKE operator in Apache ignite SQL
Posted by Ilya Kasnacheev <il...@gmail.com>.
LIKE in Apache Ignite should work as it is described in SQL standard, where
'%' means 'any characters'.
Note that indexes can only be used with LIKE if wildcard is not used at
first position:
foo LIKE '%bar%' - no index.
foo LIKE 'bar%' - can use index.
Regards,
--
Ilya Kasnacheev
2018-05-23 12:27 GMT+03:00 the_palakkaran <ji...@suntecsbs.com>:
> Hi, will like operator work in Apache ignite in the same way as in Oracle?
> I
> saw somewhere it should be uses as key=%value%.
>
>
>
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>