From user-return-60186-archive-asf-public=cust-asf.ponee.io@cassandra.apache.org Tue Mar 6 13:03:07 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id 3491A180652 for ; Tue, 6 Mar 2018 13:03:07 +0100 (CET) Received: (qmail 23378 invoked by uid 500); 6 Mar 2018 12:03:05 -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 23368 invoked by uid 99); 6 Mar 2018 12:03:05 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 06 Mar 2018 12:03:05 +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 D7F2D1A048A for ; Tue, 6 Mar 2018 12:03:04 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.889 X-Spam-Level: * X-Spam-Status: No, score=1.889 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_NONE=-0.0001, SPF_PASS=-0.001, T_RP_MATCHES_RCVD=-0.01] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); domainkeys=pass (768-bit key) header.from=onmstester@zoho.com header.d=zoho.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id 2K5OvIaVhV2N for ; Tue, 6 Mar 2018 12:03:00 +0000 (UTC) Received: from sender-pp-092.zoho.com (sender-pp-092.zoho.com [135.84.80.237]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id A506F5F571 for ; Tue, 6 Mar 2018 12:02:59 +0000 (UTC) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=zapps768; d=zoho.com; h=date:from:to:message-id:in-reply-to:subject:mime-version:content-type:user-agent; b=vfsNnU0WxUnV/BXBRN6zPtcvEpemkw5jNI0ZO2gPKzGypNoGM0UAlAs8KWj/6x4WQwEddbBdae09 e+8lj9Qkwy4SzVVz6K+vICR4EaKEqrHLq4amFMVsbs6eRgRj6wdL Received: from mail.zoho.com by mx.zohomail.com with SMTP id 1520337771402363.3050671929665; Tue, 6 Mar 2018 04:02:51 -0800 (PST) Received: from [23.239.17.132] by mail.zoho.com with HTTP;Tue, 6 Mar 2018 04:02:51 -0800 (PST) Date: Tue, 06 Mar 2018 15:32:51 +0330 From: onmstester onmstester To: "user" Message-Id: <161fb315b88.fbe1f2d717524.3498832611654948446@zoho.com> In-Reply-To: Subject: data types storage saving MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_43964_1662630052.1520337771400" X-Priority: Medium User-Agent: Zoho Mail X-Mailer: Zoho Mail ------=_Part_43964_1662630052.1520337771400 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 7bit I'm using int data type for one of my columns but for 99.99...% its data never would be > 65K, Should i change it to smallint (It would save some Gigabytes disks in a few months) or Cassandra Compression would take care of it in storage? What about blob data type ? Isn't better to use it in such cases? could i alter column type from smallInt to int in future if needed? Sent using Zoho Mail ------=_Part_43964_1662630052.1520337771400 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: 7bit
I'm using int data type for one of my columns but for 99.99...% its data never would be > 65K, Should i change it to smallint (It would save some Gigabytes disks in a few months) or Cassandra Compression would take care of it in storage? 
What about blob data type ? Isn't  better to use it in such cases? could i alter column type from smallInt to int in future if needed?

Sent using Zoho Mail



------=_Part_43964_1662630052.1520337771400--