Support Questions
Find answers, ask questions, and share your expertise

HBase changing schema - adding a column / column familes

Solved Go to solution

HBase changing schema - adding a column / column familes

New Contributor

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: HBase changing schema - adding a column / column familes

Cloudera Employee

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! 

View solution in original post

2 REPLIES 2
Highlighted

Re: HBase changing schema - adding a column / column familes

Cloudera Employee

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! 

View solution in original post

Highlighted

Re: HBase changing schema - adding a column / column familes

New Contributor

Ok, thank ypu !