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
