Support Blog | Page 4 | DataStax Academy: Free Cassandra Tutorials and Training

Welome to the DataStax Support Blog. Here you will find articles that cover the entire range of topics related to using DataStax Products, tips on best practices while using DataStax products, as well as insights on how to make your experience with Support as efficient and pleasant as possible.

Be sure to check out our hours of free training and downloads on DataStax Academy . For industry topics and general DataStax news, head over to our company blog or check out the DataStax developer blog for deep dives into a wide range of subject matter.

September 13, 2017 • By: Adam Hattrell

I joined DataStax when our European offices opened.  Over the last few years, I have visited and spoken to a large number of customers and there are a number of common questions that seem to come up as an aside to the main topic of conversation.

On the basis that for every person that asks, four others wanted to - I thought I might share the common answers here!

August 31, 2017 • By: Sean Fuller

For a long time we have all felt that the backup speed through OpsCenter to Amazon-S3 has been “fine” or “to be expected with that size data”, however, we were put to task recently and had to come up with a better solution to handle much bigger data. Clusters are getting bigger, Node counts are increasing and Big Data is growing exponentially! We had to keep up with this growing trend and make backups work better, faster, BIGGER.

But how?

August 30, 2017 • By: Sucwinder Bassi

I like to use the analogy of gold mining when thinking about obtaining information from a diagnostic tarball. That's mainly because a diagnostic tarball is a gold mine of information and this blog article will hopefully provide some useful insight into the information available. So grab your hard hat, pick axe, torch and get ready to strike it rich with information.

August 22, 2017 • By: Jose Martinez

In the relational world, The Create Table As Select aka CTAS is one of the most important/handy features available. CTAS is the simplest and fastest way to create a copy of a table. Every major relational database supports CTAS. Its origins come from the INSERT SELECT from SQL92 P.388.

A common example is:

INSERT INTO phone_book2
SELECT *
FROM   phone_book
WHERE  name IN ('John Doe', 'Peter Doe');

  A prerequisite to running this command is that table phone_book2 has to be created beforehand. CTAS was later introduced which made possible to execute a statement and dump it's results to a new table in a single command:

CREATE TABLE phone_book2
AS
SELECT *
FROM   phone_book
WHERE  name IN ('John Doe', 'Peter Doe');

Although it has been discussed in CASSANDRA-8234, Apache Cassandra does not support this operation as of yet. DSE Supports CTAS from SparkSQL, otherwise it has to be done in a multiple step fashion. In this post, we will take a look at several approaches to this operation.

August 15, 2017 • By: Mark Curtis

First it's there, then its not, what's going on? Did someone or something delete my data? One of the more common scenarios we help customers with is understand why and where data that was supposed to have been written into the cluster has gone. It might sound concerning but when you understand the why and how then you'll see how it actually makes sense and why people use the term "eventual consistency"