Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id A04D3200B4B for ; Thu, 7 Jul 2016 02:39:40 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 9EFDF160A73; Thu, 7 Jul 2016 00:39:40 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id E2107160A64 for ; Thu, 7 Jul 2016 02:39:39 +0200 (CEST) Received: (qmail 79380 invoked by uid 500); 7 Jul 2016 00:39:38 -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 79370 invoked by uid 99); 7 Jul 2016 00:39:37 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 07 Jul 2016 00:39:37 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 71551CA87A for ; Thu, 7 Jul 2016 00:39:37 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.179 X-Spam-Level: * X-Spam-Status: No, score=1.179 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd1-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id M3mv1XcOR7O2 for ; Thu, 7 Jul 2016 00:39:36 +0000 (UTC) Received: from mail-it0-f50.google.com (mail-it0-f50.google.com [209.85.214.50]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 1255F5FBBD for ; Thu, 7 Jul 2016 00:39:36 +0000 (UTC) Received: by mail-it0-f50.google.com with SMTP id f6so9006140ith.0 for ; Wed, 06 Jul 2016 17:39:36 -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; bh=wm+PEgWa1BpwWuSYBFLZnUyKO3BpXr/Gp5zB74xZLvM=; b=pKOGSk/Kyia3v28K+sWMWiXt0zIpKEE1kmu7zqGqqvZQPKYiX0SR+ClxLK7u20xYiX aUTa4e1laLtuF6sPwL5LJz1vCNht3GA3R40eHqjQZnpT0/h/oLIaZldk0I20VlR4qiCI 6S4qd6R838lDQbsoiKIJvjuQCUsrOFfYZvVhY5KeTn7H2mN3ZZ1el4I+bOhm05Q3maNb /jRoqhI0GNGi9x/VoFknq57WXZJGTT00IZM89JpfNShAo6LIsKs4sAewB41gniTNwl/4 uUh4+oszGrHHnVPM76AtcPJfVPXDnEEhIOcM4ub0BfgvietDkRn9QSoVazuiuXOwo2zg HdFQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=wm+PEgWa1BpwWuSYBFLZnUyKO3BpXr/Gp5zB74xZLvM=; b=kEMyq+8al64ZQUxeroEfEKoOGxhj743V2MWkoDocQAjXuxErVKn9441tN84kqLnkBS ChseqD5vlg3GXJPpT2BtvglWLGCryVfg4fEs9vROvql+S8L6/G0TgRjB2TylkaN4mFwF n7dtEyt749hMWW3Tg6WJ6WoPsFA7IfF9uwJDm1u0Jafn6ZVXbvMEeg1Nq61UCVMEl9EF D87IT7sXVm8UzqMCK3TDG2e5h60dbkax5orV5WCAU+V58f+G6tu0Ka9TXfhJS0+MjihE 8TGHWoyHYVvt/GTy68XSITZ2qV1wjOQa/J69rf88+ZmFRPmorksJV/J7ExKHk03TU984 lehw== X-Gm-Message-State: ALyK8tJJCiUd2/U/UHiAa9eo2xxN9fEVOUq+CaNHQxESoy5yk1DGm2UpHVaefzzsTP6Y1k3srT0txSxO5PT1yw== X-Received: by 10.36.7.15 with SMTP id f15mr21420992itf.39.1467851974768; Wed, 06 Jul 2016 17:39:34 -0700 (PDT) MIME-Version: 1.0 Received: by 10.107.57.131 with HTTP; Wed, 6 Jul 2016 17:39:34 -0700 (PDT) From: Sungju Hong Date: Thu, 7 Jul 2016 09:39:34 +0900 Message-ID: Subject: Can't get performance for scanning the column that is not row key. To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=001a113f7ed089fcb3053700ebec archived-at: Thu, 07 Jul 2016 00:39:40 -0000 --001a113f7ed089fcb3053700ebec Content-Type: text/plain; charset=UTF-8 Hello, I have cassandra 1.2 and about fifty nodes. I sometime meet requirements for scanning the column that is not row key fast. I know that secondary index doesn't help. someone advised to read sstables directly. is it helpful? I will appreciate for any idea handling this topic. Thanks. --001a113f7ed089fcb3053700ebec Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hello,

I have cassan= dra 1.2 and about fifty nodes.

I sometime meet requirements fo= r scanning the column that is not row key fast.
I know that second= ary index doesn't help.

someone advised to read sstab= les directly. is it helpful?

I will appreciate for= any idea handling this topic.

Thanks.


--001a113f7ed089fcb3053700ebec--