clickHouse DDL

🧙 Questions

• 创建csv格式的表

☄️ Ideas

创建csv格式的表

create table if not exists fanruan_db.dwd_medcresdat(
    UNIT_ID varchar(500),
    lot_id varchar(500),
    mf1_wlm varchar(500),
    mf1_blm varchar(500),
    mf1_bsd varchar(500),
    mf2_wpc varchar(500),
    mf2_bpc varchar(500),
    mf2_bsd varchar(500),
    usable_tooth varchar(500) ,
    wheel_well_ratio varchar(500) ,
    tatal_grainding_time varchar(500) ,
    warm_up_time_current varchar(500) ,
    z_spindle_current varchar(500) ,
    spindle_rpm varchar(500) ,
    cooling_water varchar(500) ,
    cutting_water varchar(500) ,
    safty_cutting_water varchar(500) ,
    ipg_cooling_water varchar(500) ,
    usable_tooth_2 varchar(500) ,
    wheel_well_ratio_2 varchar(500) ,
    tatal_grainding_time_2 varchar(500) ,
    warm_up_time_current_2 varchar(500) ,
    z_spindle_current_2 varchar(500) ,
    spindle_rpm_2 varchar(500) ,
    cooling_water_2 varchar(500) ,
    cutting_water_2 varchar(500) ,
    safty_cutting_water_2 varchar(500) ,
    ipg_cooling_water_2 varchar(500) 
) ENGINE = MergeTree
ORDER BY tuple(UNIT_ID, lot_id, mf1_wlm);
SQL

CREATE TABLE users (
    username String,
    age UInt8
) ENGINE = MergeTree()
ORDER BY (username);
INSERT INTO users23 VALUES ('Alice', 25), ('Bob', 30), ('Charlie', 22);

CREATE TABLE users22 (
    username String COMMENT '用户的登录名，唯一标识',
    age UInt8 COMMENT '用户的年龄，范围 0-150'
) ENGINE = MergeTree()
ORDER BY (username)
COMMENT '存储系统用户的基本信息表';
SQL

删除表

drop table fanruan_db.dws_alarm_detail;
SQL

🔗 Links

• clickhouse website