Encoding type vs encodings

what is the difference between encoding type specified in the projection_column table and encodings specified in column_storage table.

below is the sample data from


data_type encoding_type encodings compressions
varchar(12) AUTO String lzo
varchar(9) AUTO String lzo
varchar(9) AUTO String lzo
date AUTO Uncompressed int delta
date AUTO Uncompressed int delta
varchar(7) AUTO String lzo


  • What you have in the projection_columns is what you declare in the Create Projection DDL and the column projection is how it really store. For example AUTO means different things depending on the data type, or some encoding specified in the DDL have encoding and compression for example RLE encode and compress LZO.

    Does make sense?


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file