Skip to main content
CezK
Silver ⭐️
February 18, 2020
Solved

HBase changing schema - adding a column / column familes

Hi,

 

I have large HBase table and would like to add a new column family with 1 column.

I know about "alter" which adds the to schema to all regions.

But it really means adding schema to region ?

Is it only change schema or rewrite data ? 

 

 

Regards,

Cezary

rakanchi
rakanchiAnswer
Gold ⭐️
February 27, 2020

Hello Cezary, 

 

hbase> alter helps to add/modify/delete column family. 

But it's not possible to rename existing column family and it will not re-write any data.

 

It is advisable to disable table and perform >alter and enable the table.

Also, if you modify properties like TTL, versions it will applicable for new writes and for existing data it will take effect only after >major_compact <table>

 

Hope that helps! 

2 replies

rakanchi
Gold ⭐️
rakanchiAnswer
Gold ⭐️
February 27, 2020

Hello Cezary, 

 

hbase> alter helps to add/modify/delete column family. 

But it's not possible to rename existing column family and it will not re-write any data.

 

It is advisable to disable table and perform >alter and enable the table.

Also, if you modify properties like TTL, versions it will applicable for new writes and for existing data it will take effect only after >major_compact <table>

 

Hope that helps! 

Translate
CezK
CezKAuthor
Silver ⭐️
February 27, 2020

Ok, thank ypu !

Translate