DROP TABLE IF EXISTS AGG_PUSHDOWN_GB_FIND_MAX;
CREATE TABLE dbo.AGG_PUSHDOWN_GB_FIND_MAX (
    ID_1 BIGINT NULL,
    AGG_COLUMN BIGINT NOT NULL,
    INDEX CCI CLUSTERED COLUMNSTORE
);

INSERT INTO dbo.AGG_PUSHDOWN_GB_FIND_MAX WITH (TABLOCK)
SELECT
t.RN % 17000
, 0
FROM
(
    SELECT TOP (1 * 1048576) ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) RN
    FROM master..spt_values t1
    CROSS JOIN master..spt_values t2
) t
OPTION (MAXDOP 1);

-- hobt_id = 72057613141344256
-- column_id = 1
-- segment_id = 0
SELECT css.on_disk_size, css.hobt_id, css.column_id, css.segment_id
FROM sys.objects o
INNER JOIN sys.COLUMNS c ON o.object_id = c.object_id
INNER JOIN sys.partitions p ON o.object_id = p.object_id
INNER JOIN sys.column_store_segments css
    ON p.hobt_id = css.hobt_id
    AND css.column_id = c.column_id
INNER JOIN sys.column_store_dictionaries csd ON css.hobt_id = csd.hobt_id
AND csd.column_id = css.column_id
WHERE o.name = 'AGG_PUSHDOWN_GB_FIND_MAX'
AND c.name = 'ID_1';

SELECT DB_ID(); -- 7
dbcc traceon (3604);

dbcc csindex (7,72057613141344256,1,0,1,0);
-- Segment:0 for column: 1 not found
-- DBCC execution completed. If DBCC printed error messages, contact your system administrator.