问题描述:
json格式不规范导致的,仅使用where+json_valid清洗似乎并不足以解决问题
解决方法:
select order_number,sku_code,CASE WHEN JSON_VALID(sales_price) THEN sales_price ELSE null END as sales_price from order_goods_snapshot
- quot json_extract truncation argument functionquot json_extract truncation argument number-of-buckets-specified 39 quot json_extract function-like arguments included function function compare typescript arguments quot connection attributes truncated arguments function python check quot locale-collate configuration arguments function argument python all importsnotusedasvalues quot functioning typescript quot addeventlistener function错误