You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Ajay <aj...@gmail.com> on 2015/05/06 07:57:16 UTC
Hive support on Cassandra
Hi,
Does Apache Cassandra (not DSE) support Hive Integration?
I found couple of open source efforts but nothing is available currently.
Thanks
Ajay
Re: Hive support on Cassandra
Posted by Jens Rantil <je...@tink.se>.
Hi Ajay,
I just Googled your question and ended up here:
http://stackoverflow.com/q/11850186/260805 The only solution seem to be
Datastax Enterprise.
Cheers,
Jens
On Wed, May 6, 2015 at 7:57 AM, Ajay <aj...@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
>
--
Jens Rantil
Backend engineer
Tink AB
Email: jens.rantil@tink.se
Phone: +46 708 84 18 32
Web: www.tink.se
Facebook <https://www.facebook.com/#!/tink.se> Linkedin
<http://www.linkedin.com/company/2735919?trk=vsrp_companies_res_photo&trkInfo=VSRPsearchId%3A1057023381369207406670%2CVSRPtargetId%3A2735919%2CVSRPcmpt%3Aprimary>
Twitter <https://twitter.com/tink>
Re: Hive support on Cassandra
Posted by Jonathan Haddad <jo...@jonhaddad.com>.
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 <aj...@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 <ad...@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 <li...@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 <aj...@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>*
>>
>
>
Re: Hive support on Cassandra
Posted by Ajay <aj...@gmail.com>.
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 <ad...@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 <li...@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 <aj...@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>*
>
Re: Hive support on Cassandra
Posted by Andres de la Peña <ad...@stratio.com>.
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 <li...@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 <aj...@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>*
Re: Hive support on Cassandra
Posted by li...@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 <aj...@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