Few! You saved my life, thanks! For my understanding: When creating a new table, is bigint or varint a better choice for storing (up to) 64bit ints? Is there a difference in performance?
2017-01-11 9:39 GMT+01:00 Tom van der Woerdt <tom.vanderwoe...@booking.com>: > Hi Benjamin, > > bigint and int have incompatible serialization types, so that won't work. > However, changing to 'varint' will work fine. > > Hope that helps. > > Tom > > > > On Wed, Jan 11, 2017 at 9:21 AM, Benjamin Roth <benjamin.r...@jaumo.com> > wrote: > >> Hi there, >> >> Does anyone know if there is a hack to change a "int" to a "bigint" in a >> primary key? >> I recognized very late, I took the wrong type and our production DB >> already contains billions of records :( >> Is there maybe a hack for it, because int and bigint are similar types or >> does the SSTable serialization and maybe the token generation require the >> tables to be completely reread+rewritten? >> >> -- >> Benjamin Roth >> Prokurist >> >> Jaumo GmbH · www.jaumo.com >> Wehrstraße 46 · 73035 Göppingen · Germany >> Phone +49 7161 304880-6 <+49%207161%203048806> · Fax +49 7161 304880-1 >> <+49%207161%203048801> >> AG Ulm · HRB 731058 · Managing Director: Jens Kammerer >> > > -- Benjamin Roth Prokurist Jaumo GmbH · www.jaumo.com Wehrstraße 46 · 73035 Göppingen · Germany Phone +49 7161 304880-6 · Fax +49 7161 304880-1 AG Ulm · HRB 731058 · Managing Director: Jens Kammerer
