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> wrote: > 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/> > > >
