Re: LIKE operator on Array column in Apache ignite SQL

2019-03-18 Thread Ilya Kasnacheev
ov > *Sent:* Saturday, March 16, 2019 05:06 AM > *To:* user@ignite.apache.org > *Subject:* Re: LIKE operator on Array column in Apache ignite SQL > > > > Hi, > > Ignite SQL engine supports only the next types: > > https://apacheignite-sql.readme.io/docs/data-types >

RE: LIKE operator on Array column in Apache ignite SQL

2019-03-18 Thread edvance CN
customized function for it. Best Regards, James Wang M/WeChat: +86 135 1215 1134 From: aealexsandrov mailto:aealexsand...@gmail.com>> Sent: Saturday, March 16, 2019 05:06 AM To: user@ignite.apache.org<mailto:user@ignite.apache.org> Subject: Re: LIKE operator on Array column in Apache ig

Re: LIKE operator on Array column in Apache ignite SQL

2019-03-15 Thread aealexsandrov
Hi, Ignite SQL engine supports only the next types: https://apacheignite-sql.readme.io/docs/data-types Also all existed functions you can see here: https://apacheignite-sql.readme.io/docs/sql-reference-overview So there is no way to work with arrays as DataTypes even if you set them as type in

LIKE operator on Array column in Apache ignite SQL

2019-03-15 Thread Hyma
Hi, Is there a way we can do like query on array field in ignite sql. Able to retrieve records on exact search using array_contains function like select * from market where array_contains(name,'LACL') - here name is an array object -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/