ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Wang 王升平 (edvance CN) <james.w...@edvancesecurity.com>
Subject RE: LIKE operator on Array column in Apache ignite SQL
Date Mon, 18 Mar 2019 10:41:15 GMT
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 <aealexsandrov@gmail.com<mailto:aealexsandrov@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 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.
Mime
View raw message