spark-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mohammed Guller <moham...@glassbeam.com>
Subject RE: Anybody using Spark SQL JDBC server with DSE Cassandra?
Date Thu, 04 Jun 2015 17:39:17 GMT
Deenar,
Thanks for the suggestion.
That is one of the ideas that I have, but didn’t get chance to try it out yet. One of the
things that could potentially cause problems is that we use wide rows. In addition, the schema
is dynamic, with new columns getting added on a regular basis. That is why I am considering
DSE, which has integrated Spark SQL Thrift/JDBC server with Cassandra.

Mohammed

From: Deenar Toraskar [mailto:deenar.toraskar@gmail.com]
Sent: Thursday, June 4, 2015 7:42 AM
To: Mohammed Guller
Cc: user@spark.apache.org
Subject: Re: Anybody using Spark SQL JDBC server with DSE Cassandra?

Mohammed

Have you tried registering your Cassandra tables in Hive/Spark SQL using the data frames API.
These should be then available to query via the Spark SQL/Thrift JDBC Server.

Deenar

On 1 June 2015 at 19:33, Mohammed Guller <mohammed@glassbeam.com<mailto:mohammed@glassbeam.com>>
wrote:
Nobody using Spark SQL JDBC/Thrift server with DSE Cassandra?

Mohammed

From: Mohammed Guller [mailto:mohammed@glassbeam.com<mailto:mohammed@glassbeam.com>]
Sent: Friday, May 29, 2015 11:49 AM
To: user@spark.apache.org<mailto:user@spark.apache.org>
Subject: Anybody using Spark SQL JDBC server with DSE Cassandra?

Hi –

We have successfully integrated Spark SQL with Cassandra. We have a backend that provides
a REST API that allows users to execute SQL queries on data in C*. Now we would like to also
support JDBC/ODBC connectivity , so that user can use tools like Tableau to query data in
C* through the Spark SQL JDBC server.

However, I have been unable to find a driver that would allow the Spark SQL Thrift/JDBC server
to connect with Cassandra. DataStax provides a closed-source driver that comes only with the
DSE version of Cassandra.

I would like to find out how many people are using the Spark SQL JDBC server + DSE Cassandra
combination. If you do use Spark SQL JDBC server + DSE, I would appreciate if you could share
your experience. For example, what kind of issues you have run into? How is the performance?
What reporting tools you are using?

Thank  you.

Mohammed


Mime
View raw message