Converting a Column store table to row store in SAP HANA

To convert a Column store table to row store, you can use the following SQL statement −

Alter table Table_Name row;

John SAP

Published on 21-Feb-2018 18:33:26

• Related Questions & Answers
• SAP HANA row and column store table
• Differentiating between row and column store table in SAP HANA database
• Functional difference of using row vs column store in SAP HANA
• Different table store type in SAP HANA Studio
• Store data in format of XML string in SAP HANA system
• Can MySQL automatically store timestamp in a row?
• How to store details in SAP-MDG?
• Creating column table in SAP HANA database
• How to store time created in a MySQL table?
• How to store XML data in a table in Oracle?
• How we can store Python functions in a Sqlite table?
• How to store a NULL value in a particular column of a DB2 table using COBOL-DB2 program?
• Can I define a column as a table type in SAP HANA?
• Converting BLOB to Char in SAP HANA using SQL
• Converting BLOB to Char in SAP HANA using SQL