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
