SegmentCacheManager View

Use snap$segcachemanagersegments view to get an idea of the state of the cluster as seen by the Segment Cache Manager Output structure of the view is:

indexName : StringType
segmentName : StringType
partitionValues : StringType
host : StringType
hostpriority : IntegerType

Example

select * from `snap$segcachemanagersegments`