Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
MIME-Version: 1.0
In-Reply-To: 
 <CADfhF1EZKNZiKy2yX-VbOwZxWrEzGJqN-2fuCdeng1hE9h102A@mail.gmail.com>
References: 
 <CADfhF1EZKNZiKy2yX-VbOwZxWrEzGJqN-2fuCdeng1hE9h102A@mail.gmail.com>
Date: Thu, 12 Nov 2015 14:41:42 +0100
Message-ID: 
 <CABNXB2AbBTYOs4tN+h6LJ6-iuXYqZdFewUBsuxbe_c+wtU2h1A@mail.gmail.com>
Subject: Re: Spark on cassandra
From: DuyHai Doan <doanduyhai@gmail.com>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=94eb2c096e806dcf100524581acd

--94eb2c096e806dcf100524581acd
Content-Type: text/plain; charset=UTF-8

Hello Prem

I believe it's better to ask your question on the ML of the Spark Cassandra
connector:
http://groups.google.com/a/lists.datastax.com/forum/#!forum/spark-connector-user

Second "we need to join multiple table from multiple keyspaces. How can we
do that?", the response is given in your example, you pass the keyspace
name as parameter for each operation with Cassandra.

On Thu, Nov 12, 2015 at 2:12 PM, Prem Yadav <ipremyadav@gmail.com> wrote:

> Hi,
> Is it better to use Spark APIs to do join on cassandra tables or should we
> use SPARK-SQL.
> We have been struggling with SPARK-SQL as we need to do multiple large
> table joins and there is always failure.
>
> I tried to do joins using the API like this:
> val join1 =
> sc.cassandraTable("Keyspace1","table1").joinWithCassandraTable("keyspace1","table2").on(SomeColumns("column1"))
>
> however, we need to join multiple table from multiple keyspaces. How can
> we do that?
>
>
> Thanks,
> Prem
>

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

<div dir=3D"ltr">Hello Prem<div><br></div><div>I believe it&#39;s better to=
 ask your question on the ML of the Spark Cassandra connector:=C2=A0<a href=
=3D"http://groups.google.com/a/lists.datastax.com/forum/#!forum/spark-conne=
ctor-user">http://groups.google.com/a/lists.datastax.com/forum/#!forum/spar=
k-connector-user</a></div><div><br></div><div>Second &quot;<span style=3D"f=
ont-size:12.8px">we need to join multiple table from multiple keyspaces. Ho=
w can we do that?&quot;, the response is given in your example, you pass th=
e keyspace name as parameter for each operation with Cassandra.</span></div=
></div><div class=3D"gmail_extra"><br><div class=3D"gmail_quote">On Thu, No=
v 12, 2015 at 2:12 PM, Prem Yadav <span dir=3D"ltr">&lt;<a href=3D"mailto:i=
premyadav@gmail.com" target=3D"_blank">ipremyadav@gmail.com</a>&gt;</span> =
wrote:<br><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;bord=
er-left:1px #ccc solid;padding-left:1ex"><div dir=3D"ltr">Hi,<div>Is it bet=
ter to use Spark APIs to do join on cassandra tables or should we use SPARK=
-SQL.</div><div>We have been struggling with SPARK-SQL as we need to do mul=
tiple large table joins and there is always failure.</div><div><br></div><d=
iv>I tried to do joins using the API like this:</div><div>val join1 =3D sc.=
cassandraTable(&quot;Keyspace1&quot;,&quot;table1&quot;).joinWithCassandraT=
able(&quot;keyspace1&quot;,&quot;table2&quot;).on(SomeColumns(&quot;column1=
&quot;))<br></div><div><br></div><div>however, we need to join multiple tab=
le from multiple keyspaces. How can we do that?</div><div><br></div><div><b=
r></div><div>Thanks,</div><div>Prem</div></div>
</blockquote></div><br></div>

--94eb2c096e806dcf100524581acd--