Mailing-List: contact user-help@ignite.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@ignite.apache.org
MIME-Version: 1.0
In-Reply-To: <1468417724460-6275.post@n6.nabble.com>
References: <1468400302892-6260.post@n6.nabble.com> <CAEOB7kWa3RLvNLQN_sJPY0t7O45UfOrDHYG2o7t3j8mywYg8yw@mail.gmail.com>
 <CADez4_X=p4vsqJ2P=hF=Ppb--Z9HLxrK3NLycf3m-2QH8-HiCg@mail.gmail.com> <1468417724460-6275.post@n6.nabble.com>
From: Vladislav Pyatkov <vldpyatkov@gmail.com>
Date: Wed, 13 Jul 2016 17:19:16 +0300
Message-ID: <CADez4_WXWHorXaVsJTZYDGfBF7qFzrAX=S5qx0yx5Qtd35Kb9Q@mail.gmail.com>
Subject: Re: How does AffinityKey mapped?
To: user@ignite.apache.org
Content-Type: multipart/alternative; boundary=001a1143e0c00d3e0c05378512bf
archived-at: Wed, 13 Jul 2016 14:19:23 -0000

--001a1143e0c00d3e0c05378512bf
Content-Type: text/plain; charset=UTF-8

Hello,

You can to use both key with affinity part.

For example:

public class cache1Key {
    private int uniqueId1;

    @AffinityKeyMapped
    private int DEV_LV;
}

public class cache2Key {
    private int uniqueId2;

    @AffinityKeyMapped
    private int DEV_LV;
}

On Wed, Jul 13, 2016 at 4:48 PM, November <yufeng7144@126.com> wrote:

> Thanks for reply
>
> I have another question. There are two tables.
>
> CREATE TABLE  T1
>  ( LAT_ID        SMALLINT,
>    DEV_ID    VARCHAR(20),
>    DEV_LV    SMALLINT
>  );
>
>   CREATE TABLE  T2
>  ( THE_DATE              DATE,
>    DEV_ID           VARCHAR(20),
>    DEV_LV          SMALLINT
>  );
>
>  SQL query:
> SELECT t1.* from t1, t2 where t2.DEV_LV = t1.DEV_LV
>
> I use cache1<cache1Key, cache1Value> and cache2<Integer, cache2Value> (use
> DEV_LV as key) to store it.
>
> public class cache1Key {
>     private int DEV_LV;
>
>     /** Organization ID. */
>     @AffinityKeyMapped
>     private int cache2_DEV_LV;
> }
>
> What if there are repeat DEV_LV in both tables(but the cache's key need to
> be unique) ? Is there any other way to achieve collocate using
> @AffinityKeyMapped?
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/How-does-AffinityKey-mapped-tp6260p6275.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>


-- 
Vladislav Pyatkov

--001a1143e0c00d3e0c05378512bf
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hello,<div><br></div><div><div>You can to use both key wit=
h affinity part.</div><div><br></div><div>For example:</div><div><br></div>=
<div>public class cache1Key {</div><div>=C2=A0 =C2=A0 private int uniqueId1=
;</div><div><br></div><div>=C2=A0 =C2=A0 @AffinityKeyMapped</div><div>=C2=
=A0 =C2=A0 private int DEV_LV;</div><div>}</div><div><br></div><div>public =
class cache2Key {</div><div>=C2=A0 =C2=A0 private int uniqueId2;</div><div>=
<br></div><div>=C2=A0 =C2=A0 @AffinityKeyMapped</div><div>=C2=A0 =C2=A0 pri=
vate int DEV_LV;</div><div>}</div></div></div><div class=3D"gmail_extra"><b=
r><div class=3D"gmail_quote">On Wed, Jul 13, 2016 at 4:48 PM, November <spa=
n dir=3D"ltr">&lt;<a href=3D"mailto:yufeng7144@126.com" target=3D"_blank">y=
ufeng7144@126.com</a>&gt;</span> wrote:<br><blockquote class=3D"gmail_quote=
" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">T=
hanks for reply<br>
<br>
I have another question. There are two tables.<br>
<br>
CREATE TABLE=C2=A0 T1<br>
=C2=A0( LAT_ID=C2=A0 =C2=A0 =C2=A0 =C2=A0 SMALLINT,<br>
=C2=A0 =C2=A0DEV_ID=C2=A0 =C2=A0 VARCHAR(20),<br>
=C2=A0 =C2=A0DEV_LV=C2=A0 =C2=A0 SMALLINT<br>
=C2=A0);<br>
<br>
=C2=A0 CREATE TABLE=C2=A0 T2<br>
=C2=A0( THE_DATE=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 DATE,<br>
=C2=A0 =C2=A0DEV_ID=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0VARCHAR(20),<br=
>
=C2=A0 =C2=A0DEV_LV=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 SMALLINT<br>
=C2=A0);<br>
<br>
=C2=A0SQL query:<br>
SELECT t1.* from t1, t2 where t2.DEV_LV =3D t1.DEV_LV<br>
<br>
I use cache1&lt;cache1Key, cache1Value&gt; and cache2&lt;Integer, cache2Val=
ue&gt; (use<br>
DEV_LV as key) to store it.<br>
<br>
public class cache1Key {<br>
=C2=A0 =C2=A0 private int DEV_LV;<br>
<span class=3D""><br>
=C2=A0 =C2=A0 /** Organization ID. */<br>
=C2=A0 =C2=A0 @AffinityKeyMapped<br>
</span>=C2=A0 =C2=A0 private int cache2_DEV_LV;<br>
}<br>
<br>
What if there are repeat DEV_LV in both tables(but the cache&#39;s key need=
 to<br>
be unique) ? Is there any other way to achieve collocate using<br>
@AffinityKeyMapped?<br>
<br>
<br>
<br>
--<br>
View this message in context: <a href=3D"http://apache-ignite-users.70518.x=
6.nabble.com/How-does-AffinityKey-mapped-tp6260p6275.html" rel=3D"noreferre=
r" target=3D"_blank">http://apache-ignite-users.70518.x6.nabble.com/How-doe=
s-AffinityKey-mapped-tp6260p6275.html</a><br>
<div class=3D"HOEnZb"><div class=3D"h5">Sent from the Apache Ignite Users m=
ailing list archive at Nabble.com.<br>
</div></div></blockquote></div><br><br clear=3D"all"><div><br></div>-- <br>=
<div class=3D"gmail_signature" data-smartmail=3D"gmail_signature">Vladislav=
 Pyatkov</div>
</div>

--001a1143e0c00d3e0c05378512bf--