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
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.
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