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 8FAB9DF47 for ; Sat, 3 Nov 2012 19:25:31 +0000 (UTC) Received: (qmail 32328 invoked by uid 500); 3 Nov 2012 19:25:29 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 32301 invoked by uid 500); 3 Nov 2012 19:25:29 -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 32292 invoked by uid 99); 3 Nov 2012 19:25:29 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 03 Nov 2012 19:25:29 +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 (nike.apache.org: domain of sylvain@datastax.com designates 209.85.212.44 as permitted sender) Received: from [209.85.212.44] (HELO mail-vb0-f44.google.com) (209.85.212.44) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 03 Nov 2012 19:25:22 +0000 Received: by mail-vb0-f44.google.com with SMTP id fc26so5315635vbb.31 for ; Sat, 03 Nov 2012 12:25:01 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type:x-gm-message-state; bh=cmR6AKKNDLBCSgqz+MA/pnJe16JrRKHvv2A4dxf3N88=; b=YKMXNtwBzkbfQKXw5lauMIdb+K4g+vVAs7jil0hmqWSxPUOmSsigxxx2inEhglMWZa 7mc2uyOnfXt0cM4+FBJP6F1tdmijC4Yhmvm18lXncQoMACLxJecZet38j5c7dwCd6uPs 8BvQ9ou5pqGl9u2RoBqHHqPWvRKomfGbAUmAwxJh1emfuPn1NahuIJBxWMlmbzyB+gyP XqT1GUPs+wAxtEzHAuM/r5mTe5xXw4wChjKrAgZh3KoD+qPpchlAUHnlaFo1BURukAwJ rMBzv9iV/Akv9WAV6KwbLeaGcSjkKgTQDv8LRtpGNEFS+AKrlFiupOI9pGP+MPyw7wsd FPLA== MIME-Version: 1.0 Received: by 10.220.210.193 with SMTP id gl1mr5055912vcb.58.1351970701810; Sat, 03 Nov 2012 12:25:01 -0700 (PDT) Received: by 10.58.249.135 with HTTP; Sat, 3 Nov 2012 12:25:01 -0700 (PDT) In-Reply-To: References: Date: Sat, 3 Nov 2012 20:25:01 +0100 Message-ID: Subject: Re: Insert via CQL From: Sylvain Lebresne To: user@cassandra.apache.org Content-Type: text/plain; charset=ISO-8859-1 X-Gm-Message-State: ALoCoQmAeCMMWWjKkCSJ981GsNDHI3fN6gmLv/SKoFnjlWsbdZsfPjB5u9EzkMNOCGowhC+qm9/c X-Virus-Checked: Checked by ClamAV on apache.org On Sat, Nov 3, 2012 at 1:40 AM, Eric Evans wrote: > On Fri, Nov 2, 2012 at 8:09 PM, Vivek Mishra wrote: >> any idea, how to insert into a column family for a column of type "blob" via >> cql query? > > Yes, most of them involve binary data that is hex-encoded ascii. :) Unless you are using prepared statement. In which case you just send you blob as binary. But for non-prepared queries, you do have to hex-encode indeed (meaning that if you do use blobs, especially largish one, I highly recommend using prepared statements). -- Sylvain