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 6F2CD180DD for ; Fri, 14 Aug 2015 18:07:05 +0000 (UTC) Received: (qmail 7166 invoked by uid 500); 14 Aug 2015 18:07:01 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 7125 invoked by uid 500); 14 Aug 2015 18:07:01 -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 7110 invoked by uid 99); 14 Aug 2015 18:07:01 -0000 Received: from Unknown (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 14 Aug 2015 18:07:01 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 46F2F1AA158 for ; Fri, 14 Aug 2015 18:07:01 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 3.01 X-Spam-Level: *** X-Spam-Status: No, score=3.01 tagged_above=-999 required=6.31 tests=[HTML_MESSAGE=3, SPF_PASS=-0.001, T_REMOTE_IMAGE=0.01, URIBL_BLOCKED=0.001] autolearn=disabled Received: from mx1-eu-west.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id Pw29TiCxHFGq for ; Fri, 14 Aug 2015 18:06:53 +0000 (UTC) Received: from mail.zepower.com (mail.zepower.com [206.172.31.143]) by mx1-eu-west.apache.org (ASF Mail Server at mx1-eu-west.apache.org) with ESMTP id 9DA01253E7 for ; Fri, 14 Aug 2015 18:06:52 +0000 (UTC) X-ASG-Debug-ID: 1439575604-05572a10585e4070001-f7dORa Received: from mail.zepower.com (exchange-01b.zepower.com [10.0.6.22]) by mail.zepower.com with ESMTP id 53MdPtdfCrPrszrM for ; Fri, 14 Aug 2015 11:06:44 -0700 (PDT) X-Barracuda-Envelope-From: Ahmed.Ferdous@ze.com Received: from EXCHANGE-01A.zepower.com ([fe80::b523:7585:4a1a:ff2e]) by EXCHANGE-01B.zepower.com ([fe80::b033:8eac:6c34:575d%20]) with mapi id 14.03.0123.003; Fri, 14 Aug 2015 11:06:44 -0700 From: "Ahmed Ferdous" To: "user@cassandra.apache.org" Subject: Configuring Cassandra to limit number of columns to read Thread-Topic: Configuring Cassandra to limit number of columns to read X-ASG-Orig-Subj: Configuring Cassandra to limit number of columns to read Thread-Index: AdDWu2YdGUj2ZSAhQXKvu6V/lOQ2rA== Date: Fri, 14 Aug 2015 18:06:43 +0000 Message-ID: <4207B03C4CE8C244A7BD522A6C140D53E1EB40@EXCHANGE-01A.zepower.com> Accept-Language: en-CA, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.0.6.33] Content-Type: multipart/alternative; boundary="_000_4207B03C4CE8C244A7BD522A6C140D53E1EB40EXCHANGE01Azepowe_" MIME-Version: 1.0 X-Barracuda-Connect: exchange-01b.zepower.com[10.0.6.22] X-Barracuda-Start-Time: 1439575604 X-Barracuda-URL: https://10.0.6.31:443/cgi-mod/mark.cgi X-Virus-Scanned: by bsmtpd at zepower.com X-Barracuda-BRTS-Status: 1 X-Barracuda-Spam-Score: 0.00 X-Barracuda-Spam-Status: No, SCORE=0.00 using global scores of TAG_LEVEL=1000.0 QUARANTINE_LEVEL=1000.0 KILL_LEVEL=6.0 tests=HTML_MESSAGE X-Barracuda-Spam-Report: Code version 3.2, rules version 3.2.3.21599 Rule breakdown below pts rule name description ---- ---------------------- -------------------------------------------------- 0.00 HTML_MESSAGE BODY: HTML included in message --_000_4207B03C4CE8C244A7BD522A6C140D53E1EB40EXCHANGE01Azepowe_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi Guys, We have designed a table to have rows with large number of columns (more th= an 250k). One of my colleagues, mistakenly ran a select on the and that ca= used the nodes to go out of memory. I was just wondering if there are ways = to configure Cassandra 1. To limit number of columns that can be read 2. To= gracefully reject a read request if it appears to be consuming a lot of me= mory. Otherwise, we are leaving too much open to human mistakes. Cheers, Ahmed ________________________________ Ahmed Ferdous Systems Architect Corporate: 604-244-1469 Email: Ahmed.Ferdous@ze.com ________________________________ [2015 ZEMA User Forum] ZE PowerGroup Inc. 130 - 5920 No. Two Road, Richmond, BC, Canada V7C 4R9 Web: www.ze.com North America: 1-866-944-1469 Europe: 0-800-520-0193 Singapore: = 800-130-1609 ________________________________ ZE PowerGroup Inc. Confidentiality Notice: This e-mail and any attachments = are for the exclusive and confidential use of the intended recipient and co= ntain confidential and proprietary information. If you are not the intended= recipient, be aware that any reading, distribution, disclosure, copying, p= rinting or taking action in reliance upon this e-mail is prohibited. If you= have received this in error, please notify us immediately by replying to t= his e-mail and promptly delete this e-mail and its attachments from your co= mputer system. --_000_4207B03C4CE8C244A7BD522A6C140D53E1EB40EXCHANGE01Azepowe_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi Guys,

 

We have designed a table to have rows with large num= ber of columns (more than 250k). One of my colleagues, mistakenly ran a sel= ect on the  and that caused the nodes to go out of memory. I was just = wondering if there are ways to configure Cassandra 1. To limit number of columns that can be read 2. To gracefully = reject a read request if it appears to be consuming a lot of memory. Otherw= ise, we are leaving too much open to human mistakes.

 

Cheers,

 

Ahmed

 

Ahmed Ferdous
Systems Architect
Corporate: 604-244-1469   &nb= sp; Email: Ahmed.Ferdous@ze.com

3D"2015

ZE PowerGroup Inc.
130 - 5920 No. Two Road, Richmond, BC, Canad= a V7C 4R9     Web: w= ww.ze.com
North America: 1-866-944-1469      Europe: 0-= 800-520-0193       Singapore: 800-130-16= 09

ZE PowerGroup Inc. Confidentiality Notice: = This e-mail and any attachments are for the exclusive and confidential use = of the intended recipient and contain confidential and proprietary informat= ion. If you are not the intended recipient, be aware that any reading, distribution, disclosure, copying, printing or = taking action in reliance upon this e-mail is prohibited. If you have recei= ved this in error, please notify us immediately by replying to this e-mail = and promptly delete this e-mail and its attachments from your computer system.


--_000_4207B03C4CE8C244A7BD522A6C140D53E1EB40EXCHANGE01Azepowe_--