toms

#1566

hello, Doris Compaction 机制解析 https://mp.weixin.qq.com/s/5D1gAOEiFWM7N6KPwqHHdw Doris Stream Load 原理解析 https://mp.weixin.qq.com/s/zwiza9WXqo8n49PMgaUrKg Doris 索引机制解析 https://mp.weixin.qq.com/s/KdCdXb9Z3MdUZ5S0RV726Q Can you make me one of these three，thanks

this is sql:select string_to_array('dd,ee', ',')

this is sql: select ext_info::jsonb ->> 'orphan_unbind_type' from edw_ods.ods_xmt_invite_record;

pgsql: SELECT ods_day, modified, task_code, transaction_code, CAST(content AS JSON) ->> '$.eventType' AS eventType, CAST(content AS JSON) ->> '$.unionCodeResults' AS unionCodeResults FROM edw_f_zone.gugu_yf_transaction_detail_dd WHERE transaction_label = 'unioncodelist' AND CAST(ods_day AS DATE)...

mysql: SELECT ods_day, modified, task_code, transaction_code, CAST(content AS JSON) ->> '$."$.eventType"' AS eventType, CAST(content AS JSON) ->> '$."$.unionCodeResults"' AS unionCodeResults FROM edw_f_zone.gugu_yf_transaction_detail_dd WHERE transaction_label = 'unioncodelist' AND CAST(ods_day AS DATE)...

more,pgsql: SELECT SUBSTR(CAST((CAST('2024-04-15' AS DATE) + INTERVAL '1 month ago') AS varchar), 1,7); mysql: SELECT SUBSTR(CAST((CAST('2024-04-15' AS DATE) + INTERVAL '1 month ago') AS varchar), 1,7);

pgsql:`select * from (select 1 as obs, substring((current_time - interval '16 min') ::text, 1, 2) as value , (substring(current_time::text, 1, 2)::integer) || '>点' as name union all select 2 as...

pgsql: `select t1.rc_month, t2.id::varchar||'-'::varchar||t2.code_value overdue_reason,count(distinct loan_id) cnt from sherlock.t_dwp_jxj_bp_collect_record_rucui_trans_base t1 left join sherlock.t_overdue_reason_code t2 on t1.overdue_reason::bigint = t2.id WHERE t1.overdue_reason:: bigint not in (0 , 1 , 2 , 27)...

more, postgres: `select before_first_due_date::date + ((installment_count::int - 1) || ' month')::interval as clear_date from edw_dws.dws_unionloan_zhanqi_loan_df;` mysql: `SELECT CAST(before_first_due_date AS DATE) + CAST(((CAST(installment_count AS INT) - 1) || ' month') AS...