variant字段解析问题,求助!

Viewed 18
SELECT business_info['role'] role from log

variant字段解析,报错信息如下:
[2024-11-14 20:23:33] [HY000][1105] errCode = 2, detailMessage = Syntax error in line 2:
[2024-11-14 20:23:33] business_info['role'] role
[2024-11-14 20:23:33] ^
[2024-11-14 20:23:33] Encountered: ROLE
[2024-11-14 20:23:33] Expected: ||, COMMA, ROLE is keyword, maybe `ROLE`

1 Answers

看样子是语法问题,根据提示加一个反引号