PROJECTION_COLUMNS

Provides information about projection columns, such as encoding type, sort order, type of statistics, and the time at which columns statistics were last updated. 提供投影列的信息，如编码类型、排序顺序、统计类型及上次统计更新时间。

图例

• ✅ = 字段存在于该版本
• ❌ = 字段不存在于该版本
• 备注列标注首次出现或类型变更的版本

字段名	Data Type	11.0.x	11.1.x	12.0.x	23.3.x	23.4.x	24.1.x	24.2.x	24.3.x	24.4.x	25.1.x	25.2.x	25.3.x	25.4.x	26.1.x	26.2.x	备注
ACCESS_RANK	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
COLUMN_EXPRESSION	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
COLUMN_ID	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
COLUMN_POSITION	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
DATA_TYPE	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
ENCODING_TYPE	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
GROUP_ID	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
IS_AGGREGATE	BOOLEAN	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
IS_EXPRESSION	BOOLEAN	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
ORDER_BY_POSITION	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
ORDER_BY_TYPE	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
PARTITION_BY_POSITION	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
PROJECTION_COLUMN_NAME	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
PROJECTION_ID	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
PROJECTION_NAME	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
SORT_POSITION	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
STATISTICS_TYPE	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
STATISTICS_UPDATED_TIMESTAMP	TIMESTAMPTZ	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
TABLE_COLUMN_ID	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
TABLE_COLUMN_NAME	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
TABLE_ID	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
TABLE_NAME	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
TABLE_SCHEMA	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
TABLE_NAMESPACE	VARCHAR	❌	❌	❌	❌	❌	❌	✅	✅	✅	✅	✅	✅	✅	✅	✅	24.2.x 新增