You may find Spark to be useful. You can do SQL, but also use Python, Scala or Java.
I wrote a post last week on getting started with DataFrames & Spark, which you can register as tables & query using Hive compatible SQL: http://rustyrazorblade.com/2015/05/on-the-bleeding-edge-pyspark-dataframes-and-cassandra/ On Thu, May 7, 2015 at 10:07 AM Ajay <ajay.ga...@gmail.com> wrote: > Thanks everyone. > > Basically we are looking at Hive because it supports advanced queries (CQL > is limited to the data model). > > Does Stratio supports similar to Hive? > > Thanks > Ajay > > > On Thu, May 7, 2015 at 10:33 PM, Andres de la Peña <adelap...@stratio.com> > wrote: > >> You may also find interesting https://github.com/Stratio/crossdata. This >> project provides batch and streaming capabilities for Cassandra and others >> databases though a SQL-like language. >> >> Disclaimer: I am an employee of Stratio >> >> 2015-05-07 17:29 GMT+02:00 <l...@airstreamcomm.net>: >> >>> You might also look at Apache Drill, which has support (I think alpha) >>> for ANSI SQL queries against Cassandra if that would suit your needs. >>> >>> >>> > On May 6, 2015, at 12:57 AM, Ajay <ajay.ga...@gmail.com> wrote: >>> > >>> > Hi, >>> > >>> > Does Apache Cassandra (not DSE) support Hive Integration? >>> > >>> > I found couple of open source efforts but nothing is available >>> currently. >>> > >>> > Thanks >>> > Ajay >>> >>> >>> >> >> >> -- >> >> Andrés de la Peña >> >> >> <http://www.stratio.com/> >> Avenida de Europa, 26. Ática 5. 3ª Planta >> 28224 Pozuelo de Alarcón, Madrid >> Tel: +34 91 352 59 42 // *@stratiobd <https://twitter.com/StratioBD>* >> > >
