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);

删除表

drop table fanruan_db.dws_alarm_detail;

🔗 Links

• clickhouse website