Symptom
An option to switch storage from memory to disk of apparently normal hana local table is not present.
Environment
SAP Datasphere
Reproducing the Issue
Open local table on data builder and notice no option to use other type of storage despite the same being created in a space with SAP HANA Cloud, where SAP HANA database storage the values can be "Disk" or "In-Memory".
Cause
This can be related to the object not being a normal table.
Run-time artifacts of local tables created on top of objects residing in open-sql schema are not HANA column tables but SQL views.
Resolution
These objects being SQL views do not hold data, therefore can't use 'Disk' storage.
If the load unit of related object is not optimal, you can change it by running DDL statement ALTER TABLE: Setting the Load Unit
If the data in memory is not required, you can test if the opensqlschema user has the privilege to run upload statement to upload data from memory: Load a Column Table into Memory, and Unload It from Memory
Keywords
in-memory, disk storage , KBA , DS-DI-TAB , Table Persistency , Problem
SAP Knowledge Base Article - Public