Qinghui Xu
08/04/2022, 5:14 PMZhenyu Xing
08/09/2022, 8:29 AMKyle Meow
08/16/2022, 7:55 AMpingzhong
08/18/2022, 1:15 PMEric Liu
01/13/2023, 4:31 AMblob.fetch.num-concurrent
从50增加到200还是不行.. (Flink1.15.3)
2023-01-09 06:26:28,780 ERROR org.apache.flink.runtime.blob.BlobServerConnection [] - Error while executing BLOB connection.
java.io.IOException: Unknown operation 71
at org.apache.flink.runtime.blob.BlobServerConnection.run(BlobServerConnection.java:116) [flink-dist-1.15.3.jar:1.15.3]
肖文浩
02/16/2023, 5:54 AMTing Yin
02/21/2023, 2:43 AMTing Yin
02/21/2023, 2:45 AMZhiyu Tian
02/23/2023, 4:22 AMZhiyu Tian
03/09/2023, 2:50 AMBruce Lee (Unicorn)
03/16/2023, 9:10 AMBruce Lee (Unicorn)
04/04/2023, 10:03 AMBruce Lee (Unicorn)
04/07/2023, 1:44 AM刘路
05/10/2023, 6:29 AMakira
06/01/2023, 6:46 AMStan Hsu
07/13/2023, 2:54 AMINSERT INTO tidb_order_labels
WITH kafka_ticdc_orders_log_parsed AS (
-- tidb的cdc資料
SELECT
*
FROM
kafka_ticdc_orders_log
),
orders_all_state AS (
-- 利用kafka的order_id去查tidb的order歷程表,tidb_orders_log在tidb裡面pk是order_id+updated_at,
-- 所以來了一筆order_A,如果他有三筆歷程,就會查回像是order_A,T1/order_A,T2/order_A,T3
SELECT
orders_log.*,
kafka_ticdc_orders_log_parsed.proc_time
FROM
kafka_ticdc_orders_log_parsed
JOIN
tidb_orders_log FOR SYSTEM_TIME AS OF kafka_ticdc_orders_log_parsed.proc_time AS orders_log
ON
kafka_ticdc_orders_log_parsed.order_id = orders_log.order_id
),
orders_enrich_previous_state AS (
SELECT
order_id,
seller_id,
updated_at,
status,
previous_status
FROM (
-- 利用剛剛從tidb查回的歷程資料,算出每筆歷程的previous狀態,如下
-- order_id,updated_at,status, previous_status
-- order_A ,T1 ,active, null
-- order_A ,T2 ,cancelled, active
-- order_A ,T3 ,removed, active
-- order_A ,T3 ,removed, cancelled
-- 利用row_number去重複
-- order_id,updated_at,status, previous_status
-- order_A ,T1 ,active, null
-- order_A ,T2 ,cancelled, active
-- order_A ,T3 ,removed, cancelled
SELECT
t1.*,
t2.total_cents AS previous_total_cents,
0 AS previous_total_cost,
t2.status AS previous_status,
t2.edited_at AS previous_edited_at,
ROW_NUMBER() OVER (
PARTITION BY
t1.order_id, t1.updated_at
ORDER BY
t2.updated_at DESC
) AS rn
FROM
orders_all_state AS t1
LEFT JOIN
orders_all_state AS t2
ON
t1.order_id = t2.order_id
AND t1.updated_at > t2.updated_at
)
WHERE
rn = 1
)
SELECT
order_id,
seller_id AS merchant_id,
updated_at,
status,
previous_status,
CURRENT_TIMESTAMP as _processed_at
FROM
orders_enrich_previous_state
WHERE
order_id IS NOT NULL
AND updated_at IS NOT NULL
;
Mike Zhang
08/02/2023, 2:24 AMStephen Lii
08/16/2023, 11:08 AMStephen Lii
08/16/2023, 11:08 AMhan liu
09/11/2023, 2:57 PMZhenjiu Tian
10/30/2023, 8:53 AMXI XI
11/03/2023, 2:13 AMZhenjiu Tian
01/02/2024, 3:57 AMqinxiao
05/06/2024, 7:37 AMJingyu Zhao
05/09/2024, 11:22 PMZhenjiu Tian
05/27/2024, 5:44 AMShay Shen
05/31/2024, 10:12 AMhuangsijun17
07/01/2024, 10:30 AMZhenjiu Tian
09/12/2024, 6:12 AMZhenjiu Tian
09/12/2024, 10:31 AM