Switch between Row Store and Column Store

[#1]

Hi Gurus,

It is said that HANA provides this flexibility of switching from Row Store to Column store as a table property anytime an user wants. But what I have noticed is that this feature is disabled whenever I open a table definition in HANA studio.

Is this feature disabled due to some missing privileges or something else.

Navigation: Select a HANA system in studio --> Select a schema containing some tables --> select a table and choose the option "open table definition" from the context menu. Top right corner there is a field which is disabled and reads Column store. No option to switch it back to Row Store.

Best Regards,

Chandan

[mathsantos · Accepted solution]

Hello Chandan,

You can switch the storage type of the table from COLUMN to ROW with:

ALTER TABLE <your_table_name> ALTER TYPE ROW

You can also switch the storage type of the table from ROW to COLUMN with:

ALTER TABLE <your_table_name> ALTER TYPE COLUMN

Best Regards,

Matheus M. Santos

[Former Member]

Hi Chandan,

You can preform the switch using ALTER sql statements as mentioned in the following message.

http://scn.sap.com/thread/2089151

Thanks,

Sharan