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 5D7C3102B7 for ; Tue, 24 Sep 2013 12:52:40 +0000 (UTC) Received: (qmail 93783 invoked by uid 500); 24 Sep 2013 12:38:28 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 93491 invoked by uid 500); 24 Sep 2013 12:37:49 -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 93456 invoked by uid 99); 24 Sep 2013 12:37:43 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 24 Sep 2013 12:37:43 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [207.46.163.243] (HELO na01-bl2-obe.outbound.protection.outlook.com) (207.46.163.243) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 24 Sep 2013 12:37:37 +0000 Received: from CO1PR07CA018.namprd07.prod.outlook.com (10.141.49.48) by BLUPR07MB003.namprd07.prod.outlook.com (10.255.209.37) with Microsoft SMTP Server (TLS) id 15.0.775.9; Tue, 24 Sep 2013 12:36:57 +0000 Received: from BL2FFO11FD007.protection.gbl (2a01:111:f400:7c09::130) by CO1PR07CA018.outlook.office365.com (2a01:111:e400:102f::48) with Microsoft SMTP Server (TLS) id 15.0.775.9 via Frontend Transport; Tue, 24 Sep 2013 12:36:56 +0000 Received: from XEDGEB.nrel.gov (192.174.58.133) by BL2FFO11FD007.mail.protection.outlook.com (10.173.161.3) with Microsoft SMTP Server (TLS) id 15.0.775.5 via Frontend Transport; Tue, 24 Sep 2013 12:36:55 +0000 Received: from XHUBA.nrel.gov (10.20.4.58) by XEDGEB.nrel.gov (192.174.58.133) with Microsoft SMTP Server (TLS) id 8.3.298.1; Tue, 24 Sep 2013 06:36:52 -0600 Received: from MAILBOX2.nrel.gov ([fe80::48b0:b121:8465:5e5]) by XHUBA.nrel.gov ([::1]) with mapi; Tue, 24 Sep 2013 06:36:54 -0600 From: "Hiller, Dean" To: "user@cassandra.apache.org" Date: Tue, 24 Sep 2013 06:36:53 -0600 Subject: =?Windows-1252?Q?is_this_correct,_thrift_unportable_to_CQL3=8A.?= Thread-Topic: =?Windows-1252?Q?is_this_correct,_thrift_unportable_to_CQL3=8A.?= Thread-Index: Ac65Ir/KFzLE2ylmRm6V1E/C/Yp7eQ== Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: Microsoft-MacOutlook/14.3.7.130812 acceptlanguage: en-US Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Forefront-Antispam-Report: CIP:192.174.58.133;CTRY:US;IPV:NLI;EFV:NLI;SFV:NSPM;SFS:(189002)(199002)(164054003)(74502001)(83072001)(47446002)(65816001)(80022001)(53416003)(15202345003)(81816001)(74876001)(74662001)(15395725003)(81686001)(16796002)(31966008)(74706001)(44976005)(46102001)(4396001)(51856001)(6806004)(54356001)(53806001)(47736001)(49866001)(50986001)(47976001)(50466002)(83322001)(19580395003)(77096001)(56816003)(15975445006)(80976001)(74366001)(23746002)(79102001)(81542001)(69226001)(20776003)(63696002)(83506001)(47776003)(77982001)(36756003)(59766001)(76176001)(76786001)(56776001)(76482001)(54316002)(81342001)(76796001);DIR:OUT;SFP:;SCL:1;SRVR:BLUPR07MB003;H:XEDGEB.nrel.gov;CLIP:192.174.58.133;FPR:;RD:xedgeb.nrel.gov;MX:1;A:1;LANG:en; X-Forefront-PRVS: 09796A1B83 X-OriginatorOrg: nrel.gov X-Virus-Checked: Checked by ClamAV on apache.org Many applications in thrift use the wide row with composite column name and= as an example, let's say golf score for instance and we end up with golf s= core : pk like so null : pk56 null : pk45 89 : pk90 89: pk87 90: pk101 95: pk17 Notice that there are some who do not have a golf score(zero would not quit= e make sense and would be interpreted as a golf score). I am hearing from = this post if they are correct that this is not portable to CQL3??? Is this= true? http://stackoverflow.com/questions/18963248/how-can-i-have-null-col= umn-value-for-a-composite-key-column-in-cql3 (This sounds like a major deficit to me as the wide row now can only be use= d where actual values exist?????). Is it possible to port this pattern to = CQL3? Thanks, Dean