Doris 常用的配置和命令

动态修改表的长度限制

查看哪些权限可以修改

SHOW FRONTEND CONFIG;

修改对应的权限

ADMIN SET FRONTEND CONFIG ("table_name_length_limit" = "256");

Doris相关的文档

修改添加表字段

ALTER TABLE doris_db.bpm_approve_list
    ADD COLUMN create_user_dept varchar(500)  DEFAULT "" AFTER create_user_name

创建routine load

CREATE
ROUTINE LOAD
bpm_operation_logs_v1_routine_load ON bpm_operation_logs
COLUMNS(
    _index,
    log_timestamp,
    log_level,
    log_thread,
    trace_id,
    logger,
    message
)
PROPERTIES(
    "format" = "json",
    "jsonpaths" = "[\"$.index\", \"$.log_timestamp\", \"$.log_level\", \"$.log_thread\", \"$.trace_id\", \"$.logger\", \"$.message\"]",
    "max_error_number" = "10000",
    "timezone" = "Asia/Shanghai"
)
FROM KAFKA(
    "kafka_broker_list" = "kafka-0.kafka-headless:9092",
    "kafka_topic" = "bpm-operation-logs-topic",
    "property.kafka_default_offsets" = "OFFSET_BEGINNING"
);

查询routine load

SHOW ROUTINE LOAD FOR example_routine_load_json_3;

SHOW ROUTINE LOAD TASK WHERE jobname = 'example_routine_load_json_2';

恢复 routine load

RESUME ROUTINE LOAD
FOR example_routine_load_json_2;

暂停routine load

PAUSE ROUTINE LOAD
FOR example_routine_load_json_2;

停止routine load

STOP
ROUTINE LOAD
FOR example_routine_load_json_2;

修改routine load

ALTER
ROUTINE LOAD
FOR example_routine_load_json_2
PROPERTIES(
    "desired_concurrent_number" = "3"
)
FROM KAFKA(
    "kafka_broker_list" = "kafka-0.kafka-headless:9092",
    "kafka_topic" = "test-routine-load-json",
);

查看正在进行的Schema Change作业

SHOW ALTER TABLE COLUMN WHERE TableName = 'c_znc_material_request_main_info';