You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by Anil <an...@gmail.com> on 2016/10/10 11:47:08 UTC
IN Query
HI ,
I am trying in query as given the below link and it is not working
https://apacheignite.readme.io/docs/sql-queries#performance-and-usability-considerations
sudo code :
List<Object> inParameter = new ArrayList<Object>();
inParameter.add("name0");
inParameter.add("name1");
String sql = "select p.id, p.name from Person p join table(id VARCHAR(15) =
?) i on p.name = i.id";
SqlFieldsQuery query = new
SqlFieldsQuery(sql).setArgs(inParameter.toArray());
Could you please point me the issue in the usage ?
Thanks.
Re: IN Query
Posted by Vladislav Pyatkov <vl...@gmail.com>.
Hi,
Try do it like:
SqlFieldsQuery query = new
SqlFieldsQuery(sql).setArgs(inParameter.toArray(),
anotherINParameter.toArray())
If you have more the one args, the method will be work.
On Tue, Oct 11, 2016 at 3:08 PM, Anil <an...@gmail.com> wrote:
> ignite supports multiple IN queries ? i tried the following and no luck.
>
> String sql = "select p.id, p.name from Person p join table(name
> VARCHAR(15) = ?) i on p.name = i.name join table(id varchar(15) = ?) k on
> p.id = k.id";
>
> SqlFieldsQuery query = new SqlFieldsQuery(sql).setArgs(new Object[] {
> inParameter.toArray()}, new Object[] { anotherINParameter.toArray()});
>
> Thanks
>
--
Vladislav Pyatkov
Re: IN Query
Posted by Anil <an...@gmail.com>.
ignite supports multiple IN queries ? i tried the following and no luck.
String sql = "select p.id, p.name from Person p join table(name VARCHAR(15)
= ?) i on p.name = i.name join table(id varchar(15) = ?) k on p.id = k.id";
SqlFieldsQuery query = new SqlFieldsQuery(sql).setArgs(new Object[] {
inParameter.toArray()}, new Object[] { anotherINParameter.toArray()});
Thanks
Re: IN Query
Posted by Anil <an...@gmail.com>.
Thank you.
how about checking multiple IN queries ?
String sql = "select p.id, p.name from Person p join table(name VARCHAR(15)
= ?) i on p.name = i.name join table(id varchar(15) = ?) k on p.id = k.id";
SqlFieldsQuery query = new SqlFieldsQuery(sql).setArgs(new Object[] {
inParameter.toArray()}, new Object[] { anotherINParameter.toArray()});
Apologies - i am sure i did something wrong. Thanks.
On 10 October 2016 at 20:37, Vladislav Pyatkov <vl...@gmail.com> wrote:
> Anil,
>
> Ignite has not itself DSL for SQL, but you can use any ANSI SQL generator.
> Ignite supported ANSI-99 standard compatibility.
>
> On Mon, Oct 10, 2016 at 3:04 PM, Anil <an...@gmail.com> wrote:
>
>> Thank you Vladislav. it worked. my bad.. i missed that.
>>
>> Was there any java Query DSL for ignite queries ? Thanks.
>>
>> On 10 October 2016 at 17:30, Vladislav Pyatkov <vp...@gridgain.com>
>> wrote:
>>
>>> Hi,
>>>
>>> Try to do it like this
>>>
>>> SqlFieldsQuery query = new SqlFieldsQuery(sql).setArgs(new Object[] {
>>> inParameter.toArray() });
>>>
>>> This will by perform, because the method (SqlFieldsQuery.setArgs())
>>> using varargs.
>>>
>>> On Mon, Oct 10, 2016 at 2:47 PM, Anil <an...@gmail.com> wrote:
>>>
>>>> HI ,
>>>>
>>>> I am trying in query as given the below link and it is not working
>>>>
>>>> https://apacheignite.readme.io/docs/sql-queries#performance-
>>>> and-usability-considerations
>>>>
>>>>
>>>> sudo code :
>>>>
>>>> List<Object> inParameter = new ArrayList<Object>();
>>>> inParameter.add("name0");
>>>> inParameter.add("name1");
>>>>
>>>> String sql = "select p.id, p.name from Person p join table(id
>>>> VARCHAR(15) = ?) i on p.name = i.id";
>>>>
>>>> SqlFieldsQuery query = new SqlFieldsQuery(sql).setArgs(in
>>>> Parameter.toArray());
>>>>
>>>> Could you please point me the issue in the usage ?
>>>>
>>>> Thanks.
>>>>
>>>>
>>>
>>
>
>
> --
> Vladislav Pyatkov
>
Re: IN Query
Posted by Vladislav Pyatkov <vl...@gmail.com>.
Anil,
Ignite has not itself DSL for SQL, but you can use any ANSI SQL generator.
Ignite supported ANSI-99 standard compatibility.
On Mon, Oct 10, 2016 at 3:04 PM, Anil <an...@gmail.com> wrote:
> Thank you Vladislav. it worked. my bad.. i missed that.
>
> Was there any java Query DSL for ignite queries ? Thanks.
>
> On 10 October 2016 at 17:30, Vladislav Pyatkov <vp...@gridgain.com>
> wrote:
>
>> Hi,
>>
>> Try to do it like this
>>
>> SqlFieldsQuery query = new SqlFieldsQuery(sql).setArgs(new Object[] {
>> inParameter.toArray() });
>>
>> This will by perform, because the method (SqlFieldsQuery.setArgs()) using
>> varargs.
>>
>> On Mon, Oct 10, 2016 at 2:47 PM, Anil <an...@gmail.com> wrote:
>>
>>> HI ,
>>>
>>> I am trying in query as given the below link and it is not working
>>>
>>> https://apacheignite.readme.io/docs/sql-queries#performance-
>>> and-usability-considerations
>>>
>>>
>>> sudo code :
>>>
>>> List<Object> inParameter = new ArrayList<Object>();
>>> inParameter.add("name0");
>>> inParameter.add("name1");
>>>
>>> String sql = "select p.id, p.name from Person p join table(id
>>> VARCHAR(15) = ?) i on p.name = i.id";
>>>
>>> SqlFieldsQuery query = new SqlFieldsQuery(sql).setArgs(in
>>> Parameter.toArray());
>>>
>>> Could you please point me the issue in the usage ?
>>>
>>> Thanks.
>>>
>>>
>>
>
--
Vladislav Pyatkov
Re: IN Query
Posted by Anil <an...@gmail.com>.
Thank you Vladislav. it worked. my bad.. i missed that.
Was there any java Query DSL for ignite queries ? Thanks.
On 10 October 2016 at 17:30, Vladislav Pyatkov <vp...@gridgain.com>
wrote:
> Hi,
>
> Try to do it like this
>
> SqlFieldsQuery query = new SqlFieldsQuery(sql).setArgs(new Object[] {
> inParameter.toArray() });
>
> This will by perform, because the method (SqlFieldsQuery.setArgs()) using
> varargs.
>
> On Mon, Oct 10, 2016 at 2:47 PM, Anil <an...@gmail.com> wrote:
>
>> HI ,
>>
>> I am trying in query as given the below link and it is not working
>>
>> https://apacheignite.readme.io/docs/sql-queries#performance-
>> and-usability-considerations
>>
>>
>> sudo code :
>>
>> List<Object> inParameter = new ArrayList<Object>();
>> inParameter.add("name0");
>> inParameter.add("name1");
>>
>> String sql = "select p.id, p.name from Person p join table(id
>> VARCHAR(15) = ?) i on p.name = i.id";
>>
>> SqlFieldsQuery query = new SqlFieldsQuery(sql).setArgs(in
>> Parameter.toArray());
>>
>> Could you please point me the issue in the usage ?
>>
>> Thanks.
>>
>>
>
Re: IN Query
Posted by Vladislav Pyatkov <vp...@gridgain.com>.
Hi,
Try to do it like this
SqlFieldsQuery query = new SqlFieldsQuery(sql).setArgs(new Object[] {
inParameter.toArray() });
This will by perform, because the method (SqlFieldsQuery.setArgs()) using
varargs.
On Mon, Oct 10, 2016 at 2:47 PM, Anil <an...@gmail.com> wrote:
> HI ,
>
> I am trying in query as given the below link and it is not working
>
> https://apacheignite.readme.io/docs/sql-queries#performance-and-usability-
> considerations
>
>
> sudo code :
>
> List<Object> inParameter = new ArrayList<Object>();
> inParameter.add("name0");
> inParameter.add("name1");
>
> String sql = "select p.id, p.name from Person p join table(id VARCHAR(15)
> = ?) i on p.name = i.id";
>
> SqlFieldsQuery query = new SqlFieldsQuery(sql).setArgs(
> inParameter.toArray());
>
> Could you please point me the issue in the usage ?
>
> Thanks.
>
>