USE tpch1; drop table if exists test.mcol163; create table test.mcol163 (a int, b double, c double precision) engine=columnstore; insert into test.mcol163 values (1,1.1,1.1); select * from test.mcol163; a b c 1 1.1 1.1 drop table test.mcol163;