search

apache / doris

Apache Doris is an easy-to-use, high performance and unified analytics database.
https://doris.apache.org
Apache License 2.0
12.79k stars 3.29k forks source link

SHOW ALL ROUTINE LOAD FOR example_db.o_suborder_load02; #5423

Open listenLearning opened 3 years ago

listenLearning commented 3 years ago

I use kafka to import data into doris, the information is as follows +-------+-------------------+---------------------+-----------+---------+----------------------------+------------+---------+----------------+----------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------+------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------+----------------------+--------------+----------+ | Id | Name | CreateTime | PauseTime | EndTime | DbName | TableName | State | DataSourceType | CurrentTaskNum | JobProperties | DataSourceProperties | CustomProperties | Statistic | Progress | ReasonOfStateChanged | ErrorLogUrls | OtherMsg | +-------+-------------------+---------------------+-----------+---------+----------------------------+------------+---------+----------------+----------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------+------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------+----------------------+--------------+----------+ | 10163 | o_suborder_load02 | 2021-02-25 13:52:35 | NULL | NULL | default_cluster:example_db | o_suborder | RUNNING | KAFKA | 1 | {"partitions":"","columnToColumnExpr":"sub_order_no,old_sub_order_no,order_no,sub_order_status,delivery_order_no,supplier_id,settle_status,sku_count,goods_count,goods_amount,money_off_amount,freight_fee_amount,redpacket_pay_amount,wallet_pay_amount,currency_pay_amount,pay_type_at_delivery,recv_confirm_time,lack_goods,complete_time,theory_volume,order_classify,first_delivery,create_time,update_time,pay_time,distribute_time,etl_insert_time,etl_update_time","maxBatchIntervalS":"20","whereExpr":"","dataFormat":"json","timezone":"Asia/Shanghai","mergeType":"APPEND","format":"json","json_root":"$.data","maxBatchSizeBytes":"209715200","exec_mem_limit":"2147483648","strict_mode":"false","jsonpaths":"[\"$.sub_order_no\",\"$.old_sub_order_no\",\"$.order_no\",\"$.sub_order_status\",\"$.delivery_order_no\",\"$.supplier_id\",\"$.settle_status\",\"$.sku_count\",\"$.goods_count\",\"$.goods_amount\",\"$.money_off_amount\",\"$.freight_fee_amount\",\"$.redpacket_pay_amount\",\"$.wallet_pay_amount\",\"$.currency_pay_amount\",\"$.pay_type_at_delivery\",\"$.recv_confirm_time\",\"$.lack_goods\",\"$.complete_time\",\"$.theory_volume\",\"$.order_classify\",\"$.first_delivery\",\"$.create_time\",\"$.update_time\",\"$.pay_time\",\"$.distribute_time\",\"$.etl_insert_time\",\"$.etl_update_time\"\n]","deleteCondition":"*","desireTaskConcurrentNum":"3","maxErrorNum":"0","strip_outer_array":"true","currentTaskConcurrentNum":"1","execMemLimit":"2147483648","maxBatchRows":"300000"} | {"topic":"mysql-155-binlog-ods_ppy_op_o_suborder","currentKafkaPartitions":"0","brokerList":"172.12.31.155:9092"} | {"group.id":"suborder_0101"} | {"receivedBytes":0,"errorRows":0,"committedTaskNum":0,"loadedRows":0,"loadRowsRate":0,"abortedTaskNum":0,"totalRows":0,"unselectedRows":0,"receivedBytesRate":0,"taskExecuteTimeMs":1} | {"0":"OFFSET_ZERO"} | | | | +-------+-------------------+---------------------+-----------+---------+----------------------------+------------+---------+----------------+----------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------+------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------+----------------------+--------------+----------+ But when I went to query, I found that be was all down, and then I went to check the log of be and saw the following message. After I stopped the import task, this error kept appearing. What caused this? image

listenLearning commented 3 years ago

![Uploading image.png…]()