- 创建表
CREATE TABLE IF NOT EXISTS demo (
id INT NOT NUll,
floatvector ARRAY,
int8col TINYINT,
int16col INT,
int32col INT,
floatcol FLOAT,
doublecol DOUBLE,
varcharcol STRING,
boolcol BOOLEAN,
bfloat16vectorcol ARRAY,
float16vectorcol ARRAY,
binaryvectorcol BINARY ,
jsoncol STRING,
intarraycol ARRAY,
primary key(id)
);
2.创建20万条数据，条数更改transform中的数值即可
INSERT INTO demo select * from (
select CAST(data as INT),array(1.1f,1.2f,1.3f),1y,16,32,3.14f,3.1415926,"test",true,
array(-0.91015625f,0.26953125f,-0.609375f),array(1.1f,1.2f,1.3f),binary("12345678"),'{"a":1,"b":2,"c":3}',array(1,2,3,4)
from (select transform('for i inseq 1 200000; do echo $i; done') using 'sh' as (data)));
;
