SAP Knowledge Base Article - Preview

2758095 - Select doesn't return data from partition on extended storage - SAP Dynamic Tiering

Symptom

  • Use Data Lifecycle Manegement to create a rule to define a storage destination table to Dynamic Tiering.

In the following example, rows having I_COL column = 6 are stored in Dynamic Tiering.

        Rule.png

         Persist.png

  • When exececuting: select * from "SAPIBH"."/BIC/TEST", the rows located in the Dynamic Extended Storage for the I_COL column with values = 6 are not in the result set.

Read more...

Environment

  • SAP Dynamic Tiering 2.0
  • SAP HANA 2.0

Product

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

Keywords

pruning view , KBA , HAN-DYT , SAP HANA Dynamic Tiering , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.