CLEAR OLAP INDEX SEGMENTS

Grammar

CLEAR [ ALL ] OLAP INDEX SEGMENTS <snap-qube> OF <fact-table> [ LISTONLY ]

Description

Use to clear disk caches on executor hosts. When ALL is specified, will clear all cached files; otherwise only files of older segments will be removed.

Examples

-- to clear older files
clear olap index segments snap_index on fact_table;

-- to clear all files
clear ALL olap index segments snap_index of fact_table