Conversion from Row store to Column store

[former_member208246]

Hi,

I have already created two tables as Customer and Sales in schemas. I have manually generated few records in to the tables by SQL queries.

Two tables with Customer and Sales are generated as the Row store initially. Now i have to generate these two tables as the Column store without dropping the tables. I have to edit the table definition and make the table type from the row store to the Column store.

I Export the SQL queries and renamed the existing tablename by placing it as the Column store.

Is it possible to edit the table type within the existing table and execute them?

Thanks and regards

Sanjay

[rindia]

Hi Sanjay,

Yes we can change the table type from ROW to COLUMN.

Execute the below query:

ALTER TABLE <schema_name>.<table_name> ALTER TYPE COLUMN;

[lucas_kiesow]

Hello Sanjay,

be aware that this conversion can be very resource-intensive when dealing with large tables. For your small tables, it should be fine.

If you use a CREATE COLUMN TABLE, you can create tables in the Column Store.

Regards

Lucas

[former_member208246]

Thanks Raj and Lucas. Issue is resolved.

Regards

Sanjay