If you're willing to do the data type conversion in insert and retrieval,
the you could use blobs as a sort of "adaptive length int" AFAIK

On Tue, Mar 6, 2018 at 6:02 AM, onmstester onmstester <onmstes...@zoho.com>

> 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 <https://www.zoho.com/mail/>

Reply via email to