Symptom
How to create Multistore table in SAP HANA Dynamic Tiering (DT) ?
I'd like to store some part to SAP HANA and some parts to Extended Storage (DT).
A multistore table is a type of SAP HANA column table that can have some partitions in HANA default column storage and other partitions in a store associated with SAP HANA, such as extended storage.
Extended storage, provided by SAP HANA dynamic tiering, is the first — and currently only — additional store for multistore tables. Depending on application-specific criteria, SAP HANA partitions a column table and then distributes the partitions among the different stores.
(It uses the term 'default storage' instead of column store or in-memory store. Tables in default storage are known as column store tables, while tables in extended storage are known as extended store tables.)
Read more...
Environment
SAP HANA Platform Edition 2.0
Product
Keywords
Table partition, partition, Multistore, 'Extended storage', extended, HETEROGENEOUS, , KBA , HAN-DYT , SAP HANA Dynamic Tiering , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.