Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id C4DCF95A5 for ; Sun, 19 Aug 2012 10:20:20 +0000 (UTC) Received: (qmail 66747 invoked by uid 500); 19 Aug 2012 10:20:18 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 66571 invoked by uid 500); 19 Aug 2012 10:20:17 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 66549 invoked by uid 99); 19 Aug 2012 10:20:16 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 19 Aug 2012 10:20:16 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=FSL_RCVD_USER,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of georg.koester@gmail.com designates 209.85.210.172 as permitted sender) Received: from [209.85.210.172] (HELO mail-iy0-f172.google.com) (209.85.210.172) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 19 Aug 2012 10:20:11 +0000 Received: by iabz21 with SMTP id z21so2097906iab.31 for ; Sun, 19 Aug 2012 03:19:50 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; bh=4OYjpjalnrJSOTI0HQEuNfYgTae+iaPbuQrQrGiveTc=; b=0eDZy2bkwfZmVjxL/KEXaDbrzM0gVs5MtAemfkQdHn/G8xf82HC8l8/mc8+SozlvLK sYErgfc+Mcz08AaEy+opCT+OExGLw9dsqnWmB9P0tDagwwwVW3KcsYslGBzYB4fM8NWP 3p+5cNdsLG5D0pQ9G3Hz49t0nTGFwQwrTYwQCk4d8PLhXlEA4pDR3AEfHfyNuS3T33E5 9Yo+R1V4AV6eWEMK8hrgWgRs0ahJz9tEsnSaksItHZPfI2UzHqMpXtgpf3Uz88TQVzmp Icg9YuU6qcuhJQpv5orj+G/VLlzvnJxJWKy/9fgn36XW8SCNWjEOxNX8I3AY5/ltMGnN YgLQ== Received: by 10.42.19.2 with SMTP id z2mr8505562ica.33.1345371590101; Sun, 19 Aug 2012 03:19:50 -0700 (PDT) MIME-Version: 1.0 Received: by 10.64.50.1 with HTTP; Sun, 19 Aug 2012 03:19:29 -0700 (PDT) In-Reply-To: References: From: =?UTF-8?Q?Georg_K=C3=B6ster?= Date: Sun, 19 Aug 2012 12:19:29 +0200 Message-ID: Subject: Re: composite table with cassandra without using cql3? To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=20cf3040ee5cb809c704c79bbb6a --20cf3040ee5cb809c704c79bbb6a Content-Type: text/plain; charset=UTF-8 Hi all, I had problems creating a table with composite keys with CQL 3 and accessing it via thrift. AFAIK the comparators weren't set up in a compatible way. Probably due to betaness of CQL 3. So I'm now creating and using CFs with Composite Columns exclusively via thrift/Astyanax. Pelops works too. Astyanax composite help: https://github.com/Netflix/astyanax/wiki/Examples - Search for Composite. Beware that the serializer currently doesn't find annotated fields if they are inherited. Cheers! Georg On Sat, Aug 18, 2012 at 1:29 AM, Ben Frank wrote: > Hi Dean, > I'm interested in this too, but I get a 404 with the link below, looks > like I can't see your nosqlORM project. > > -Ben > > > On Thu, Aug 2, 2012 at 9:04 AM, Hiller, Dean wrote: > >> For how to do it with astyanax, you can see here... >> >> Lines 310 and 335 >> >> >> https://github.com/deanhiller/nosqlORM/blob/indexing/input/javasrc/com/alva >> zan/orm/layer3/spi/db/cassandra/CassandraSession.java >> >> >> For how to do with thrift, you could look at astyanax. >> >> I use it on that project for indexing for the ORM layer we use(which is >> not listed on the cassandra ORM's page as of yet ;) ). >> >> Later, >> Dean >> >> >> On 8/2/12 9:50 AM, "Greg Fausak" wrote: >> >> >I've been using the cql3 to create a composite table. >> >Can I use the thrift interface to accomplish the >> >same thing? In other words, do I have to use cql 3 to >> >get a composite table type? (The same behavior as >> >multiple PRIMARY key columns). >> > >> >Thanks, >> >---greg >> >> > --20cf3040ee5cb809c704c79bbb6a Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi all,

I had problems creating a table with composite k= eys with CQL 3 and accessing it via thrift.

AFAIK = the comparators weren't set up in a compatible way. Probably due to bet= aness of CQL 3.

So I'm now creating and using CFs with Composite Co= lumns exclusively via thrift/Astyanax. Pelops works too.

Astyanax composite help:=C2=A0
https://github.com/Netflix/astyanax/wiki= /Examples - Search for Composite. Beware that the serializer currently = doesn't find annotated fields if they are inherited.

Cheers!
Georg

On Sat, Aug 18, 2012 at 1:29 AM, Ben Frank <= ben@airlust.com>= ; wrote:
Hi Dean,
=C2=A0 =C2=A0I'm interested= in this too, but I get a 404 with the link below, looks like I can't s= ee your nosqlORM project.

-Ben


On Thu, Aug 2, 2012 a= t 9:04 AM, Hiller, Dean <Dean.Hiller@nrel.gov> wrote:
For how to do it with astyanax, you can see = here...

Lines 310 and 335

https://github.com/deanhiller/nosqlORM/blob/indexing/input/javasrc= /com/alva
zan/orm/layer3/spi/db/cassandra/CassandraSession.java


For how to do with thrift, you could look at astyanax.

I use it on that project for indexing for the ORM layer we use(which is
not listed on the cassandra ORM's page as of yet ;) ).

Later,
Dean


On 8/2/12 9:50 AM, "Greg Fausak" <greg@named.com> wrote:

>I've been using the cql3 to create a composite table.
>Can I use the thrift interface to accomplish the
>same thing? =C2=A0In other words, do I have to use cql 3 to
>get a composite table type? (The same behavior as
>multiple PRIMARY key columns).
>
>Thanks,
>---greg



--20cf3040ee5cb809c704c79bbb6a--