DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (a VARCHAR(10)) ENGINE=ColumnStore;

INSERT INTO t1 VALUES ('10.1');

SELECT

  a,

  CAST(a AS DECIMAL(10,1)),

  CAST(a AS DECIMAL(10,2)),

  CAST(a AS DECIMAL(10,3))

FROM t1;

+------+--------------------------+--------------------------+--------------------------+

| a    | CAST(a AS DECIMAL(10,1)) | CAST(a AS DECIMAL(10,2)) | CAST(a AS DECIMAL(10,3)) |

+------+--------------------------+--------------------------+--------------------------+

| 10.1 |                     10.1 |                    10.01 |                   10.001 |

+------+--------------------------+--------------------------+--------------------------+