I recommend that Ignite can implement a function using JSON Path to handle such ArrayList type.
Since most of RDBS supports JSON PATH now like MSSQL. It would be easier for developer to handle with nested object or JSON string. Before Ignite implement this, developer have to implement a customized function for it. Best Regards, James Wang M/WeChat: +86 135 1215 1134 From: aealexsandrov <[email protected]<mailto:[email protected]>> Sent: Saturday, March 16, 2019 05:06 AM To: [email protected]<mailto:[email protected]> 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 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 QueryEntity. Possible that you can add some new boolean SQL fields to the object that contains the array: public class Market{ @QuerySqlField(index = true) private java.lang.String id; @QuerySqlField private java.lang.Boolean isContainLacl; @QuerySqlField private ArrayList<String> array; select * from market where isContainLacl = true; You can fill this boolean flag when generating the Market object. BR, Andrei -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/ This message contains information that is deemed confidential and privileged. Unless you are the addressee (or authorized to receive for the addressee), you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received the message in error, please advise the sender by reply e-mail and delete the message.
