Mailing-List: contact user-help@ignite.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@ignite.apache.org
Date: Thu, 4 Aug 2016 00:02:58 -0700 (PDT)
From: begineer <rednirus@gmail.com>
To: user@ignite.apache.org
Message-ID: <1470294178110-6732.post@n6.nabble.com>
In-Reply-To: <1470271662076-6723.post@n6.nabble.com>
References: <1470161779255-6674.post@n6.nabble.com> <1470172308243-6680.post@n6.nabble.com> <1470208182505-6697.post@n6.nabble.com> <1470212234345-6702.post@n6.nabble.com> <1470271662076-6723.post@n6.nabble.com>
Subject: Re: Getting exception in SQL Query JOINS
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
archived-at: Thu, 04 Aug 2016 07:03:10 -0000

So What I mean is I need to get data from cache which has keys in the list I
pass to query.
equavalent SQL will be like, 
List list = Arrays.asList(2,3,6);//dynamic list coming from client
			StringBuffer queryStrings = new StringBuffer(" ");
			for (Object object : list) {
				queryStrings.append("?,");
			}
			queryStrings.deleteCharAt(queryStrings.length()-1);

			String sql = "select * from Company where Id in (?);
			SqlQuery<Integer, Company> query1 =  new SqlQuery<>(Company.class, sql);
			query1.setArgs(queryStrings.toString());

Here, I can append as many keys to stringbuffer as I want and then pass them
to IN clause. BUt this is not good approach and plus IN will not use
indexing.

How do I achieve same thing using table JOIN approach you suggested.


--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Getting-exception-in-SQL-Query-JOINS-tp6674p6732.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.