SAP Knowledge Base Article - Preview

3108533 - Creating Multistore table in SAP HANA Dynamic Tiering (DT) -- HAN-DYT

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

SAP HANA dynamic tiering all versions ; SAP HANA, platform edition 2.0

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.