Way to alter a column datatype(INTEGER to BIGINT) in phoenix tables?

2016-02-22 Thread Sandeep Nemuri
Hi All, We have a situation where we have to change the datatype of the existing column of a phoenix table from INTEGER to BIGINT. is there a way to alter the datatype without loosing the existing data? Have tried to take the snapshot of hbase table and restored it in a new pheonix table with new

Re: Way to alter a column datatype(INTEGER to BIGINT) in phoenix tables?

2016-02-22 Thread James Heather
If you're able to turn off write access to the table from elsewhere temporarily, you could always SELECT the values and store them somewhere else (e.g., a new table) for the moment, drop and recreate the column, and then UPSERT them back in. It would be nice to think there's a better way, though.

Re: Way to alter a column datatype(INTEGER to BIGINT) in phoenix tables?

2016-02-22 Thread Sandeep Nemuri
Thanks for the response James. We can turn off the writes id required, But the table has ~100B records. Selecting the values and upserting them in new table will be challenging with these many records. ᐧ On Mon, Feb 22, 2016 at 2:42 PM, James Heather wrote: > If you're able to turn off write