commentsBy Kamil Bajda-Pawlikowski, CTO of Starburst Data.Initially developed by Facebook, Presto is an open source, distributed ANSI SQL query engine that delivers fast analytic queries against vario...

WhyDataGripEnjoy workingwith databasesMeet DataGrip, our new database IDE that is tailored to suit the specific needs of professional SQL developers.Intelligent query consoleAllows you to execute quer...

This is second article in the series of Cassandra Data Modeling best practices for efficient Spark SQL Joins. You can find previous posts here  and here. Dimensional data modeling principles are still...

Apache Cassandra and Apache Spark product integration is one of the emerging trends in big data world today. Together, these two products can offer several advantages. Much has already been said about...

Similar to SQL performance Spark SQL performance also depends on several factors. Hardware resources like the size of your compute resources,  network bandwidth and your data model, application design...

Vote count: 0 Is there a way to delete some records based on a select query? I have this query, Select min(id) from ID having count(*)>1 whic...

Spark SQL is awesome.  It allows you to query any Resilient Distributed Dataset (RDD) using SQL (including data stored in Cassandra!).First thing to do is to create a SQLContext from your SparkContext...

Cassandra Query LanguageCQL vs SQLWhen Apache Cassandra was originally released, it featured a command line interface for dealing with thrift. Manipulating data this way was cumbersome and required le...