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 E2BCE17733 for ; Tue, 12 May 2015 23:16:39 +0000 (UTC) Received: (qmail 46189 invoked by uid 500); 12 May 2015 23:16:37 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 46142 invoked by uid 500); 12 May 2015 23:16:37 -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 46132 invoked by uid 99); 12 May 2015 23:16:37 -0000 Received: from Unknown (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 12 May 2015 23:16:37 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id E1D6E18294F for ; Tue, 12 May 2015 23:16:36 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.879 X-Spam-Level: ** X-Spam-Status: No, score=2.879 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=3, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-us-east.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id RfWf8pknqmuU for ; Tue, 12 May 2015 23:16:36 +0000 (UTC) Received: from mail-oi0-f45.google.com (mail-oi0-f45.google.com [209.85.218.45]) by mx1-us-east.apache.org (ASF Mail Server at mx1-us-east.apache.org) with ESMTPS id BC0C2474CA for ; Tue, 12 May 2015 23:16:35 +0000 (UTC) Received: by oica37 with SMTP id a37so18302001oic.0 for ; Tue, 12 May 2015 16:16:28 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:from:date:message-id:subject:to:content-type; bh=GgQcWTOrsqmgB/kuMCgl/2m7QUyTuFXOBXDI7Ux69Z4=; b=UCQv8lECQi2f11Qa7zb75OnHVZMJtvKKI0JFyUZx6yNnv+y60DXQdXApZP0AlMYPd1 uNMgL2mJUCC4xfdnJKYu7bWBd1WycOFZ9n9+oJP7eWw7kHWC3ROVFOijrqr8MRXXgiC+ x2Wv9lqc0uWDOarHRT4ACH19fGRYbTLVvnxobpHIKDZfGC90/TRqyK00LoLmLGNu42YI y5Tu0u2Ge0qoVSn7LIxa60OxXoCxijah3K9s0B+bnjsV0yjgm/N9YJB1IB5ApUZEKRi1 xrz0etzLqCrro5diZcR9xcgZMXFNfKcrg82cbKHaKmxT5mJbETwfyObrCt6DAXXxsByM nZuQ== X-Received: by 10.60.82.67 with SMTP id g3mr13709255oey.29.1431472588929; Tue, 12 May 2015 16:16:28 -0700 (PDT) MIME-Version: 1.0 Received: by 10.202.175.17 with HTTP; Tue, 12 May 2015 16:16:08 -0700 (PDT) From: Sunil Ghai Date: Wed, 13 May 2015 04:46:08 +0530 Message-ID: Subject: dynamic models (data modelling) To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=047d7b676d522b5a7c0515eaafdf --047d7b676d522b5a7c0515eaafdf Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi, I=E2=80=99ve a query regarding data modelling in Cassandra, would appreciat= e some suggestions. We=E2=80=99re trying to build a multi-tenant application where we expect da= ta structure to be defined by the users. A user may define a data source, number of fields, their data types, ordering etc. and then upload data based on this structure. How can we design such an application on top of Cassandra since it doesn=E2=80=99t support a list of mixed data types. The = current collection types are Map (same types)/Set/List (same type). Moreover, is it possible to query data based on the user defined entities? Presently, we're thinking of maintaining a single Map and convert all the values into blob before storing. It doesn't definitely allow to query (only with CONTAINS clause), but helps to structure storage problem. Any other potential methods? Thanks! --047d7b676d522b5a7c0515eaafdf Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

Hi,

I=E2=80=99ve a query re= garding data modelling in Cassandra, would appreciate some suggestions.

=

We=E2=80=99re trying to build a multi-tenant application wher= e we expect data structure to be defined by the users. A user may define a = data source, number of fields, their data types, ordering etc. and then upl= oad data based on this structure. How can we design such an application on = top of Cassandra since it doesn=E2=80=99t support a list of mixed data type= s. The current collection types are Map (same types)/Set/List (same type). = Moreover, is it possible to query data based on the user defined entities?<= /p>

Presently, we're thinking of maintaining a single Map = and convert all the values into blob before storing. It doesn't definit= ely allow to query (only with CONTAINS clause), but helps to structure stor= age problem. Any other potential methods?

Thanks!

--047d7b676d522b5a7c0515eaafdf--