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 <[email protected]> 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 <[email protected]> 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 <[email protected]>
>> 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 <[email protected]> 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
>
