First, I debug my regular expression online through Regex101, and successfully get the data I want. this is my debug url.
My Text STRING:
{"date":"2022-08-01T01:02:46.121911Z","log":"{\"log\":\"2022-08-01 01:02:46.121 [MyScheduler_Worker-9] INFO u001b[0;39m o.jeecg.modules.quartz.service.XpushRemoteService:38u001b[0;39m - push to xPush ,entity = {\"body\":{\"fileName\":\"ExamMonitor0801.xls\",\"attachment\":\"xpush/prod/dingNotifier/BI/d6bd7cd53b1248c4ba55110fda2c3370/0801 all exam monitor.xlsx\",\"userIds\":[\"193960304827593088\",\"28095501311142182\",\"21480733271214119\",\"01454058034930401224\"]},\"appId\":\"OTHERS\",\"topic\":\"BI_MONITOR_REPORT\"}rn\",\"stream\":\"stdout\",\"time\":\"2022-08-01T01:02:46.12183064Z\"}"}
My REGULAR EXPRESSION
\{\"date\":\"([^ ]*)\",\"log\":\"\{\\\"log\\\":\\\"(.+)(?=\\\",\\\"stream)
But When I use this regular expression to create a table in athena.it finally get null data.
Were you able to fix this issue, I have similar issue